DP-201 Exam - Question 161

Question

HOTSPOT -You need to design the Planning Assistance database. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. Hot Area:.

Examice · Accepted Answer

Box 1: No -Data used for Planning Assistance must be stored in a sharded Azure SQL Database. Box 2: Yes -Box 3: Yes -Planning Assistance database will include reports tracking the travel of a single vehicleDesign Azure data storage solutions.

Ous01 · Answer

The given answer is not logic. This database is OLAP because ADF adds data once a week and the database is used for query purposes. This is a great use case for clustered columnstore index. I don't know why it is suggested the other way around!!!

MMM777 · Answer

"For privacy reasons, license plate number information must not be accessible in Planning Assistance."  - so why would you need an index on it if the data is not supposed to be accessible?   Also related to the sharding issue - why shard on something you will not query?

ZodiaC · Answer

This is correct

dlena · Answer

Certainly, the nonclustered columnstore index will NOT help because it is a OLAP system.

"Use a nonclustered columnstore index to perform analysis in real time on an OLTP workload. For more information, see Get started with columnstore for real-time operational analytics."

https://docs.microsoft.com/en-us/sql/relational-databases/indexes/columnstore-indexes-overview?view=sql-server-ver15

DP-201 Exam - Question 161

Discussion