ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-201 All Questions

View all questions & answers for the DP-201 exam
Go to Exam

Exam DP-201 topic 5 question 5 discussion

Actual exam question from Microsoft's DP-201
Question #: 5
Topic #: 5
[All DP-201 Questions]

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:

Show Suggested Answer Hide Answer
Suggested 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 vehicle
Design Azure data storage solutions
by Ous01 at May 29, 2021, 2:42 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Ous01
Highly Voted 4 years ago
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!!!
upvoted 7 times
BigMF
3 years, 11 months ago
Agreed with Ouso1 and MMM777. Should be Yes, No, No
upvoted 3 times
...
...
dlena
Most Recent 3 years, 8 months ago
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
upvoted 1 times
...
ZodiaC
3 years, 12 months ago
This is correct
upvoted 1 times
...
MMM777
3 years, 12 months ago
"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?
upvoted 2 times
tes
3 years, 11 months ago
"This solution reports on all data related to a specific vehicle license plate." how is this possible without querying LicensePlate? "license plate number information must not be accessible in Planning Assistance" correct not for planning but for reporting. so index it
upvoted 1 times
tes
3 years, 11 months ago
sorry the question is about planning. Hence you are right
upvoted 1 times
...
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel