70-464 試験問題を無料オンラインアクセス

You have an application that queries a database.
Users report that the application runs more slowly than expected.
You need to identify which queries take the most time to execute. The solution must minimize the use of processor resources on the server.
What should you use?

• A.Distributed Replay
  References:
  https://docs.microsoft.com/en-us/sql/relational-databases/performance/monitoring-performance-by-using-thequery-store?view=sql-server-2017
• B.a SQL Server Profiler trace
• C.a Central Management Server
• D.Query Store

You need to modify usp_SelectSpeakersByName to support server-side paging. The solution must minimize the amount of development effort required.
What should you add to usp_SelectSpeakersByName?

• A.A table variable
• B.The ROWNUMBER keyword
• C.A recursive common table expression
• D.An OFFSET-FETCH clause

You have a SQL Server 2012 database named DB1 that is accessed by 650 concurrent users.
You need to log all of the queries to DB1 that become deadlocked. The solution must meet the following requirements:
Provide a representation of the deadlock in XML format.
Minimize the impact on the server.
What should you create?

• A.A script that enables trace flags
• B.A SQL Server Agent job that retrieves information from the sys.dm_tran_session_transactions dynamic management views
• C.A SQL Server Agent job that retrieves information from the sys.dm_tran_active_transactions dynamic management views
• D.A SQL Server Profiler trace

You need to implement a solution that addresses the page split issues.
Which statement should you execute?

• A.ALTER INDEX IX_Orders_ShipDate ON Orders
  REBUILD WITH (FILLFACTOR=50, DROP_EXISTING = ON);
• B.ALTER INDEX IX_Orders_ShipDate ON Orders
  REBUILD WITH (FILLFACTOR = 0, DROP_EXISTING = ON);
• C.ALTER INDEX IX_Orders_ShipDate ON Orders
  REBUILD WITH (PAD_INDEX=OFF, DROP_EXISTING = ON);
• D.ALTER INDEX IX_Orders_ShipDate ON Orders
  REBUILD WITH (PAD_INDEX=ON, DROP_EXISTING = ON);

The database contains a disk-based table named ContentTable that has 1 million rows and a column named Fax. Fax allows null values.
You need to update Fax to meet the following requirements:
Prevent null values from being used.
Always use an empty string instead of a null value.
Which statement or statements should you execute? (Each correct answer presents part of the solution. Choose all that apply.)

• A.Option A
• B.Option B
• C.Option E
• D.Option C
• E.Option D