070-450 무료 덤프문제 온라인 액세스

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.The SAFE code access security should be utilized for the assembly.
• 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.All public static fields should be replaced with public fields.

You are a professional level SQL Sever 2008 Database Administrator.
A maintenance strategy should be designed for a mission-critical database, and a large table named Orders is contained by the database. Index maintenance operations are contained in the design plan. When you design the strategy, the facts listed below should be taken into consideration.
First, the users continuously access to the Orders table in the database.
Secondly, a column of the xml data type is contained by Orders table.
Thirdly, the new rows are regularly added to the Orders table.
Fourthly, the average fragmentation for the clustered index of the Orders table is no more than 2
percent.
A strategy should be designed to have the performance of the queries on the table optimized.
Which action will you perform?

• A.The clustered index of the Orders table offline should be rebuilt once a month.
• B.The clustered index of the Orders table should be reorganized by reducing the fill factor.
• C.The clustered index of the Orders table should be excluded from scheduled reorganizing or rebuilding operations.
• D.The clustered index of the Orders table should be dropped.

You administer a SQL Server 2008 instance.
Your company security policy is designed to prevent changes to the server to the server configuration. You plan to use Policy-Based Management Framework to implement the security policy.
You need to ensure that the policy is configured to meet the security requirement.
What should you do?

• A.Use the Local Service account for the SQLAgent service.
• B.Disable the nested triggers server configuration.
• C.Use a domain account for the SQLAgent service.
• D.Enable the nested triggers server configuration option.

You administer a SQL Server 2008 instance for your company. Your company has a team of database administrators.
A team of application developers create SQL Server 2008 Integration Services (SSIS) packages on the test server in a shared project. One of the packages requires a fixed cache file. On completion of development, the packages will be deployed to the production server.
Only the database administrators can access the production server.
You need to ensure that the application developers can deploy the project successfully to the production server.
What should you do?

• A.Create a deployment utility for the SSIS project.
• B.Create a direct package configuration for each package.
• C.Create an indirect package configuration for all packages.
• D.Use the Import and Export Wizard to save packages.

You administer a SQL Server 2008 infrastructure.
Humongous Insurance has 20 branch offices that store customer data in SQL Server 2008 databases. Customer data that is stored across multiple database instances has to be security compliant.
You plan to design a strategy for custom policies by using the Policy-Based Management feature. Custom policies are in XML format.
The strategy must meet the following requirements:
Custom policies are distributed to all instances.
The policies are enforced on all instances.
You need to implement the strategy by using the least amount of administrative effort.
What should you do?

• A.Use the Distributed File System Replication service.
• B.Distribute the policies by using Group Policy Objects.
• C.Use a configuration server.
• D.Distribute the policies by using the Active Directory directory service