70-450最も有効な質問と解答で勉強

You are a professional level SQL Sever 2008 Database Administrator in an international corporation named Wiikigo.
A 32-bit version is utilized by the instance on a Windows Server 2008 64-bit server. You activate the awe enabled option. A predictable increase in query activity will be experienced by the instance. You are required to figure out the most proper and beneficial time to have the databases migrated to a 64-bit SQL Server 2008 server on the same hardware.
A data collector type that proper information is provided should be identified.
What kind of collector should you utilize?

• A. You should utilize T-SQL Query collector
• B. You should utilize Performance Counters collector
• C. You should utilize Query Activity collector
• D. You should utilize SQL Trace collector

You are a professional level SQL Sever 2008 Database Administrator.
The security requirements should be designed for a new database application. A code segment is utilized by the application, and the code segment includes the following components:
A method that the registry is accessed on the SQL Server
A method that the file system is accessed on a network file server
A class definition that public static fields are utilized
SQL CLR integration is utilized by the code segment
The code segment is implemented as a single assembly.
Since you are the technical support, you are required to make sure that the application should be successfully deployed to the instance.
Which action will you perform?

• A. All public static fields should be replaced with public fields.
• B. All public static fields should be utilized with public static read-only fields. And then the assembly should be registered by utilizing the regasm.exe utility before deployment.
• C. All public static fields should be replaced with public static read-only fields. And then the EXTERNAL_ACCESS code access security should be utilized for the assembly.
• D. The SAFE code access security should be utilized for the assembly.

You are a professional level SQL Sever 2008 Database Administrator.
A database is included by an instance. And a large table named OrderDetails is included by the database. Only DML statements on the last three months data are executed by the application queries. Administrative audits are managed monthly on data which is longer than four months. The performance problems listed below are found by you in the database . The performance of the application queries against the OrderDetail table is poor. It takes a long time to perform the maintenance tasks against the database, index defragmentation is contained.
The performance problems should be solved with on impact on the server performance.
Which action will you perform?

• A. A database snapshot should be created for the OrderDetails table every four months. And then, the queries should be changed to utilize the present snapshot.
• B. An additional table named OrderDetailsHistory should be created for data older than four months. And then, the following Transact-SQL statement should be utilized. CREATE TRIGGER trgMoveDataON OrderDetailsAFTER INSERT ASINSERT INTO OrderDetailsHistory SELECT * FROM OrderDetailsWHERE DATEDIFF(m,OrderDate,GETDATE())>4
• C. An additional table named OrderDetailsHistory should be created for data older than four months. And then, the OrderDetails and OrderDetailsHistory tables should be partitioned in two parts by utilizing the OrderDate column. At last, a SQL Server Agent job that runs every month should be created and the ALTER TABLE...SWITCH Transact-SQL statement should be utilized to remove data that is longer than four months to the OrderDetailsHistory table.
• D. An additional table named OrderDetailsHistory should be created for data longer than four months. And then, a SQL Server Agent job that runs the following Transact-SQL statement every month should be created. INSERT INTO OrderDetailsHistory SELECT * FROM OrderDetailsWHERE DATEDIFF(m, OrderDate,GETDATE())>4

You administer a SQL Server 2008 instance.
You plan to deploy multiple databases to the instance. You design the security policy for the instance.
A stored procedure verifies the partition compression settings on each database deployed to the instance.
You plan to use a policy to execute the stored procedure.
You need to ensure that the policy is enforced by using Policy-Based Management Framework.
What should you do?

• A. Grant EXECUTE permissions on the stored procedure to the SQLAgent service account.
• B. Enable the nested triggers server configuration option.
• C. Grant EXECUTE permissions on the stored procedure to the ##MS_PolicyTsqlExecutionLogin## login.
• D. Grant EXECUTE permissions on the stored procedure to the ##MS_PolicyEventProcessingLogin## login.

Your organization has many servers that run SQL Server 2008.
You define a rule to ensure that all database servers have Database Mail disabled.
You need to be able to identify and resolve any violation of the rule by using the minimum amount of administrative effort.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A. Define a maintenance plan on each database server.
• B. Define a SQL Server policy and import it on each database server.
• C. Define a scheduled task on each server.
• D. Define a SQL job on each database server.