Latest MCTS 70-432 Dumps Real Exam Download 41-50

Ensurepass

QUESTION 41

You maintain a SQL Server 2008 instance that contains a database named Finance.

You need to configure SQL Server to automatically send an e-mail message when any file in the Finance database increases.

Which technology should you include in your solution?

 

A. Event notifications

B. Trace flag

C. SQL Server Profiler

D. Query notifications

 

Correct Answer: A

Explanation/Reference:

http://msdn.microsoft.com/en-us/library/ms175854(v=sql.105).aspx http://msdn.microsoft.com/en-us/library/ms130764(v=sql.100).aspx

 

 

QUESTION 42

You administer a Microsoft SQL Server 2008 database.

Backups are performed according to the following schedule:

Full database backup at 00:00 hours daily.

Transaction log backups at 06:00 hours, 12:00 hours, and 18:00 hours daily.

You discover that the database failed at 10:18 hours. You also discover that the database is no longer accessible due to a failure of the hard drive that contains the database data file.

You need to restore the database. You also need to ensure that data loss is minimal.

Which four 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_image002

Correct Answer: clip_image004

Explanation/Reference:

 

 

QUESTION 43

You administer multiple SQL Server 2008 instances.

You plan to install a SQL Server 2008 mission-critical cluster on two cluster-ready nodes. The missioncritical cluster requires constant availability.

You need to configure the SQL Server cluster to failover by ensuring that the service disruption is minimized.

What failover option should you use?

 

A. Prevent automatic failback

B. Immediately allow failback

C. Allow failback only during business hours

D. Allow failback only during non-business hours

 

Correct Answer: A

Explanation/Reference:

 

 

QUESTION 44

You administer a Microsoft SQL Server 2008 R2 instance.

You need to configure mirroring between two servers in high-performance mode.

What should you do?

 

A. Create mirroring endpoints on both partner servers. Use the ALTER DATABASE statement along with the PARTNER SAFETY OFF clause on the principal server. Define the Service Broker queue that must be used to hold requests.

B. Create mirroring endpoints on both partner servers. Create a witness server. Use the ALTER DATABASE statement along with the PARTNER SAFETY OFF clause on the principal server.

C. Create mirroring endpoints on both partner servers. Use the ALTER ENDPOINT statement along with the ENCRYPTION=DISABLED clause.

D. Create mirroring endpoints on both partner servers. On the principal, use the ALTER DATABASE statement along with the PARTNER SAFETY OFF clause.

 

Correct Answer: D

Explanation/Reference:

— This is ‘No witness mirroring, manual failover’ (high performance).

http://msdn.microsoft.com/en-us/library/ms191456(v=sql.105).aspx

How Transaction Safety and Witness State Affect the Operating Mode

The operating mode of a session is determined by the combination of its transaction safety setting and the state of the witness. At any time, the database owner can change the transaction safety level, and can add or remove the witness.

Transaction Safety

Transaction safety is a mirroring-specific database property that determines whether a database mirroring session operates synchronously or asynchronously. There are two safety levels: FULL and OFF. SAFETY FULL Full transaction safety causes the session to operate synchronously in high-safety mode. If a witness is present, a session supports automatic failover. When you establish a session using ALTER DATABASE statements, the session begins with the SAFETY property set to FULL; that is, the session begins in high-safety mode. After the session begins, you can add a witness. For more information, see Synchronous Database Mirroring (High-Safety Mode). SAFETY OFF Turning off transaction safety causes the session to operate asynchronously, in high-performance mode. If the SAFETY property is set to OFF, the WITNESS property should also be set to OFF (the default). For information about the impact of the witness in high-performance mode, see “The State of the Witness,” later in this topic. For more information about running with transaction safety turned off, see Asynchronous Database Mirroring (High-Performance Mode). The transaction safety setting of the database is recorded on each partner in the sys.database_mirroring catalog view in the mirroring_safety_level and mirroring_safety_level_desc columns. For more information, see sys.database_mirroring (Transact-SQL).

 

 

QUESTION 45

You administer a SQL Server 2008 instance that contains a database named AdventureWorks. The

AdventureWorks database contains the Products table.

You create a Merge Replication topology and a Publication to replicate the Products table to the SQL Server instances at remote locations. The Publication has a 21-day retention period.

When a user returns from a one-month vacation, she discovers that her database does not contain the most recent data. The Windows Event log states the following error message:

“Replication: expired subscription dropped.”

You need to obtain the most recent data in the database of the user. You also need to ensure that future data changes are appropriately replicated.

What should you do?

 

A. Upload unsynchronized changes.

B. Reinitialize the publication and immediately generate a new snapshot.

C. Recreate the publication.

D. Upload unsynchronized changes, and then reinitialize the publication.

 

Correct Answer: B

Explanation/Reference:

 

 

QUESTION 46

You administer three SQL Server 2008 instances named Instance1, Instance2, and Instance3. Each of the three instances runs on a separate server. A mission-critical database is mirrored between Instance1 and Instance2. Instance3 is configured as the witness. Instance1 is configured as the Principal.

You plan to apply an update to the servers that run Instance1 and Instance2. The update requires a restart. You need to ensure that the servers meet the following requirements during the update process:

Complete the update process in the least amount of time.

The database must be available on one server during the update of another server.

The update process must not cause an automatic failover of the database.

What should you do?

 

A. Remove the mirroring session. Run the SQL Server 2008 Upgrade Advisor Install the update on both servers. Re-establish the mirroring session.

B. Suspend the mirroring session Install the update on both servers.

C. Suspend the mirroring session Install the update on the server that runs Instance2. Resume the mirroring session. Perform a manual failover of the mirroring session. Install the update on the server that runs Instance1.

D. Install the update on the server that runs Instance2. Perform a manual failover of the mirroring session. Install the update on the server that runs Instance1.

E. Remove the mirroring session Install the update on both servers. Re-establish the mirroring session.

 

Correct Answer: C

Explanation/Reference:

 

 

QUESTION 47

You maintain a SQL Server 2008 instance that contains a database named Finance.

Minimally logged operations are performed on the Finance database.

You need to verify that the database can be restored to a specific point in time.

What should you do?

 

A. Verify that the database uses the full recovery model.

B. Verify that the database uses the checksum page_verify option

C. Verify that the database uses the bulk-logged recovery model.

D. Verify that the database uses the simple recovery model.

 

Correct Answer: A

Explanation/Reference:

 

 

QUESTION 48

You design a maintenance plan for a SQL Server 2008 instance that contains a database named SalesDB.

The SalesDB database includes spatial indexes to support queries on spatial data.

You need to perform physical consistency checks on SalesDB. You also need to ensure that the performance effect on the SalesDB database is minimized.

Which Transact-SQL statement should you execute?

 

A. DBCC SYS_CHECK (SalesDB);

B. DBCC CHECKDB (SalesDB);

C. DBCC SQLPERF (SalesDB);

D. DBCC REPAIRDB (SalesDB);

 

Correct Answer: B

Explanation/Reference:

DBCC CHECKDB:

Checks the logical and physical integrity of all the objects in the specified database by performing the following operations:

Runs DBCC CHECKALLOC on the database.

Runs DBCC CHECKTABLE on every table and view in the database.

Runs DBCC CHECKCATALOG on the database.

Validates the contents of every indexed view in the database.

Validates link-level consistency between table metadata and file system directories and files when storing varbinary(max) data in the file system using FILESTREAM.

Validates the Service Broker data in the database.

The DBCC offers two repair modes:

REPAIR_REBUILD: This performs a repair that does not lead to any data loss.

REPAIR_ALLOW_DATA_LOSS: This performs a repair and fixes to the corrupted database structures, and also results in data loss.

DBCC SYS_CHECK:

Database system tables are checked during this phase.

DBCC SQLPERF:

Provides transaction log space usage statistics for all databases. It can also be used to reset wait and latch statistics.

DBCC REPAIRDB: No such command/statement/clause.

 

 

QUESTION 49

You maintain a SQL Server 2008 instance that contains a database named Finance.

In your absence, a user with a login named Rob will maintain the database snapshots.

You need to grant the appropriate permissions to the user to delete the database snapshots for the Finance database.

Which database permission should you grant?

 

A. CONTROL

B. DROP DATABASE

C. DELETE

D. ALTER ANY DATASPACE

 

Correct Answer: B

Explanation/Reference:

 

 

QUESTION 50
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_image006

 

A drive fails and the Customer Orders database goes into suspect mode on Tuesday 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: B

Explanation/Reference:

 

 

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