web analytics

Real Pass4sure Microsoft 70-450 PDF & VCE Exam Dumps Free Download (101-110)

QUESTION 101
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.    Perform a differential backup.
B.    Create a database snapshot.
C.    Create a marked transaction. Perform a transaction log backup.
D.    Record the time before the batch operation. Perform a transaction log backup.

Answer: B

QUESTION 102
You administer a SQL Server 2008 database solution. All data modifications are performed through stored procedures that use only the INSERT, UPDATE, or DELETE statements. You are designing a backup strategy. You need to ensure that the following business requirements are met:
* The backup strategy supports point-in-time recovery for failure at any time of day.
* The transaction log uses the least amount of disk space.
What should you do?

A.    Use hourly database snapshots.
B.    Use the full-recovery model along with differential backups.
C.    Use the simple-recovery model along with differential backups.
D.    Use the full-recovery model along with transaction log backups.

Answer: D

QUESTION 103
You administer a SQL Server 2008 instance that hosts a database. The backup strategy used by the database is as shown in the following table:
1031
You run a batch process on Saturday that lasts from 21:00 hr to 23:00 hr. You discover that the batch process is invalidated because a user has modified some data at 21:05 hr on the same day. You need to restore the database to its state at the start of the batch process in the least possible time. What should you do?

A.    Restore the full database backup that was performed on Saturday.
B.    Restore the full database backup that was performed on Thursday Restore all transaction logs from the time of the full backup on Thursday and stop at 21:00 hr on Saturday.
C.    Restore the full database backup that was performed on Saturday. Restore all transaction logs from the time of the full backup on Saturday and stop at 21:00 hr on Saturday.
D.    Restore the full database backup that was performed on Thursday. Restore the differential backup that was performed on Friday. Restore all transaction logs from the time of the differential backup on Friday and stop at 21:00 hr on Saturday.

Answer: D

QUESTION 104
You administer a SQL Server 2008 infrastructure. Several production databases use Transparent database encryption. You perform full database backups of the production databases as part of your backup strategy. You need to ensure that the database backups can be restored on another SQL Server 2008 instance if the original host server fails. What should you do?

A.    Back up the resource database.
B.    Back up the server master key.
C.    Back up the database master key.
D.    Ensure that the instances use the same service account.

Answer: C

QUESTION 105
You administer a SQL Server 2008 Enterprise Edition instance that hosts a large database. The database uses the simple-recovery model.
The database contains the following three additional filegroups:
* FileGroupA that is read/write
* FileGroupB that is read-only
* FileGroupC that is read-only
FilegroupB contains less critical data than FilegroupC.
You discover that the PRIMARY filegroup and FileGroupB have failed.
You need to recover the database in the minimum possible time. You also need to ensure that data is available as soon as possible.
What should you do?

A.    Perform a full database restore.
B.    Perform a partial restore of the PRIMARY filegroup and FileGroupB from a partial backup.
C.    Perform a partial restore of the PRIMARY filegroup and FileGroupA from a partial backup.
Perform an online recovery of FileGroupB, and then perform an online restore of FileGroupC.
D.    Perform a partial restore of the PRIMARY filegroup and FileGroupA from a partial backup.
Perform an online recovery of FileGroupC, and then perform an online restore of FileGroupB.

Answer: D

QUESTION 106
You administer SQL Server 2008 instances at three sites. All sites share a mission-critical database. The business requirements specify that users at each site must be able to perform the following tasks:
Access and modify data on all sites with minimal latency.
Minimize data loss in the event of a server failure.
You need to provide a high-availability solution that meets the business requirements. Which solution should you implement?

A.    Failover clustering
B.    Peer-to-Peer replication
C.    Asynchronous database mirroring without a witness server
D.    Log shipping to servers at two of the sites to provide read-only copies of data

Answer: B

QUESTION 107
You administer a SQL Server 2008 infrastructure.
An instance hosts a business-critical database that must be continuously available to the users without data loss. The database includes Filestream data. You need to implement a high-availability solution for the site. Which solution should you use?

A.    Failover clustering
B.    Database snapshot
C.    Asynchronous database mirroring
D.    Synchronous database mirroring with a witness server

Answer: A

QUESTION 108
You administer four SQL Server 2008 instances. Each instance hosts a single database application. You plan to migrate all four instances to a new SQL Server failover cluster. The four instances are configured as shown in the following table.
1081
The four instances are fully optimized and have no spare CPU cycles or extra memory. The new cluster will host all four databases on a single virtual cluster IP address. You need to ensure that the new cluster is configured to handle the workload of all the database applications by using the minimum amount of hardware resources. Which cluster configuration should you use?

A.    Four-node active/active/active/active cluster that has each node containing a minimum of 9 processors and a 25-GB memory
B.    Two-node active/active cluster that has each node containing a minimum of 9 processors and a 25-GB memory
C.    Two-node active/passive cluster that has each node containing a minimum of 18 processors and a 50- GB memory
D.    Four-node active/active/active/passive cluster that has each node containing a minimum of 18 processors and a 50-GB memory

Answer: C

QUESTION 109
You administer a SQL Server 2008 instance. You plan to design a high-availability solution by using database mirroring. The current application includes programming logic that will retry transactions if a failover occurs. You need to configure a strategy that will provide the minimum amount of latency for committed transactions. What should you do?

A.    Pause database mirroring.
B.    Configure manual failover role switching.
C.    Configure forced service role switching.
D.    Configure automatic failover role switching.

Answer: C

QUESTION 110
You are a professional level SQL Sever 2008 Database Administrator. After a regular test, you find that performance degradation is experienced by an instance for the three reasons:
Excessive CPU usage, Server processes paging and Deadlocks
A monitoring solution should be implemented to provide data, monitor and troubleshoot performance issues and detailed deadlock information should be contained in the provided data. You should utilize the least amount of administrative effort to finish the task. Which tool will you utilize to finish the task?

A.    To finish the task, you should utilize Resource Governor.
B.    To finish the task, you should utilize Database Engine Tuning Advisor.
C.    To finish the task, you should utilize Extended Events.
D.    To finish the task, you should utilize Performance Monitor (SYSMON).

Answer: C

Real Pass4sure Microsoft 70-450 PDF & VCE Exam Dumps Free Download

Welcome To Visit PassLeader