SKILL 2.2 AND 2.3 QUIZ

QUESTION 1

  1. Which is made up of a number of scheduled SQL server agent jobs and SSIS packages that collect metrics through DMOs, performance object counters, and SQL trace event?
a. Query statistics
b. Server activity history
c. Utility information
d. Data collector

4 points   

QUESTION 2

  1. The valid options for Query store capture mode are:
a. ALL
b. AUTO
c. NONE
d. All of the above

4 points   

QUESTION 3

  1. _____________causes poor performance in a DB engine where multiple transactions are isolated through locking.
a. DMV
b. Gather statistics
c. Blocking
d. DB tracer

4 points   

QUESTION 4

  1. ________________is a way to uniquely identify a transaction in the database
a. Transaction_id
b. Is_snapshot
c. Max_version_chain_traversed
d. Version_store

4 points   

QUESTION 5

  1. _______________was designed to collect system telemetry that assists in troubleshooting incidents and performance issues.
a. Extended event session
b. Indexer
c. Health check wizard
d. Profile manager

4 points   

QUESTION 6

  1. Query store is enabled at the table level.
a. True
b. False

4 points   

QUESTION 7

  1. ________________was designed to supersede the capabilities of SQL trace and SQL profiler which were dated and could affect the performance of the database engine.
a. Query store
b. Database manager
c. Extended events
d. Enterprise dashboard

4 points   

QUESTION 8

  1. _______________consume event data after the event fires and they store data, analyze and aggregate it, or start a task.
a. Targets
b. Event pairing
c. Event file
d. Event tracing

4 points   

QUESTION 9

  1. ________________are used to improve performance in databases but could potentially degrade performance if too many exist in an online transaction processing (OLTP) environment.
a. Indexes
b. Fragmentations
c. Explain plans
d. Column store

4 points   

QUESTION 10

  1. ______________was introduced in SQL Server and enables you to manage your query performance.
a. Optimizer wizard
b. Query Store
c. Trace logs
d. Monitor queries

 

"Get Help With Your Essay
. If you need assistance with writing your essay, our professional essay writing service is here to help!

Order Now