MCSA : SQL Server 2008 70-432 TSQL Exam Paper with Solution
You work as a database administrator at ABC.com. ABC.com is planning to migrate a SQL Server 2000 application to SQL Server 2008 R2.After the migration, you want to keep an eye on the performance of the SQL Server 2008 R2 instance. You then configure a SQL server-side trace that captures the Deprecation Announcement and Deprecation Final Support event classes.
Which two of the following best describes these two event classes respectively? (Choose two.)
A. The Deprecation Final Support event class reveals that a feature will be removed in the next important
release of SQL Server.
B. The Deprecation Announcement event class reveals that a feature will be removed in the next important
release of SQL Server.
C. The Deprecation Announcement event class reveals that a feature will be removed in an upcoming edition
of SQL Server.
D. The Deprecation Final Support event class reveals that a feature will be removed in an upcoming edition of SQL Server.
Correct Answer: AC
You work as a database administrator at ABC.com. ABC.com makes use of a SQL Server 2008 R2 instance that includes an On-Line Analytical Processing (OLAP) database.
The OLAP database hosts a dimension table, named ABCClients, which has hourly information updates configured. As a result, ABCClients has a large quantity of information that is no longer used. You have been instructed to make sure that the amount of space used by the ABCClients table is reduced with as little administrative effort as possible.
Which of the following actions should you take?
A. You should consider manually deleting the information that is no longer used.
B. You should consider making use of page compression.
C. You should consider making use of the Disk Cleanup Wizard.
D. You should consider making use of folder compression.
Correct Answer: B
You work as a database administrator at ABC.com. ABC.com makes use of a SQL Server 2008 R2 instance that includes an On-Line Analytical Processing (OLAP) database.
The OLAP database hosts a dimension table, named ABCClients, which has hourly information updates configured. As a result, ABCClients has a large quantity of information that is no longer used. You have been instructed to make sure that the amount of space used by the ABCClients table is reduced with as little administrative effort as possible.
Which of the following actions should you take?
A. You should consider manually deleting the information that is no longer used.
B. You should consider making use of page compression.
C. You should consider making use of the Disk Cleanup Wizard.
D. You should consider making use of folder compression.
Correct Answer: B
No comments:
Post a Comment