為大家收集整理了《微軟認(rèn)證考試70-432練習(xí)試題14》供大家參考，希望對(duì)大家有所幫助?。?！
QUESTION 66
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance which contains a database.
According to the company requirement, you have to move the application from Microsoft SQL Server 2000 to Microsoft SQL Server 2008. You have to monitor the SQL Server instance to record the
use of features. These features will be discontinued. What should you do?
A.The SQL Server 2008 Upgrade Advisor should be used.
B.The SQL Server Profiler which captures the SQL:BatchCompleted and Exception event classes should be used.
C.A SQL server-side trace that captures the Deprecation Announcement and Deprecation Final Support event classes should be used
D.A SQL server-side trace that captures the SQL:BatchCompleted and Exception event classes should be used.
Answer: C
QUESTION 67
You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008
instance. There is a database named DB1 in the instance. DB1 has two filegroups: one is a filegroup named History that contains historical data stored in the G: volume; the other is the PRIMARY
filegroup that contains the On-Line Transaction Processing (OLTP) data stored in the F: volume. The backup strategy of DB1 has three requirements: first, the History filegroup should be backed up
at the end of each working day; second, the PRIMARY filegroup should be backed up five times a day; third, the transaction log should be backed up every quarter. You get a report at 13:00 saying
that the volume which contains the History filegroup fails.
As the technical support, you have to restore the database, and you must reduce the data loss to the least as soon as possible.
What should you do?
A.You should restore the most recent backup of the History filegroup.
B.You should restore the most recent backup of the History filegroup. Restore all the transaction log backups after the most recent backup of the History filegroup
C.You should backup the transaction log. Then restore the most recent backup of the PRIMARY filegroup and restore the most recent backup of the History filegroup. After the most recent
backup of the History filegroup, restore all the transaction log backups
D.You should backup the transaction log. Then restore the most recent backup of the History filegroup and restore all the transaction log backups after the most recent backup of the History
filegroup.
Answer: D
QUESTION 68
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance which contains a database. Now
your company CIO assigns a task to you. You have to check the performance of the SQL Server 2008 instance. You have to find out which common language runtime (CLR) queries takes the
longest-running time. So in the options below, which dynamic management view should you choose to use?
A.sys.dm_os_wait_stats
B.sys.dm_exec_requests
C.sys.dm_exec_sessions
D.sys.dm_exec_query_stats
Answer: D
QUESTION 69
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. The instance has databases for a
finance application and a manufacturing application. You want to put some limitation on the maximum CPU query time allowed by the applications, so you configure the Resource Governor to
achieve this. But you notice that certain reports do not execute successfully any longer on the manufacturing application. You have to allow the manufacturing application to consume more CPU
time, so you have to change the Resource Governor configuration. Which Resource Governor component should you configure?
A.The workload group which is used by default
B.The workload group which is used by the finance application
C.The classifier function which identifies the finance application
D.The workload group which is used by the manufacturing application
Answer: D
QUESTION 70
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. For some reason, now the company
wants to view the number of users who access the SQL Server instance. The company CIO assigns this task to you. You have to use Windows System Monitor to find out the concrete number. Which
performance object should you capture?
A.SQLServer:Buffer Manager
B.SQLServer:Access Methods
C.SQLServer:General Statistics
D.SQLServer:Exec Statistics
Answer: C
QUESTION 66
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance which contains a database.
According to the company requirement, you have to move the application from Microsoft SQL Server 2000 to Microsoft SQL Server 2008. You have to monitor the SQL Server instance to record the
use of features. These features will be discontinued. What should you do?
A.The SQL Server 2008 Upgrade Advisor should be used.
B.The SQL Server Profiler which captures the SQL:BatchCompleted and Exception event classes should be used.
C.A SQL server-side trace that captures the Deprecation Announcement and Deprecation Final Support event classes should be used
D.A SQL server-side trace that captures the SQL:BatchCompleted and Exception event classes should be used.
Answer: C
QUESTION 67
You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008
instance. There is a database named DB1 in the instance. DB1 has two filegroups: one is a filegroup named History that contains historical data stored in the G: volume; the other is the PRIMARY
filegroup that contains the On-Line Transaction Processing (OLTP) data stored in the F: volume. The backup strategy of DB1 has three requirements: first, the History filegroup should be backed up
at the end of each working day; second, the PRIMARY filegroup should be backed up five times a day; third, the transaction log should be backed up every quarter. You get a report at 13:00 saying
that the volume which contains the History filegroup fails.
As the technical support, you have to restore the database, and you must reduce the data loss to the least as soon as possible.
What should you do?
A.You should restore the most recent backup of the History filegroup.
B.You should restore the most recent backup of the History filegroup. Restore all the transaction log backups after the most recent backup of the History filegroup
C.You should backup the transaction log. Then restore the most recent backup of the PRIMARY filegroup and restore the most recent backup of the History filegroup. After the most recent
backup of the History filegroup, restore all the transaction log backups
D.You should backup the transaction log. Then restore the most recent backup of the History filegroup and restore all the transaction log backups after the most recent backup of the History
filegroup.
Answer: D
QUESTION 68
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance which contains a database. Now
your company CIO assigns a task to you. You have to check the performance of the SQL Server 2008 instance. You have to find out which common language runtime (CLR) queries takes the
longest-running time. So in the options below, which dynamic management view should you choose to use?
A.sys.dm_os_wait_stats
B.sys.dm_exec_requests
C.sys.dm_exec_sessions
D.sys.dm_exec_query_stats
Answer: D
QUESTION 69
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. The instance has databases for a
finance application and a manufacturing application. You want to put some limitation on the maximum CPU query time allowed by the applications, so you configure the Resource Governor to
achieve this. But you notice that certain reports do not execute successfully any longer on the manufacturing application. You have to allow the manufacturing application to consume more CPU
time, so you have to change the Resource Governor configuration. Which Resource Governor component should you configure?
A.The workload group which is used by default
B.The workload group which is used by the finance application
C.The classifier function which identifies the finance application
D.The workload group which is used by the manufacturing application
Answer: D
QUESTION 70
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. For some reason, now the company
wants to view the number of users who access the SQL Server instance. The company CIO assigns this task to you. You have to use Windows System Monitor to find out the concrete number. Which
performance object should you capture?
A.SQLServer:Buffer Manager
B.SQLServer:Access Methods
C.SQLServer:General Statistics
D.SQLServer:Exec Statistics
Answer: C