MCTSMCTS(70-432)單項(xiàng)選擇題每日一練(2019.01.06)

A.ServiceGreatUser should be added to the appropriate fixed database roles. 
B.You should assign the appropriate object-level permissions to ServiceGreatUser 
C.You should assign the appropriate server-level permissions to ServiceGreatLogin 
D.You should assign the appropriate database-level permissions to ServiceGreatUser

A.For the AdventureWorks database, enable Server Auditing 
B.First you should set the appropriate trace flags as a startup parameter, and then restart the SQL Server instance 
C.You should configure the data collector and make it capture the deadlock graphs
D.You should configure a SQL Profiler trace, and make it capture the deadlock graphs

A.For the SQL Server Agent, you should enable a fail-safe operator 
B.You should modify the database maintenance plan, making it send an e-mail to the appropriate operators 
C.You should modify the database maintenance plan, making it include a Notify Operator task that e-mails the appropriate operators. 
D.You should modify the SQL Server Agent job. The job executes the database maintenance plan to notify the appropriate operators.

A.You should use the EXTENDED_LOGICAL_CHECKS option to execute a DBCC CHECKDB statement on the AdventureWorks database by. 
B.You should identify whether the SQL Server Agent is started on the primary server. 
C.You should identify whether the AdventureWorks database uses the Simple recovery model. 
D.You should identify whether the SQL Server Volume Shadow Copy Service (VSS) Writer is started on the primary server

A.A full database backup should be performed once daily. During business hour, a transaction log backup should be performed every two hours. 
B.A full database backup should be performed once daily 
C.A full database backup should be performed once daily. During business hours, a differential backup should be performed every two hours 
D.Perform a full database backup should be performed once every week. A differential backup should be performed once daily. During business hours a transaction log backup should be performed every two hours.