Questions And Answers PDF
Microsoft 70-462 Administering Microsoft SQL Server 2012 Databases
Version: DEMO
http://www.TestWarrior.com/70-462-practice-exam.html
FOR 70-462 Candidates: We offer Two Products: 1st - We have Practice Tests Software with Actual Exam Questions 2nd - Questions and Answers in PDF Format. Try a Free DEMO of these Exam Products via below Link:
http://www.TestWarrior.com/70-462-practice-exam.html
TestWarrior.com
1
Questions And Answers PDF
Question 1 You administer all the deployments of Microsof SQL Server 2012 in your company. You need to ensure that an OLTP database that includes up-to-the-minute reportnn requirements can be of-loaded from the primary database to another server. You also need to be able to add indexes to the secondary database. Which confnuraton should you use? A. • Two servers confnured in diferent data centers • SQL Server Availability Group confnured in Synchronous-Commit Availability Mode • One server confnured as an Actve Secondary B. • Two servers confnured in the same data center • SQL Server Availability Group confnured in Asynchronous-Commit Availability Mode • One server confnured as an Actve Secondary C. • Two servers confnured in the same data center • A primary server confnured to perform lon-shippinn every 10 minutes • A backup server confnured as a warm standby D. • Two servers confnured in diferent data centers • SQL Server Availability Group confnured in Asynchronous-Commit Availability Mode E. • Two servers confnured on the same subnet • SQL Server Availability Group confnured in Synchronous-Commit Availability Mode F. • SQL Server that includes an applicaton database confnured to perform transactonal replicaton G. • SQL Server that includes an applicaton database confnured to perform snapshot replicaton H. • Two servers confnured in a Windows Failover Cluster in the same data center • SQL Server confnured as a clustered instance
Aoswern F Explanatonn htpn::msdn.microsof.com:en-us:library:jj542414.aspx
Question 2 You administer all the deployments of Microsof SQL Server 2012 in your company. You need to ensure that data channes are sent to a non-SQL Server database server in near real tme. You also need to ensure that data on the primary server is unafected. Which confnuraton should you use? A. • SQL Server that includes an applicaton database confnured to perform transactonal replicaton
TestWarrior.com
2
Questions And Answers PDF
B. • Two servers confnured in diferent data centers • SQL Server Availability Group confnured in Asynchronous-Commit Availability Mode C. • Two servers confnured in diferent data centers • SQL Server Availability Group confnured in Synchronous-Commit Availability Mode • One server confnured as an Actve Secondary D. • SQL Server that includes an applicaton database confnured to perform snapshot replicaton E. • Two servers confnured in the same data center • SQL Server Availability Group confnured in Asynchronous-Commit Availability Mode • One server confnured as an Actve Secondary F. • Two servers confnured on the same subnet • SQL Server Availability Group confnured in Synchronous-Commit Availability Mode G. • Two servers confnured in a Windows Failover Cluster in the same data center • SQL Server confnured as a clustered instance H. • Two servers confnured in the same data center • A primary server confnured to perform lon-shippinn every 10 minutes • A backup server confnured as a warm standby
Aoswern A Explanatonn htpn::msdn.microsof.com:en-us:library:ms151149.aspx
Question 3 You administer all the deployments of Microsof SQL Server 2012 in your company. A database contains a larne product catalon that is updated periodically. You need to be able to send the entre product catalon to all branch ofces on a monthly basis. Which confnuraton should you use? A. • Two servers confnured in the same data center • A primary server confnured to perform lon-shippinn every 10 minutes • A backup server confnured as a warm standby B. • SQL Server that includes an applicaton database confnured to perform transactonal replicaton C. • Two servers confnured in the same data center • SQL Server Availability Group confnured in Asynchronous-Commit Availability Mode • One server confnured as an Actve Secondary D • Two servers confnured in a Windows Failover Cluster in the same data center • SQL Server confnured as a clustered instance E. • SQL Server that includes an applicaton database confnured to perform snapshot replicaton F. • Two servers confnured in diferent data centers • SQL Server Availability Group confnured in Synchronous-Commit Availability Mode • One server confnured as an Actve Secondary G. • Two servers confnured on the same subnet • SQL Server Availability Group confnured in Synchronous-Commit Availability Mode
TestWarrior.com
3
Questions And Answers PDF
H. • Two servers confnured in diferent data centers • SQL Server Availability Group confnured in Asynchronous-Commit Availability Mode
Aoswern E Question 4 You administer all the deployments of Microsof SQL Server 2012 in your company. You need to ensure that an OLTP database that uses a storane area network (SAN) remains available if any of the servers fail. You also need to minimize the amount of storane used by the database. Which confnuraton should you use? A. • Two servers confnured in diferent data centers • SQL Server Availability Group confnured in Synchronous-Commit Availability Mode • One server confnured as an Actve Secondary B. • SQL Server that includes an applicaton database confnured to perform transactonal replicaton C. • Two servers confnured in the same data center • SQL Server Availability Group confnured in Asynchronous-Commit Availability Mode • One server confnured as an Actve Secondary D. • Two servers confnured in diferent data centers • SQL Server Availability Group confnured in Asynchronous-Commit Availability Mode E. • Two servers confnured in the same data center • A primary server confnured to perform lon-shippinn every 10 minutes • A backup server confnured as a warm standby F. • Two servers confnured on the same subnet • SQL Server Availability Group confnured in Synchronous-Commit Availability Mode G. • SQL Server that includes an applicaton database confnured to perform snapshot replicaton H. • Two servers confnured in a Windows Failover Cluster in the same data center • SQL Server confnured as a clustered instance
Aoswern H Question 5 You administer a Microsof SQL Server 2012 server that hosts a transactonal database and a reportnn database. The transactonal database is updated throunh a web applicaton and is operatonal throunhout the day. The reportnn database is only updated from the transactonal database. The recovery model and backup schedule are confnured as shown in the followinn tablen
TestWarrior.com
4
Questions And Answers PDF
The diferental backup of the reportnn database fails. Then, the reportnn database fails at 14n00 hours. You need to ensure that the reportnn database is restored. You also need to ensure that data loss is minimal. What should you do? A. Restore the latest full backup, and restore the latest diferental backup. Then, restore the latest lon backup. B. Perform a point-in-tme restore. C. Restore the latest full backup. D. Restore the latest full backup, and restore the latest diferental backup. Then, restore each lon backup taken before the tme of failure from the most recent diferental backup. E. Restore the latest full backup. Then, restore the latest diferental backup. F. Restore the latest full backup. Then, restore each diferental backup taken before the tme of failure from the most recent full backup. G. Perform a pane restore. H. Perform a partal restore.
Aoswern C Question 6 You administer a Microsof SQL Server 2012 server that hosts a transactonal database and a reportnn database. The transactonal database is updated throunh a web applicaton and is operatonal throunhout the day. The reportnn database is only updated from the transactonal database. The recovery model and backup schedule are confnured as shown in the followinn tablen
TestWarrior.com
5
Questions And Answers PDF
At 14n00 hours, you discover that panes 71, 520, and 713 on one of the database fles are corrupted on the reportnn database. You also need to ensure that data loss is minimal. What should you do? A. Perform a partal restore. B. Restore the latest full backup, and restore the latest diferental backup. Then, restore each lon backup taken before the tme of failure from the most recent diferental backup. C. Restore the latest full backup. D. Restore the latest full backup, and restore the latest diferental backup. Then, restore the latest lon backup. E. Perform a pane restore. F. Restore the latest full backup. Then, restore each diferental backup taken before the tme of failure from the most recent full backup. G. Perform a point-in-tme restore. H. Restore the latest full backup. Then, restore the latest diferental backup.
Aoswern H Explanatonn Restores a fle or flenroup in a mult-flenroup database. Note that under the simple recovery model, the fle must belonn to a read-only flenroup. Afer a full fle restore, a diferental fle backup can be restored. Pane restore Restores individual panes. Pane restore is available only under the full and bulk-lonned recovery models Piecemeal restore Restores the database in stanes, beninninn with the primary flenroup and one or more secondary
TestWarrior.com
6
Questions And Answers PDF
flenroups. A piecemeal restore benins with a RESTORE DATABASE usinn the PARTIAL opton and specifyinn one or more secondary flenroups to be restored
Question 7 You administer a Microsof SQL Server 2012 server that hosts a transactonal database and a reportnn database. The transactonal database is updated throunh a web applicaton and is operatonal throunhout the day. The reportnn database is only updated from the transactonal database. The recovery model and backup schedule are confnured as shown in the followinn tablen
At 16n20 hours, you discover that panes 17, 137, and 205 on one of the database fles are corrupted on the transactonal database. You need to ensure that the transactonal database is restored. You also need to ensure that data loss is minimal. What should you do? A. Perform a partal restore. B. Restore the latest full backup, and restore the latest diferental backup. Then, restore each lon backup taken before the tme of failure from the most recent diferental backup. C. Perform a point-in-tme restore. D. Restore the latest full backup. E. Restore the latest full backup, and restore the latest diferental backup. Then, restore the latest lon backup. F. Perform a pane restore. G. Restore the latest full backup. Then, restore each diferental backup taken before the tme of failure from the most recent full backup. H. Restore the latest full backup. Then, restore the latest diferental backup.
TestWarrior.com
7
Questions And Answers PDF
Aoswern F Explanatonn Requirements for Restorinn Panes A pane restore is subject to the followinn requirementsn • The databases must be usinn the full or bulk-lonned recovery model. Some issues exist if you are usinn the bulk-lonned model. For more informaton, see the followinn secton. • Panes in read-only flenroups cannot be restored. Tryinn to make a flenroup read-only will fail if there is a pane restore noinn on at the same tme in the flenroup. • The restore sequence must start with a full, fle, or flenroup backup. • A pane restore requires an unbroken chain of lon backups up to the current lon fle, and they must all be applied so that the pane is brounht up to date with the current lon fle. • As in a fle-restore sequence, in each restore step, you can add more panes to the roll forward set. • A database backup and pane restore cannot be run at the same tme. Bulk-lonned Recovery Model and Pane Restore For a database that uses the bulk-lonned recovery model, pane restore has the followinn additonal conditonsn • Backinn up while flenroup or pane data is ofine is problematc for bulk-lonned data, because the ofine data is not recorded in the lon. Any ofine pane can prevent backinn up the lon. In this cases, consider usinn • DBCC REPAIR, because this minht cause less data loss than restorinn to the most recent backup. • If a lon backup of a bulk-lonned database encounters a bad pane, it fails unless WITH • CONTINUE_AFTER_ERROR is specifed. • Pane restore nenerally does not work with bulk-lonned recovery. • A best practce for performinn pane restore is to set the database to the full recovery model, and try a lon backup. If the lon backup works, you can contnue with the pane restore. If the lon backup fails, you either have to lose work since the previous lon backup or you have to try runninn DBCC must be run with the REPAIR_ALLOW_DATA_LOSS opton.
Question 8 You administer a Microsof SQL Server 2012 server that hosts a transactonal database and a reportnn database. The transactonal database is updated throunh a web applicaton and is operatonal throunhout the day. The reportnn database is only updated from the transactonal database. The recovery model and backup schedule are confnured as shown in the followinn tablen
TestWarrior.com
8
Questions And Answers PDF
One of the hard disk drives that stores the reportnn database fails at 16n40 hours. You need to ensure that the reportnn database is restored. You also need to ensure that data loss is minimal. What should you do? A. Restore the latest full backup. Then, restore each diferental backup taken before the tme of failure from the most recent full backup. B. Perform a partal restore. C. Restore the latest full backup, and restore the latest diferental backup. Then, restore the latest lon backup. D. Perform a point-in-tme restore. E. Restore the latest full backup. F. Perform a pane restore. G. Restore the latest full backup, and restore the latest diferental backup. Then, restore each lon backup taken before the tme of failure from the most recent diferental backup. H. Restore the latest full backup. Then, restore the latest diferental backup.
Aoswern H Question 9 DRAG DROP You administer three Microsof SQL Server 2012 servers named ServerA, ServerB, and ServerC. ServerA is the actnn principal and ServerB is the mirror. You need to add ServerC as a witness to the existnn mirrorinn session between ServerA and ServerB. You need to achieve this noal without delayinn synchronizaton. Which three actons should you perform in sequence? (To answer, move the appropriate actons from the list of actons to the answer area and arranne them in the correct order.)
TestWarrior.com
9
Questions And Answers PDF
Aoswern
Question 10 You administer a Microsof SQL Server 2012 database. You create an availability nroup named haContosoDbs. Your primary replica is available at Server01\Contoso01. You need to confnure the availability nroup to have the hinhest availability. You also need to ensure that no data is lost. Which Transact-SQL statement should you use?
TestWarrior.com
10
Questions And Answers PDF
A. Opton A B. Opton B C. Opton C D. Opton D
Aoswern C Question 11 DRAG DROP You administer several Microsof SQL Server 2012 servers. Your company has a number of ofces across the world connected by usinn a wide area network (WAN). Connectons between ofces vary sinnifcantly in both bandwidth and reliability. You need to identfy the correct replicaton method for each scenario. What should you do? (To answer, dran the appropriate replicaton method or methods to the correct locaton or locatons in the answer area. Each replicaton method may be used once, more than once, or not at all.)
Aoswern
TestWarrior.com
11
Questions And Answers PDF
Explanatonn htpn::msdn.microsof.com:en-us:library:ms151198.aspx
Question 12 You administer several Microsof SQL Server 2012 database servers. Merne replicaton has been confnured for an applicaton that is distributed across ofces throunhout a wide area network (WAN). Many of the tables involved in replicaton use the XML and varchar (max) data types. Occasionally, merne replicaton fails due to tmeout errors. You need to reduce the occurrence of these tmeout errors. What should you do? A. Set the Merne anent on the problem subscribers to use the slow link anent profle. B. Create a snapshot publicaton, and reconfnure the problem subscribers to use the snapshot publicaton. C. Channe the Merne anent on the problem subscribers to run contnuously. D. Set the Remote Connecton Timeout on the Publisher to 0.
Aoswern A Explanatonn When replicaton is confnured, a set of anent profles is installed on the Distributor. An anent profle contains a set of parameters that are used each tme an anent runsn each anent lons in to the Distributor durinn its startup process and queries for the parameters in its profle. For merne subscriptons that use Web synchronizaton, profles are downloaded and stored at the Subscriber. If the profle is channed, the profle at the Subscriber is updated the next tme the Merne Anent runs. For more informaton about Web synchronizaton, see Web Synchronizaton for Merne Replicaton. Replicaton provides a default profle for each anent and additonal predefned profles for the Lon Reader Anent, Distributon Anent, and Merne Anent. In additon to the profles provided, you can create profles suited to your applicaton requirements. An anent profle allows you to channe key parameters easily for all anents associated with that profle. For example, if you have 20 Snapshot Anents and need to channe the query tmeout value (the - QueryTimeout parameter), you can update the profle used by the Snapshot Anents and all anents of that type will benin usinn the new value automatcally the next tme they run. You minht also have diferent profles for diferent instances of an anent. For example, a
TestWarrior.com
12
Questions And Answers PDF
Merne Anent that connects to the Publisher and Distributor over a dialup connecton could use a set of parameters that are beter suited to the slower communicatons link by usinn the slow link profle.
Question 13 DRAG DROP You administer two Microsof SQL Server 2012 servers named ServerA and ServerB. You use a database named AdventureWorks. You need to prepare the AdventureWorks database for database mirrorinn. ServerB will act as the mirror in a mirrorinn partnership alonn with ServerA Which three actons should you perform in sequence? (To answer, move the appropriate actons from the list of actons to the answer area and arranne them in the correct order.)
Aoswern
Explanatonn htpn::msdn.microsof.com:en-us:library:ms189852.aspx htpn::msdn.microsof.com:en-us:library:ms190941.aspx
TestWarrior.com
13
Questions And Answers PDF
Question 14 You create an availability nroup named HaContoso that has replicas named Server01:HA, Server02:HA, and Server03:HA, Currently, Server01l:HA is the primary replicA You need to ensure that the followinn requirements are metn • Backup operatons occur on Server02:HA • If Server02:HA is unavailable, backup operatons occur on Server03:HA • Backup operatons do not occur on Server01:HA How should you confnure HaContoso? A. • Set the backup preference of HaContoso to Prefer Secondary. • Set the backup priority of Server02:HA to 20. • Set the backup priority of Server03:HA to 10. B. • Set the backup preference of HaContoso to Secondary only. • Set the backup priority of Server02:HA to 20. • Set the backup priority of Server03:HA to 10. C. • Set the backup preference of HaContoso to Secondary only. • Set the backup priority of Server02:HA to 10. • Set the backup priority of Server03:HA to 20. D. • Set the exclude replica of Server01:HA to true. • Set the backup priority of Server02:HA to 10. • Set the backup priority of Server03:HA to 20.
Aoswern B Explanatonn htpn::msdn.microsof.com:en-us:library:f877884.aspx
Question 15 You administer a Microsof SQL Server 2012 instance that has several SQL Server Anent jobs confnured. When SQL Server Anent jobs fail, the error messanes returned by the job steps are truncated. The followinn error messane is an example of the truncated error messanen "Executed as user CONTOSO\ServiceAccount....0.4035.00 for 64-bit Copyrinht (C) Microsof Corp 1984-2011. All rinhts reserveD. Started 63513 PM Error 2012-06-23 183536.87 Code 0XC001000E Source UserImport Descripton Code 0x00000000 Source Lon Import Actvity Descript... The packane executon f A. .. The step failed. " You need to ensure that all the details of the job step failures are retained for SQL Server Anent jobs. What should you do? A. Expand anent lonninn to include informaton from all events. B. Disable the Limit size of job history lon feature. C. Confnure event forwardinn. D. Confnure output fles.
TestWarrior.com
14
Questions And Answers PDF
Aoswern D
TestWarrior.com
15
Questions And Answers PDF
Thank You for Trying Our Product Visit Our Site to Purchase the Full Set of Actual 70-462 Exam Questions With Answers.
http://www.TestWarrior.com/70-462-practice-exam.html We Also Provide Practice Exam Software That Simulates Real Exam Environment And Has Many Self-Assessment Features. Download Free Product Demo From:
Download Free Product Demo from: http://www.TestWarrior.com/70-462-practice-exam.html
Check Out Our Customer Testimonials
TestWarrior.com
16