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

You are configuring a new SQL Server installation.
The SQL Server instance will be used for both online analytical processing (OLAP) and relational data. The data in the server is accessed frequently. You can configure the services, startup type, and accounts used by the services that run on the server according to the following table:

You want to raise the level of security on the server. You need to minimize the surface area for potential attacks on the server.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A.Create three different non-administrative local user accounts and assign them to each of the services.
• B.Change the Startup type property for all the services to Manual.
• C.Create a single non-administrative local user account and assign it to each of the services.
• D.Change the Startup type property for all the services to Disabled.

You are a professional level SQL Sever 2008 Database Administrator.
It is on a four-processor, quad-core server. CPU pressure is regularly experienced by the server. An extremely large mission-critical database is consisted by the instance, and it is utilized constantly. The online index rebuilds should not occupy all available CPU cycles.
From the following four configurations, which one should you utilize?

• A.You should utilize affinity mask.
• B.You should utilize optimize for ad hoc workloads.
• C.You should utilize affinity I/O mask.
• D.You should utilize max degree of parallelism.

You administer a SQL Server 2008 infrastructure. You plan to design an infrastructure for a new application.
The application has the following requirements:
Users can connect to an instance named SQLSERVER1.
SQLSERVER1 is linked to a server named SQLSERVER2.
SQLSERVER1 and SQLSERVER2 run on different computers.
The SQL Server instances use only Windows authentication.
You need to configure the infrastructure to ensure that the distributed queries are executed in the Windows security context of the login.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

• A.Configure all servers to use the Shared Memory network protocol.
• B.Use the local computer account as a service account for SQLSERVER1 and SQLSERVER2.
• C.Create a map for each SQL login from SQLSERVER1 to SQLSERVER2 and use the impersonate option.
• D.Ensure that the two instances use the same Windows account for the Microsoft SQL Service. Create the link so that each account uses the current security context.
• E.Register a server principal name (SPN) for SQLSERVER1 and SQLSERVER2.

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.Enable the nested triggers server configuration option.
• B.Disable the nested triggers server configuration.
• C.Use the Local Service account for the SQLAgent service.
• D.Use a domain account for the SQLAgent service.

You administer a SQL Server 2008 instance that hosts a large financial database.
The database has the following backup strategies:
A full database backup is performed once a week.
A differential backup is performed every day.
A transaction log backup is performed every hour.
You plan to execute an end-of-year batch process that takes two hours to run. The batch process will modify about five percent of data within the database.
You need to ensure that if the Finance department does not approve the batch process, the batch operation can be rolled back in minimum possible time.
What should you do prior to starting the batch process?

• A.Create a database snapshot.
• B.Perform a differential backup.
• C.Create a marked transaction. Perform a transaction log backup.
• D.Record the time before the batch operation. Perform a transaction log backup.