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

Exam DP-203 All Questions

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

Exam DP-203 topic 1 question 23 discussion

Actual exam question from Microsoft's DP-203
Question #: 23
Topic #: 1
[All DP-203 Questions]

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have an Azure Storage account that contains 100 GB of files. The files contain rows of text and numerical values. 75% of the rows contain description data that has an average length of 1.1 MB.
You plan to copy the data from the storage account to an enterprise data warehouse in Azure Synapse Analytics.
You need to prepare the files to ensure that the data copies quickly.
Solution: You copy the files to a table that has a columnstore index.
Does this meet the goal?

  • A. Yes
  • B. No
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by michalS at Sept. 2, 2021, 2:58 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
bhanuprasad9331
Highly Voted 3 years ago
From the documentation, loads to heap table are faster than indexed tables. So, better to use heap table than columnstore index table in this case. https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-index#heap-tables
upvoted 12 times
...
Odoxtoom
Highly Voted 3 years, 4 months ago
Consider this sets one question: What should you do to improve loading times? What | Yes | No | compressed | O | O | columnstore | O | O | > 1MB | O | O | So now answers should be clear
upvoted 9 times
Julius7000
3 years, 4 months ago
Can You explain this in more details?
upvoted 11 times
...
helly13
3 years, 2 months ago
I really didn't understand this , can you explain?
upvoted 7 times
aurorafang
2 years, 6 months ago
it's a virtualized chart that the guy want to simplified the question set.
upvoted 2 times
ML_Novice
2 years, 5 months ago
but it becomes more complicated with this chart haha
upvoted 6 times
...
...
...
tbhtp
2 years, 5 months ago
I Think what he tried to show was: Set Answer Matrix What should you do to improve loading times? What | Yes | No | compressed | X | O | columnstore | O | X | > 1MB | O | X | So all three variations of this question and x is marking the correct answer.
upvoted 5 times
...
...
Pey1nkh
Most Recent 5 days, 19 hours ago
Selected Answer: A
- A columnstore index stores columns separately, allowing queries to only read relevant columns, making queries much faster! - Columnstore indexes automatically compress data, reducing storage size and I/O. - This is especially useful for large text data like descriptions and numerical values
upvoted 1 times
...
moize
2 months, 3 weeks ago
Selected Answer: A
Moi je vote A). Selon Copilot : Oui, copier les fichiers dans une table avec un index columnstore dans Azure Synapse Analytics peut répondre à l'objectif de copier les données rapidement. Les index columnstore sont conçus pour optimiser les performances des requêtes et la compression des données, ce qui est particulièrement utile pour les grandes quantités de données.
upvoted 1 times
...
EmnCours
2 months, 3 weeks ago
Selected Answer: B
Correct Answer: B
upvoted 1 times
...
kkk5566
1 year, 5 months ago
Selected Answer: B
Answer is no ,u use HEAP idx
upvoted 1 times
...
youngbug
2 years ago
For fast loading to a table, using a staging table which is a heap table.
upvoted 1 times
...
DindaS
2 years, 1 month ago
its always recommended to load the data into a staging where the table should be a heap table and data will be loaded using ROUND_ROBIN mechanism
upvoted 1 times
...
Deeksha1234
2 years, 6 months ago
B is right
upvoted 1 times
...
Janisys
2 years, 7 months ago
Correct Answer: B To achieve the fastest loading speed for moving data into a data warehouse table, load data into a staging table. Define the staging table as a heap and use round-robin for the distribution option
upvoted 5 times
...
Deepshikha1228
2 years, 7 months ago
B is right
upvoted 1 times
...
Amsterliese
2 years, 10 months ago
Columnstore index would be used for faster reading, but the question is only about faster loading. So for faster loading you want the least possible overhead. So the answer should be no. Am I right?
upvoted 4 times
Muishkin
2 years, 10 months ago
Yes load to a table without indexes for faster load right?
upvoted 1 times
...
...
lionurag
2 years, 11 months ago
Selected Answer: B
B is correct
upvoted 3 times
...
PallaviPatel
3 years ago
Selected Answer: B
B is correct.
upvoted 1 times
...
DE_Sanjay
3 years, 1 month ago
NO is the answer.
upvoted 1 times
...
Mahesh_mm
3 years, 1 month ago
B is correct
upvoted 1 times
...
rashjan
3 years, 2 months ago
Selected Answer: B
Correct Answer: No.
upvoted 2 times
...
Load full discussion...
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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago