70-450 試験問題を無料オンラインアクセス

Your SQL Server 2008 server has only the SQL Server service running. All other SQL Services are disabled.
You have a user named DBReportsUser. You need to restrict DBReportsUser to login only between 17:00 hours and 22:00 hours. You want to achieve this goal by using the minimum amount of administrative effort and the least impact on the Server security.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A.Create a SQL Server Agent job.
• B.Enable login auditing.
• C.Use a logon trigger.
• D.Use SQL Profiler.

You administer a SQL Server 2008 infrastructure.
Developers in your company have rights to author policies. A test server is used to develop and test the
policies.
The Policy-Based Management feature generates SQL Server Agent alerts when a policy is violated.
The developers are able to create and modify policies, but are unable to test policy violation alerts.
You need to grant the necessary permission to the developers to test the policies. You also need to comply
with
the least privilege principle when you grant the permission.
What should you do?

• A.Add the developers to the sysadmin server role.
• B.Grant the EXECUTE permission on the sys.sp_syspolicy_execute_policy stored procedure to the developers.
• C.Add the developers to the PolicyAdministratorRole role in the MSDB database.
• D.Grant the ALTER TRACE permission to the developers.

You administer a SQL Server 2008 instance.
You plan to design a monitoring solution for the instance to monitor object usage statistics.
The solution must identify a list of first 10 objects for each of the following components:
Most frequently executed stored procedures and functions
Long running Transact-SQL statements
You need to implement the monitoring solution to minimize performance effect by using the least amount of administrative effort.
What should you do?

• A.Use a client-side SQL Server Profiler trace.
• B.Use a server-side SQL Server Profiler trace.
• C.Use dynamic management views.
• D.Use a System Monitor counter log.

You are a professional level SQL Sever 2008 Database Administrator.
The solution is log-shipped for high-availability purposes. The data files of the database reside on drive D,
while the transaction log files of the database reside on drive E. A restoring test plan should be
implemented
to satisfy the requirements listed below for the log-shipping solution.
First, the secondary database is brought online in the shortest time.
Secondly, the data is in a consistent state.
Thirdly, the data loss is reduced to the least.
The first step for the recovery test plan should be identified in the event of drive D failure.
Which step should be performed?

• A.You should bring the secondary database online.
• B.You should perform the tail-log backup of the primary database.
• C.You should execute the DBCC CHECKDB command along with the REPAIR_REBUILD option against the primary database.
• D.You should execute the DBCC CHECKDB command along with the REPAIR_ALLOW_DATA_LOSS option against the primary database.

You administer a SQL Server 2008 instance.
The instance hosts a database that contains sensitive data. You plan to implement a database backup strategy for the database.
You need to ensure that all backups of the database are encrypted. You also need to prevent unauthorized access of the backups.
What should you do?

• A.Use Transparent database encryption.
• B.Use Windows BitLocker Drive Encryption technology.
• C.Use the BACKUP statement along with the PASSWORD option.
• D.Use the BACKUP statement along with the MEDIAPASSWORD option.