We're so confident of our products that we provide no hassle product exchange.
Microsoft Transition Your MCITP: Database Administrator 2008 or MCITP: Database Developer 2008 to MCSE: Data Platform Sample Questions:
1. You have a query that is used by a reporting dashboard.
Users report that the query sometimes takes a long time to run.
You need to recommend a solution to identify what is causing the issue.
What should you recommend?
More than one answer choice may achieve the goal. Select the BEST answer.
A) Set the blocked process threshold, and then create an alert.
B) Set the blocked process threshold, and then run SQL Server Profiler.
C) Enable trace flag 1204, and then create an alert.
D) Create a job that queries the sys.dm_os_waiting_tasks dynamic management view.
2. You need to recommend a solution for Application1 that meets the security requirements.
What should you include in the recommendation?
A) Secure Socket Layer (SSL)
B) Encrypted columns
C) Certificate Authentication
D) Signed stored procedures
3. You administer an instance of SQL Server 2014.
You are tasked with tuning a common set of queries. You have the results of several test executions, along with query plans. The schema and the data for all database object(s) used remain unchanged between executions. The QueryTime column is defined as a computed column that uses the GETDATEO system function. The query plans and results are shown below:
You need to make an initial diagnosis of the situation, based solely on this input.
Which two statements can you make about the performance characteristics of this query? Each correct answer presents a complete solution. Choose two.
A) The queries would perform better if the index named AccountNumber included the Name column.
B) The queries would perform better if the index named AccountNumber included the Name and QueryTime column.
C) The object Account is a table, with an index having a leading column of AccountNumber and a Clustered Index named PKAccount.
D) The object Account is a view, joining the Account-AccountNumber and Account.PKAccount objects together.
E) The object Account is an indexed view, with an index having a leading column of AccountNumber and a Clustered Index named PKAccount.
F) The queries would perform worse if the index named AccountNumber included the NameColumn.
4. You need to monitor the health of your tables and indexes in order to implement the required index maintenance strategy.
What should you do?
A) Query system DMVs to monitor total_bucket_count. Create alerts to notify you when this value increases.
B) Query system DMVs to monitor avg_chain_length and max_chain_length. Create alerts to notify you when these values converge.
C) Create a SQL Agent alert when the File Table: Avg time per file I/O request value is increasing.
D) Query system DMVs to monitor total_bucket_count. Create alerts to notify you when this value decreases.
5. You have a server that has SQL Server 2012 installed.
You need to identify which parallel execution plans are running in serial.
Which tool should you use?
A) Extended Events
B) Performance Monitor
C) Data Profile Viewer
D) Database Engine Tuning Advisor
Solutions:
| Question # 1 Answer: A | Question # 2 Answer: D | Question # 3 Answer: C,F | Question # 4 Answer: B | Question # 5 Answer: A |
By Hunter
