Free Microsoft 70-462 Exam Dumps Questions & Answers

You administer a Microsoft SQL Server database 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 gather blocking data over an extended period of time. You also need to ensure minimum impact to server performance.
What should you do?

• A.  Run the sp_who2 command from a query window and examine the BlkBy column.
• B.  Use the Job Activity monitor to review all processes that are actively running. Review the Job History to find out the duration of each step.
• C.  Run the DBCC TRACEON 1222 command from a query window and review the SQL Server event log.
• D.  Use SQL Profiler to trace all queries that are processing on the server. Filter queries that have a Duration value of more than 1,000 ms.
• E.  Use sp_configure to set a value for blocked process threshold. Create an extended event session.

You are completing the installation of the Data Quality Server component of SQL Server Data Quality Services (DQS).
You need to complete the post-installation configuration.
What should you do?

• A.  Run the Data Quality Server Installer.
• B.  Run the Configuration component in the Data Quality Client.
• C.  Make the data available for DQS operations.
• D.  Install ADOMD.NET.

You administer a Microsoft SQL Server database 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 extended period of time.
What should you do?

• A.  Run the sp_who command from a query window.
• B.  Use the Job Activity monitor to review all processes that are actively running. Review the Job History to find out the duration of each step.
• C.  Run the DBCC TRACEON 1222 command from a query window and review the SQL Server event log.
• D.  Use sp_configure to set a value for blocked process threshold. Create an extended event session.
• E.  use SQL Profiler to trace all queries that are processing on the server. Filter queries that have a Duration value of more than 1,000.

You administer a Microsoft SQL Server database.
Every Sunday afternoon, a process inserts a large volume of data. Users generate reports and modify additional data throughout the week.
You need to create a backup strategy that:
* minimizes the size of the transaction log,
* minimizes the size of the backups, and
* ensures a 24-hour recovery point objective (RPO).
Which strategy or strategies should you use? (To answer, drag the appropriate strategy or strategies to their corresponding task or tasks in the answer area. Answer choices may be used once, more than once, or not at all. Answer targets may be used once or not at all. Additionally, you may need to drag the split bar between panes or scroll to view content.)

Correct Answer:

Explanation

Recovery Model: Full recovery model
Only the Full recovery model provides a 24-hour recovery point objective.
Sunday backup: Full backup
Nightly backup: Transactional log backup
References:
https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/recovery-models-sql-server

You administer a Microsoft SQL Server 2012.
A process that normally runs in less than 10 seconds has been running for more than an hour.
You examine the application log and discover that the process is using session ID 60.
You need to find out whether the process is being blocked.
Which Transact-SQL statement should you use?

• A.  EXEC sp_helpdb 60
• B.  EXEC sp_who 60
• C.  SELECT * FROM sys.dm_exec_sessions WHERE sessionjd = 60
• D.  DBCC INPUTBUFFER (60)