70-462 exam

You administer a Microsoft SQL Server 2012 server. One of the databases on the server supports a highly active OLTP application. Users report abnormally long wait times when they submit data into the application. You need to identify which queries are taking longer than 1 second to run over an...

You are migrating a database named Orders to a new server that runs Microsoft SQL Server 2012. You attempt to add the [CorpnetUser1] login to the database. However, you receive the following error message: "User already exists in current database." You need to configure the [CorpnetUser1] login to be able...

You administer a Microsoft SQL Server 2012 instance that has several SQL Server Agent jobs configured. When SQL Server Agent jobs fail, the error messages returned by the job steps are truncated. The following error message is an example of the truncated error message: "Executed as user CONTOSOServiceAccount....0.4035.00 for 64-bit...

DRAG DROP You administer a Microsoft SQL Server 2012 instance that contains a database of confidential data. You need to encrypt the database files at the page level. You also need to encrypt the transaction log files. Which four actions should you perform in sequence? (To answer, move the appropriate...

You administer a Microsoft SQL Server 2012 failover cluster. You need to ensure that a failover occurs when the server diagnostics returns query_processing error. Which server configuration property should you set?A . SqlOumperDumpFlagsB . FailureConditionLevelC . HealthCheckTimeoutD . SqlDumperDumpPathView AnswerAnswer: B

Topic 1, Volume A You administer all the deployments of Microsoft SQL Server 2012 in your company. You need to ensure that an OLTP database that includes up-to-the-minute reporting requirements can be off-loaded from the primary database to another server. You also need to be able to add indexes to...

DRAG DROP You administer a Microsoft SQL Server database. Service accounts for SQL Agent are configured to use a local user. A Microsoft SQL Server Integration Services (SSIS) job step has been created within a SQL Server Agent job. The SSIS package accesses a network share when exporting data from...

You administer a Microsoft SQL Server 2012 Enterprise Edition server that uses 64 cores. You discover performance issues when large amounts of data are written to tables under heavy system load. You need to limit the number of cores that handle I/O. What should you configure?A . Processor affinityB ....

You 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 applications You need to dynamically limit resource consumption. What should you do?A . Configure Resource Pools, Workload Groups, and Classifier Function, and then enable...

DRAG DROP You administer a Microsoft SQL Server 2012 server. A variety of issues occur from time to time in the production environment. You need to identify the appropriate tool for each issue. Which tool or tools should you use? (To answer, drag the appropriate tool or tools to the...