Latest MCTS 70-432 Dumps Real Exam Download 211-220

Ensurepass

QUESTION 211

You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008 R2 instance that includes a database named ABCSales.

Minimal changes to the information in ABCSales take place on a daily basis. You have been instructed to devise a solution that produces for a read-only copy of the database. Furthermore, the solution has to run every morning and should consume as little disk resources as possible.

Which of the following actions should you take?

 

A. You should consider configuring the use of database snapshots.

B. You should consider configuring the use of transaction log backups.

C. You should consider configuring the use of differential backups.

D. You should consider configuring the use of incremental backups.

 

Correct Answer: A

Explanation/Reference:

 

 

QUESTION 212

You work as a database administrator at ABC.com. You are responsible for managing a SQL Server 2008 R2 instance.

ABC.com has an Internet Information Services (IIS) application that should be able to log on to the SQL Server Analysis Services (SSAS) instance anonymously.

Which of the following actions should you take?

 

A. You should consider having the SecurityRequireClientAuthentication server configuration property disabled.

B. You should consider having the SecurityRequireClientAuthentication server configuration property enabled.

C. You should consider configuring the SecurityRequireServerAuthenticationserver configuration property with the default value.

D. You should consider configuring the SecurityRequireClientAuthentication server configuration property with the default value.

 

Correct Answer: A

Explanation/Reference:

 

 

QUESTION 213

You work as a database administrator at ABC.com. ABC.com makes use of a SQL Server 2008 R2 instance. You have been instructed to make sure that all stored procedures that are defined by ABC.com’s users make use of the prefix usp_. You are also instructed to make sure that administrators are prevented from creating stored procedures that do not make use of the prefix usp_. Which of the following actions should you take? (Choose all that apply.)

 

A. You should consider generating a policy that targets the name of the stored procedure, which is evaluated on change.

B. You should consider generating a condition that targets the name of the stored procedure, which is evaluated on change.

C. You should consider assigning minimum permissions to all administrators.

D. You should consider creating a trigger.

 

Correct Answer: A

Explanation/Reference:

 

 

QUESTION 214

You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008 R2 instance that contains a database named ABCSales.

Minimal changes to the information in ABCSales take place on a daily basis. You have been instructed to devise a solution that minimizes administrative overhead for the transaction log of ABCSales.

Which of the following actions should you take?

 

A. You should consider making having the full recovery model configured for ABCSales.

B. You should consider having the simple recovery model is configured for ABCSales.

C. You should consider running the SQL Server Profiler on ABCSales.

D. You should consider configuring ABCSales to make use of the checksum page verify option.

 

Correct Answer: B

Explanation/Reference:

 

 

QUESTION 215

You work as a database administrator at ABC.com.ABC.com is making use SQL Server 2008 R2 in their environment.

ABC.com has a server, named ABC-SR07, which runs an instance of SQL Server 2008 R2 and has multiple applications installed.

You have configured the SQL Server Agent service to make use of the ABC-SR07/ACCOUNT. You then configured a job that must be written to a database server. You now need to make sure that only the SQL

Server Agent service has read and write permissions to the database server.

Which of the following actions should you take?

 

A. You should consider configuring the SQL Server Agent service to make use of a global Administrator account.

B. You should consider configuring the SQL Server Agent service to make use of a proxy account.

C. You should consider configuring the SQL Server Agent service to make use of a Local Service account.

D. You should consider configuring the SQL Server Agent service to make use of a remote System account.

 

Correct Answer: C

Explanation/Reference:

 

 

QUESTION 216

You work as a database administrator at ABC.com.ABC.com is making use of a SQL Server 2008 R2 instance that contains a database named ABC_Prod1.

You have been instructed to devise a strategy that produces a read-only duplication of ABC_Prod1 at the start of each business day. This duplication will be used as a reporting tool. Your strategy should also have a minimal effect on ABC_Prod1.

Which of the following actions should you take?

 

A. You should consider configuring the use of the simple recovery model.

B. You should consider frequent backups of the event log.

C. You should consider making use of the database snapshots.

D. You should consider configuring the use of transaction log backups that runs frequently.

 

Correct Answer: C

Explanation/Reference:

 

 

QUESTION 217

You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008 R2 instance that contains a database named ABCSales.

Minimal changes to the information in ABCSales take place on a daily basis. You have been instructed to devise a solution that fully logs all transactions and keeps the transaction log records until after they are backed up. The solution should also allow for ABCSales to be restored to the point of failure.

Which of the following actions should you take?

 

A. You should consider having the full recovery model configured for ABCSales.

B. You should consider having the simple recovery model is configured for ABCSales.

C. You should consider running the SQL Server Profiler on ABCSales.

D. You should consider configuring ABCSales to make use of the checksum page verify option.

 

Correct Answer: A

Explanation/Reference:

 

 

QUESTION 218

You work as a database administrator at ABC.com. ABC.com has recently upgraded to SQL Server 2008

R2.

You have been instructed to have an existing SQL Server 6.0 database, named ABCSales, upgraded to an instance of SQL Server 2008 R2. You have to make sure that any questionable pages in ABCSales can be identified at an early stage.

Which of the following actions should you take?

 

A. You should consider configuring ABCSales to make use of the checksum page verify option.

B. You should consider running the SQL Server Profiler on ABCSales.

C. You should consider having the simple recovery model is configured for ABCSales.

D. You should consider configuring ABCSales to make use of the torn page detection page verify option.

 

Correct Answer: A

Explanation/Reference:

 

 

QUESTION 219

You work as a database administrator at ABC.com.ABC.com is making use of a SQL Server 2008 R2 instance.

You monitor the transaction log of the instance on a daily basis. On this particular day you are presented with information regarding torn page errors in the database.

You have been instructed to rectify these errors as soon as possible.

Which of the following actions should you take? (Choose two.)

 

A. You should consider restoring only the torn pages from the most recent full database backup.

B. You should consider restoring the full database from the most recent full database backup.

C. You should consider restoring the most recent snapshot backups.

D. You should consider restoring the transaction logs that was created since the full backup.

 

Correct Answer: AD

Explanation/Reference:

 

 

QUESTION 220

You work as a database administrator at ABC.com.ABC.com is making use of a SQL Server 2008 R2 instance.

You have previously configured a SQL Server 2008 R2 cluster. You then disconnect the network cable(s) from the active node, as well as delete the shared array from the active node.

Which of the following describes a reason for doing this?

 

A. To induce an automatic failover.

B. To induce a manual failover.

C. To improve cluster performance.

D. Remove mirroring from the database.

 

Correct Answer: B

Explanation/Reference:

 

 

Download Latest MCTS 70-432 Real Free Tests , help you to pass exam 100%.