HOTSPOT - You are building the data store solution for Mechanical Workflow. How should you configure Table1? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area:
Suggested Answer:
Table Type: Hash distributed. Hash-distributed tables improve query performance on large fact tables.
Index type: Clusted columnstore - Scenario: Mechanical Workflow has a named Table1 that is 1 TB. Large aggregations are performed on a single column of Table 1. References: https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-tables-distribute
This section is not available anymore. Please use the main Exam Page.DP-200 Exam Questions
Log in to ExamTopics
Sign in:
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.
Shanmahi
4 years, 5 months ago