Valid 70-762 Dumps shared by ExamDiscuss.com for Helping Passing 70-762 Exam! ExamDiscuss.com now offer the newest 70-762 exam dumps, the ExamDiscuss.com 70-762 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com 70-762 dumps with Test Engine here:
Access 70-762 Dumps Premium Version
(185 Q&As Dumps, 35%OFF Special Discount Code: freecram)
<< Prev Question Next Question >>
Question 20/82
Note: This question is part of a series of questions that use the same or similar answer choices. An Answer choice may be correct for more than one question in the series. Each question independent of the other questions in this series. Information and details provided in a question apply only to that question.
You are a database developer for a company. The company has a server that has multiple physical disks.
The disks are not part of a RAID array. The server hosts three Microsoft SQL Server instances. There are many SQL jobs that run during off-peak hours.
You must monitor the SQL Server instances in real time and optimize the server to maximize throughput, response time, and overall SQL performance.
You need to collect query performance data while minimizing the performance impact on the SQL Server.
What should you do?
You are a database developer for a company. The company has a server that has multiple physical disks.
The disks are not part of a RAID array. The server hosts three Microsoft SQL Server instances. There are many SQL jobs that run during off-peak hours.
You must monitor the SQL Server instances in real time and optimize the server to maximize throughput, response time, and overall SQL performance.
You need to collect query performance data while minimizing the performance impact on the SQL Server.
What should you do?
Correct Answer: C
Explanation/Reference:
Explanation:
SQL Server Data Collector is a feature for performance monitoring and tuning available in SQL Server Management Studio.
Integration Services packages transform and load the collected data into theMicrosoft Data Warehouse database.
Collection sets are defined and deployed on a server instance and can be run independently of each other.
Each collection set can be applied to a target that matches the target types of all the collector types that are part of a collection set. The collection set is run by a SQL Server Agent job or jobs, and data is uploaded to the management data warehouse on a predefined schedule.
Predefined data collection sets include:
* The Query Statistics data collection set collects information about query statistics, activity, execution plans and text on the SQL Server instance. It does not store all executed statements, only 10 worst performing ones.
* Disk Usage data collection set collects information about disk space used byboth data and log files for all databases on the SQL Server instance, growth trends, and average day growth.
Etc.
References:http://www.sqlshack.com/sql-server-performance-monitoring-data-collector/
Explanation:
SQL Server Data Collector is a feature for performance monitoring and tuning available in SQL Server Management Studio.
Integration Services packages transform and load the collected data into theMicrosoft Data Warehouse database.
Collection sets are defined and deployed on a server instance and can be run independently of each other.
Each collection set can be applied to a target that matches the target types of all the collector types that are part of a collection set. The collection set is run by a SQL Server Agent job or jobs, and data is uploaded to the management data warehouse on a predefined schedule.
Predefined data collection sets include:
* The Query Statistics data collection set collects information about query statistics, activity, execution plans and text on the SQL Server instance. It does not store all executed statements, only 10 worst performing ones.
* Disk Usage data collection set collects information about disk space used byboth data and log files for all databases on the SQL Server instance, growth trends, and average day growth.
Etc.
References:http://www.sqlshack.com/sql-server-performance-monitoring-data-collector/
- Question List (82q)
- Question 1: You use Microsoft SQL Server Profile to evaluate a query nam...
- Question 2: Note: this question is part of a series of questions that us...
- Question 3: Note: The question is part of a series of questions that use...
- Question 4: Note: This question is part of a series of questions that pr...
- Question 5: You have a relational data warehouse that contains 1 TB of d...
- Question 6: You have a database that users query frequently. The users r...
- Question 7: Note: This question is part of a series of questions that pr...
- Question 8: Note: This question is part of a series of questions that us...
- Question 9: You have the following stored procedure: (Exhibit) The Numbe...
- Question 10: Note: this question is part of a series of questions that us...
- Question 11: Note: this question is part of a series of questions that us...
- Question 12: Note: This question is part of a series of questions that pr...
- Question 13: Note: This question is part of a series of questions that pr...
- Question 14: Note: This question is part of a series of questions that pr...
- Question 15: You have multiple stored procedures inside a transaction. Yo...
- Question 16: Note: This question is part of a series of questions that us...
- Question 17: You use Microsoft SQL Server Profile to evaluate a query nam...
- Question 18: You have several real-time applications that constantly upda...
- Question 19: You run the following Transact-SQL statement: (Exhibit) Ther...
- Question 20: Note: This question is part of a series of questions that us...
- Question 21: Note: This question is part of a series of questions that pr...
- Question 22: You are experiencing performance issues with the database se...
- Question 23: Note: This question is part of a series of questions that pr...
- Question 24: Note: This question is part of a series of questions that pr...
- Question 25: You have a database that is experiencing deadlock issues whe...
- Question 26: Note: this question is part of a series of questions that us...
- Question 27: You are developing an ETL process to cleanse and consolidate...
- Question 28: You are experiencing performance issues with the database se...
- Question 29: Your company runs end-of-the-month accounting reports. While...
- Question 30: Note: This question is part of a series of questions that pr...
- Question 31: Note: This question is part of a series of questions that pr...
- Question 32: Note: This question is part of a series of questions that pr...
- Question 33: Note: This question is part of a series of questions that pr...
- Question 34: Note: This question is part of a series of questions that pr...
- Question 35: Note: This question is part of a series of questions that pr...
- Question 36: Note: This question is part of a series of questions that us...
- Question 37: You are designing a stored procedure for a database named DB...
- Question 38: Note: This question is part of a series of questions that pr...
- Question 39: You suspect deadlocks on a database. Which two trace flags i...
- Question 40: Note: This question is part of a series of questions that pr...
- Question 41: Note: this question is part of a series of questions that us...
- Question 42: Note: This question is part of a series of questions that us...
- Question 43: Note: This question is part of a series of questions that pr...
- Question 44: You run the following Transact-SQL following statement: (Exh...
- Question 45: Note: This question is part of a series of questions that us...
- Question 46: You are creating the following two stored procedures: A nati...
- Question 47: Note: This question is part of a series of questions that pr...
- Question 48: Note: This question is part of a series of questions that pr...
- Question 49: Note: This question is part of a series of questions that pr...
- Question 50: Note: This question is part of a series of questions that us...
- Question 51: Note: This question is part of a series of questions that pr...
- Question 52: You are developing an application that connects to a databas...
- Question 53: Note: this question is part of a series of questions that us...
- Question 54: You have a view that includes an aggregate. You must be able...
- Question 55: Note: This question is part of a series of questions that us...
- Question 56: You are designing a solution for a company that operates ret...
- Question 57: Note: This question is part of a series of questions that pr...
- Question 58: You need to create a view that can be indexed. You write the...
- Question 59: Note: This question is part of a series of questions that pr...
- Question 60: Note: This question is part of a series of questions that us...
- Question 61: Note: The question is part of a series of questions that use...
- Question 62: Note: This question is part of a series of questions that pr...
- Question 63: Note: This question is part of a series of questions that pr...
- Question 64: Note: This question is part of a series of questions that us...
- Question 65: Note: This question is part of a series of questions that us...
- Question 66: Note: This question is part of a series of questions that pr...
- Question 67: You run the following Transact-SQL statements: (Exhibit) Rec...
- Question 68: Note: This question is part of a series of questions that pr...
- Question 69: Note: This question is part of a series of questions that pr...
- Question 70: You have the following stored procedure that is called by ot...
- Question 71: You have a nonpartitioned table that has a single dimension....
- Question 72: Note: this question is part of a series of questions that us...
- Question 73: Note: This question is part of a series of questions that us...
- Question 74: Note: This question is part of a series of questions that us...
- Question 75: Background You have a database named HR1 that includes a tab...
- Question 76: Note: This question is part of a series of questions that pr...
- Question 77: You are developing a database reporting solution for a table...
- Question 78: Note: The question is part of a series of questions that use...
- Question 79: Note: This question is part of a series of questions that us...
- Question 80: Note: This question is part of a series of questions that us...
- Question 81: You have a reporting application that uses a table named Tab...
- Question 82: Note: This question is part of a series of questions that us...
