Microsoft Exam 70-762 Topic 15 Question 1 Discussion

Actual exam question for Microsoft's 70-762 exam

Question #: 1
Topic #: 15

Note: The 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 is independent of the other question in the series. Information and details provided in a question apply only to that question.

You have a database named DB1. The database does not use a memory-optimized filegroup. The database contains a table named Table1. The table must support the following workloads:

You need to add the most efficient index to support the new OLTP workload, while not deteriorating the existing Reporting query performance.

What should you do?

ACreate a clustered index on the table.

BCreate a nonclustered index on the table.

CCreate a nonclustered filtered index on the table.

DCreate a clusteredcolumnstore index on the table.

ECreate a nonclustered columnstore index on the table.

FCreate a hash index on the table.

Show Suggested Answer

Suggested Answer: C

A filtered index is an optimized nonclustered index, especially suited to cover queries that select from a well-defined subset of data. It uses a filter predicate to index a portion of rows in the table. A well-designed filtered index can improve query performance, reduce index maintenance costs, and reduce index storage costs compared with full-table indexes.

References: https://technet.microsoft.com/en-us/library/cc280372(v=sql.105).aspx

by Lonny at May 07, 2022, 07:57 PM

Limited Time Offer

25%

Off

Get Premium 70-762 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!