This page was exported from Braindump2go Free Exam Dumps with PDF and VCE Collection [ https://www.mcitpdump.com ] Export date:Thu Apr 18 23:04:59 2024 / +0000 GMT ___________________________________________________ Title: [OFFICIAL NEW UPDATED] Microsoft 70-462 Exam Questions Newly Updtaed By Braindump2go (91-100) --------------------------------------------------- Real Latest 70-462 Exam Questions Updated By Official Microsoft Exam Center! Braindump2go Offers 70-462 Dumps sample questions for free download now! You also can visit our website, download our premium Microsoft 70-462 Exam Real Answers, 100% Exam Pass Guaranteed! Vendor: MicrosoftExam Code: 70-462Exam Name: Administering Microsoft SQL Server 2012 Databases Exam QUESTION 91You use Microsoft SQL Server 2012 to write code for a transaction that contains several statements. There is high contention between readers and writers on several tables used by your transaction. You need to minimize the use of the tempdb space. You also need to prevent reading queries from blocking writing queries. Which isolation level should you use? A.    SERIALIZABLEB.    SNAPSHOTC.    READ COMMITTED SNAPSHOTD.    REPEATABLE READ Answer: C QUESTION 92You need to install the Power View Components on a stand alone server. Which three actions should you perform (and sorting)?  A.    Install SQL 2012 Analyse ServicesB.    Install SQL 2012 Reporting ServicesC.    Install SQL 2012 Database Engine and PowerPivot for SharepointD.    Configure SQL Server Reporting Services and Addin in sharepoint modeE.     Configure SQL Server reporting services in native mode Answer: BCD QUESTION 93You plan to migrate the db to azure. You verify that all objects are valid for azure sql database.. You need to ensure that users and logins are migrated to azure.. What should you do? A.    Use the Copy Database wizardB.    Use the Database Transfer wizardC.    Use the SQL Management Studio to deploy the db to azureD.    Back up the databasae from the local server and restore it to azure Answer: CD QUESTION 94You maintain several dbs on a 64 bit ms sql 2005 instance You need to migrate the dbs to sql 2012 on the same server. You also need to ensure functionality in sql 2012 can be used in the db after migration.. What should You do? (each correct answer presents part of the solution) A.    Perform an in-place upgrade to 64-bit in sql 2012B.    Perform a side by side installation of a 64 bit sql 2012C.    Perform a side by side installation of a 32 bit sql 2012D.    Detach the old instance and attach it to the new oneE.     Change the compatibility level of the db Answer: BDE QUESTION 95You create a new user named UserA. You need to ensure that UserA is able to create SQL Server Agent jobs and to execute SQL Server Agent jobs. To which role should you add UserA? A.    SecurityadminB.    RSExecRoleC.    SQLAgentUserRoleD.    DatabaseMailUserRole Answer: C QUESTION 96Hotspot QuestionYou administer a Microsoft SQL Server 2012 database instance. Other applications run on the server. Some of the applications are throwing errors because of insufficient memory.You need to ensure that the other applications have sufficient memory.Which setting should you configure? Answer: QUESTION 97You administer a database that has User A, B and C.User A must be able to create new tables and stored procedures, User B must be able to select, update, delete and insert data, User C must be albe to provide windows logins to the database - db_accessadmin - db_ddladmin - db_datawriter - db_datareader - db_owner To which role or roles should you add the users? A.    ddladminB.    datawriter, datareader C.    accessadmin Answer: A QUESTION 98You are the administrator of a Microsoft SQL Server 2012 server.Some applications consume significant resources. You need to manage the server workload by restricting resource-intensive applicationsYou need to dynamically limit resource consumption.What should you do? A.    Set up Service Broker to ensure that applications are not allowed to consume more than the specified amount of resources.B.    Configure Resource Pools, Workload Groups, and Classifier Function, and then enable the Resource Governor.C.    Configure Extended Events to monitor and restrict resource limits allowed by each application type.D.    Create a new Plan Guide with a Scope Type of sql and define the resource limits for each application. Answer: A QUESTION 99You administer a Microsoft SQL Server 2012 database that includes a table named dbo.Log. This table contains millions of records about user activity in an application.Records in dbo.Log that are more than 90 days old are purged nightly. When records are purged, table locks are causing contention withinserts.You need to be able to modify dbo.Log without requiring any changes to the applications that utilize dbo.Log. Which type of solution should you use? A.    Extended eventsB.    Columnstore indexC.    Partitioned tablesD.    Read committed snapshot Answer: C QUESTION 100You administer a Microsoft SQL Server 2012 database named Orders.Users report that during peak usage periods, certain operations are taking more time than expected. Your initial analysis suggests that blocking is the cause.You need to gather more data to be able to determine which processes are being blocked and to identify the root cause.What should you do? A.    Start a trace using SQL Server Profiler to catch the Lock: Deadlock event.B.    Use sp_configure to set the blocked process threshold. Start a trace using SQL Server Profiler to catch the Blocked Process Report event.C.    Schedule a SQL Agent job to run every 60 seconds and insert the results of executing the sys.dm_os_wait_stats DMV into a table.D.    Use System Monitor to catch the Lock Waits/sec event. Answer: B Braindump2go Guarantee:Pass-Certification 70-462 offers absolute risk free investment opportunity, values your timr and money! Braindump2go latest 70-462 Real Exam Dumps - Your success in 70-462 Exam is certain! Your belief in our 70-462 Exam Dumps is further strengthened with 100% Money Back Promise from Braindump2go! http://www.braindump2go.com/70-462.html --------------------------------------------------- Images: http://www.itexamquiz.com/braindump2go/bdimages/e3a7ad92081b_A799/1102.png http://www.itexamquiz.com/braindump2go/bdimages/e3a7ad92081b_A799/wpsB26D.tmp_thumb_thumb.png http://www.itexamquiz.com/braindump2go/bdimages/e3a7ad92081b_A799/wpsB26D.tmp4_thumb_thumb.png http://www.itexamquiz.com/braindump2go/bdimages/e3a7ad92081b_A799/152.png --------------------------------------------------- --------------------------------------------------- Post date: 2015-02-06 03:56:37 Post date GMT: 2015-02-06 03:56:37 Post modified date: 2015-02-06 03:56:37 Post modified date GMT: 2015-02-06 03:56:37 ____________________________________________________________________________________________ Export of Post and Page as text file has been powered by [ Universal Post Manager ] plugin from www.gconverters.com