為大家收集整理了《微軟認證考試70-432練習(xí)試題12》供大家參考，希望對大家有所幫助?。?！
QUESTION 56
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. You have set the recovery model of DB1 to Full. At 2:00 There is a full database backup of all the user databases every day. Every quarter
the transaction log backup is performed. Every 4 hours a differential backup is occurred. You are going to perform a full backup of DB1 at 11:00.
When you perform this back up, you must make sure that the overall backup will not be affected. What's more, you have to restore procedures for DB1. You must make sure that the backup files are
restored in proper sequence.
In the options below, which Transact-SQL statement should you use?
A.BACKUP LOG DB1 TO DISK = 't:\backups\db1.trn';
B.BACKUP DATABASE DB1 TO DISK = 't:\backups\db1.bak' WITH DIFFERENTIAL;
C.BACKUP DATABASE DB1 TO DISK = 't:\backups\db1.bak' WITH NOUNLOAD;
D.BACKUP DATABASE DB1 TO DISK = 't:\backups\db1.bak' WITH COPY_ONLY;
Answer: D
QUESTION 57
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. Now you get an order from your
company CIO, you have to identify whether a database integrity check (DBCC CHECKDB) was run for a particular database. Which log file should you examine?
A.log.trc
B.default.trc
C.ERRORLOG
D.SQLAGENT
Answer: C
QUESTION 58
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 on the same physical computer.
Now users report that they are unable to connect to the named instances. You check and verify that they can only connect to the default instance. You also ensure that all SQL Server instances run
normally. You have to start the service which is required to connect to the named instances. Which service should you start?
A.Server
B.SQL Server Agent
C.SQL Server Browser
D.SQL Active Directory Helper
Answer: C
QUESTION 59
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. There are user-defined stored
procedures. Now you have to make sure two things, first, the names of all user-defined stored procedures must contain the prefix usp_ on all instances; second, stored procedures that do not
contain this prefix cannot be created by you. So what should you do to ensure this two?
A.You should create a policy that targets the name of the stored procedure that is evaluated on change.
B.You should create a policy that targets the name of the stored procedure that is evaluated on demand.
C.You should create a condition that targets the name of stored procedure that is evaluated on demand.
D.You should create a condition that targets the name of the stored procedure that is evaluated on change.
Answer: A
QUESTION 60
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. A new SQL Agent job has been
created by you. The job includes a Windows PowerShell job step which transfer data between servers by using the SQLCmd utility. If the job fails, you must make sure that an operator named
ReactGroup is informed by receiving an e-mail. So what action should you perform to achieve this goal?
A.First you should enable Notifications. Direct the Notification to the ReactGroup operator on job failure after you create the ReactGroup operator.
B.First you should enable Notifications. Direct the Notification to the ReactGroup operator on failure of the Powershell job step after you create the ReactGroup operator.
C.First you should assign the ReactGroup operator as the failCsafe operator. Then enable the job after you create the ReactGroup operator.
D.First you should configure the job step proxy account to use the ReactGroup operator account after you create the ReactGroup operator. At last choose the proxy account for the e-mail
profile.
Answer: A
QUESTION 56
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. You have set the recovery model of DB1 to Full. At 2:00 There is a full database backup of all the user databases every day. Every quarter
the transaction log backup is performed. Every 4 hours a differential backup is occurred. You are going to perform a full backup of DB1 at 11:00.
When you perform this back up, you must make sure that the overall backup will not be affected. What's more, you have to restore procedures for DB1. You must make sure that the backup files are
restored in proper sequence.
In the options below, which Transact-SQL statement should you use?
A.BACKUP LOG DB1 TO DISK = 't:\backups\db1.trn';
B.BACKUP DATABASE DB1 TO DISK = 't:\backups\db1.bak' WITH DIFFERENTIAL;
C.BACKUP DATABASE DB1 TO DISK = 't:\backups\db1.bak' WITH NOUNLOAD;
D.BACKUP DATABASE DB1 TO DISK = 't:\backups\db1.bak' WITH COPY_ONLY;
Answer: D
QUESTION 57
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. Now you get an order from your
company CIO, you have to identify whether a database integrity check (DBCC CHECKDB) was run for a particular database. Which log file should you examine?
A.log.trc
B.default.trc
C.ERRORLOG
D.SQLAGENT
Answer: C
QUESTION 58
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 on the same physical computer.
Now users report that they are unable to connect to the named instances. You check and verify that they can only connect to the default instance. You also ensure that all SQL Server instances run
normally. You have to start the service which is required to connect to the named instances. Which service should you start?
A.Server
B.SQL Server Agent
C.SQL Server Browser
D.SQL Active Directory Helper
Answer: C
QUESTION 59
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. There are user-defined stored
procedures. Now you have to make sure two things, first, the names of all user-defined stored procedures must contain the prefix usp_ on all instances; second, stored procedures that do not
contain this prefix cannot be created by you. So what should you do to ensure this two?
A.You should create a policy that targets the name of the stored procedure that is evaluated on change.
B.You should create a policy that targets the name of the stored procedure that is evaluated on demand.
C.You should create a condition that targets the name of stored procedure that is evaluated on demand.
D.You should create a condition that targets the name of the stored procedure that is evaluated on change.
Answer: A
QUESTION 60
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. A new SQL Agent job has been
created by you. The job includes a Windows PowerShell job step which transfer data between servers by using the SQLCmd utility. If the job fails, you must make sure that an operator named
ReactGroup is informed by receiving an e-mail. So what action should you perform to achieve this goal?
A.First you should enable Notifications. Direct the Notification to the ReactGroup operator on job failure after you create the ReactGroup operator.
B.First you should enable Notifications. Direct the Notification to the ReactGroup operator on failure of the Powershell job step after you create the ReactGroup operator.
C.First you should assign the ReactGroup operator as the failCsafe operator. Then enable the job after you create the ReactGroup operator.
D.First you should configure the job step proxy account to use the ReactGroup operator account after you create the ReactGroup operator. At last choose the proxy account for the e-mail
profile.
Answer: A