Latest MCTS 70-432 Dumps Real Exam Download 51-60

Ensurepass

QUESTION 51
Note:
This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.

You administer a Microsoft SQL Server 2008 R2 instance. The instance has a database named Customer Orders. The database is backed up by using the weekly scheduled SQL Server Agent jobs. The backup schedule is shown in the following table:

clip_image002

A drive fails and the Customer Orders database goes into suspect mode on Monday at 09:00 hours.

You need to restore the backup.

What should you do?

 

A. Restore the backup taken on Sunday only.

B. Restore the backups taken on Sunday and Monday.

C. Restore the backup taken on Wednesday only.

D. Restore the backups taken on Wednesday, Thursday at 09:00 hours, and Thursday at 18:00 hours.

E. Restore the backups taken on Wednesday and Thursday at 09:00 hours.

F. Restore the backups taken on Wednesday, Thursday, and Friday.

G. Restore the backups taken on Wednesday and Friday.

H. Restore the backup taken Wednesday, Friday, and Saturday.

 

Correct Answer: A

Explanation/Reference:

 

 

QUESTION 52
Note:
This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.

You administer a Microsoft SQL Server 2008 R2 instance. The instance has a database named Customer Orders.

The database is backed up by using the weekly scheduled SQL Server Agent jobs. The backup schedule is shown in the following table:

clip_image004

A drive fails and the Customer Orders database goes into suspect mode on Sunday at 09:00 hours.

You need to restore the backup.

What should you do?

 

A. Restore the backup taken on Sunday only.

B. Restore the backups taken on Sunday and Monday.

C. Restore the backup taken on Wednesday only.

D. Restore the backups taken on Wednesday, Thursday at 09:00 hours, and Thursday at 18:00 hours.

E. Restore the backups taken on Wednesday and Thursday at 09:00 hours.

F. Restore the backups taken on Wednesday, Thursday, and Friday.

G. Restore the backups taken on Wednesday and Friday.

H. Restore the backup taken Wednesday, Friday, and Saturday.

 

Correct Answer: H

Explanation/Reference:

 

 

QUESTION 53

You administer a Microsoft SQL Server 2008 R2 database instance that supports a sales management application.

Occasionally, users of the application report that they receive a deadlock error. You plan to troubleshoot this error.

You need to ensure that the instance is configured to capture troubleshooting information that will create an XML document detailing the deadlock condition.

Which two actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)

Select and Place:  clip_image006

Correct Answer:

clip_image008Explanation/Reference:

 

 

QUESTION 54

You upgrade an instance of Microsoft SQL Server 2000 to SQL Server 2008.

The SQL Server Agent service is configured to use the LocalSystem account. A job uses a CMDExec step to access a file located on a remote network share.

After the upgrade, the job step fails to complete execute.

You need to configure the job step so that it can successfully complete execution.

What should you do?

 

A. Configure the SQL Server Agent service to use a local Windows account.

B. Configure a certificate.

C. Configure the job step to use a proxy account.

D. Configure the SQL Server Agent service to use the NetworkService account.

 

Correct Answer: C

Explanation/Reference:

 

 

QUESTION 55

You configure a SQL Server 2008 instance that contains a database named Customers.

The Customers database experiences deadlock problems.

You need to capture the deadlock information to the SQL Server error log.

What should you do?

 

A. Enable the Windows Event Collector service.

B. Enable file system auditing.

C. Configure a Data Collector Set and then restart the SQL Server instance.

D. Configure trace flags and then restart the SQL Server instance.

 

Correct Answer: D

Explanation/Reference:

 

 

QUESTION 56

You manage a SQL Server 2008 instance.

You need to verify whether or not a database integrity check (DBCC CHECKDB) was run for a particular database.

Which log file should you examine?

 

A. ERRORLOG

B. log.trc

C. SQLAGENT

D. default.trc

 

Correct Answer: AExplanation/Reference:

 

 

QUESTION 57

A SQL Server login named Mary with the password “Me#43&21” is used by a user to access the database on Instance1. You create the same SQL Server login on Instance2.

The user attempts to access the AdventureWorks database on Instance2 by using the SQL Server login Mary. However, the user receives an error message which indicates that the access to the

AdventureWorks database is denied.

You need to ensure that the user can access the AdventureWorks database.

Which Transact-SQL statements should you execute on Instance2?

 

A. USE AdventureWorks; ALTER LOGIN Mary ENABLE;

B. USE AdventureWorks; ALTER LOGIN Mary WITH PASSWORD = “Me#43&21” UNLOCK;

C. USE AdventureWorks; ALTER USER Mary WITH LOGIN = Mary;

D. USE AdventureWorks; ALTER LOGIN Mary WITH DEFAULT_DATABASE = AdventureWorks;

 

Correct Answer: C

Explanation/Reference:

 

 

QUESTION 58

You administer a Microsoft SQL Server 2008 R2 database. You configure the disk drives according to the following table:

clip_image010

You discover that the Windows application log is being filled with entries from a SQL Server Audit process named DatabaseAudit. The volume of these events is causing older events to be removed from the log.

You need to ensure that the following requirements are met:

SQL Server Audit information is stored in the

D:AuditLogs folder.

No data is currently lost in the Windows application log.

What should you do?

 

A. Create a folder named AuditLogs on drive D. Open the Windows Server Manager. Browse to the DiagnosticsEvent ViewerWindows Logs folder Right-Click Application Log, and then click Properties. Change the Log path to D:AuditLogsApplication.evtx.

B. Create a folder named AuditLogs on drive D. Open Microsoft SQL Server Management Studio and connect to the server. Browse to the SecurityAudits folder and double-click the DatabaseAudit object. Change the Audit Destination to File and specify D:AuditLogs as the file path.

C. Open Microsoft SQL Server Management Studio and connect to the server. Browse to the SecurityAudits folder. Right-click the DatabaseAudit object, and then select Disable Audit. Continue to troubleshoot the issue. When the issue is resolved, browse to the SecurityAudits folder. Right-click the DatabaseAudit object, and then select Enable Audit.

D. Open the Windows Server Manager. Browse to the DiagnosticEvent ViewerWindows Log folder. Right-Click Application Log, and then click Properties. Enable the Clear Log option.

 

Correct Answer: B

Explanation/Reference:

 

 

QUESTION 59

You maintain multiple SQL Server 2008 instances on the same physical computer.

Users can connect to the default instance but are unable to connect to the named instances. You verify that currently all SQL Server instances run.

You need to start the service required to connect to the named instance.

Which Service should you start?

 

A. Server

B. SQL Active Directory Helper

C. SQL Server Agent

D. SQL Server Browser

 

Correct Answer: D

Explanation/Reference:

 

 

QUESTION 60

You administer a SQL Server 2008 instance named SQL1. SQL1 contains a database named DB1. You create a new user named User1 in the DB1 database. No additional permissions have been assigned to User1 or the public role. User1 will interact with database objects stored in a new schema named Reporting. The other objects in the DB1 database are owned by the dbo and are contained in a schema named Operations. You need to grant the minimum necessary permissions to User1 to create tables and stored procedures in the Reporting schema. You also need to ensure that User1 cannot alter any of the objects in the Operations schema. Which Transact-SQL statements should you execute?

 

A. GRANT CREATE TABLE, CREATE PROCEDURE TO User1; DENY CONTROL ON SCHEMA::Operations TO User1;

B. ALTER AUTHORIZATION ON SCHEMA::Reporting TO User1;

C. GRANT CONTROL ON SCHEMA::Reporting TO User1; DENY CONTROL ON SCHEMA::Operations TO User1;

D. GRANT CREATE TABLE, CREATE PROCEDURE ON SCHEMA::Reporting TO User1;

 

Correct Answer: A

Explanation/Reference:

http://msdn.microsoft.com/en-us/library/dd283095(v=sql.100).aspx GRANT:—(…grant the minimum necessary permissions) —

Feedback: ChuckTo create procedures, you must have CREATE PROCEDURE permission in the database and ALTER permission on the schema in which the procedure is being created. For CLR stored procedures, you must either own the assembly referenced in <method_specifier>, or have REFERENCES permission on that assembly.

DENY:—(…cannot alter any of the objects) http://msdn.microsoft.com/en-us/library/ms176128.aspx

 

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