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

You are designing a database solution by using SQL Server 2008.
The database has a large number of tables that have columns that contain sensitive data. The sensitive data must be protected.
You need to choose an encryption strategy that has the minimum effect on the performance of the server.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A.Use Cell-Level Encryption.
• B.Use Transparent Data Encryption (TDE).
• C.Use Encrypting File System.
• D.Use Bitlocker Encryption.

You are a professional level SQL Sever 2008 Database.
A new database application is hosted by the instance. The security requirements should be designed for the application. A unique login to the SQL Server 2008 server is assigned to each application user. Stored procedures are included by the application database to execute stored procedures in the MSDB database. SQLAgent jobs are scheduled by the stored procedures in the MSDB database.
Since you are the technical support, you are required to confirm that the stored procedures in the MSDB database should be executed by utilizing the security context of the application user.
Which action should you perform?

• A.Each user should be added to the db_dtsltduser database role in the MSDB database.
• B.The MSDB database should be set to utilize the TRUSTWORTHY option, and then each user should be added to the MSDB database.
• C.Each user should be added to the public role in the MSDB database.
• D.The new database should be set to utilize the TRUSTWORTHY option, and then each user should be added to the MSDB database.

You administer a SQL Server 2008 infrastructure.
The instance contains a database required for the day-to-day business of your company. Users experience slow response time when they execute reports.
You plan to design a performance monitoring strategy that captures and stores the following data:
Executed Transact-SQL statements and query activity.
Blocking and deadlock information.
Counters for disk, CPU, and memory.
You need to implement the monitoring process by using the minimum amount of administrative effort.
What should you do?

• A.Use the System Monitor counter log trace.
• B.Use the dynamic management views.
• C.Use the client-side profiler trace.
• D.Use the data collector

You are a professional level SQL Sever 2008 Database Administrator.
There are 30 branch offices in DoubleSecurity Insurance, and in the branch offices, customer data are stored in SQL Server 2008 databases. Customer data should be security compliant if it is stored through multiple database instances.
You intend to utilize the Policy-Based Management feature to design a strategy for custom policies. And the format of custom policies is XML format. The requirements listed below should be satisfied.
The company distributes custom policies to all instances. In addition, the company enforces the policies on all instances. A strategy should be thought out and the minimum amount of administrative effort should be utilized.
Which action should you perform to finish the task?

• A.To finish the task, the policies should be distributed by utilizing the Active Directory directory service.
• B.To finish the task, the Distributed File System Replication service should be utilized.
• C.To finish the task, the policies should be distributed by utilizing Group Policy Objects.
• D.To finish the task, a configuration server should be utilized.

You administer a SQL Server 2008 infrastructure.
Your company requires capacity planning information.
You need to design a long-term infrastructure monitoring strategy.
Which two tasks should you include in your design? (Each correct answer presents part of the solution. Choose two.)

• A.Clear the system log and the application log every hour.
• B.Create a maintenance plan that rebuilds indexes every week.
• C.Review system monitor counters on a regular basis.
• D.Baseline the system before you deploy production databases.
• E.Backup all databases every day.