nerdexam
Microsoft

DP-203 · Question #263

You have a traditional data warehouse storage with a snowflake schema with row-oriented storage that takes considerable time and low performance during queries. You plan to use clustered columnstore i

Sign in or unlock DP-203 to reveal the answer and full explanation for question #263. The question stem and answer options stay visible for context.

Submitted by brentm· Mar 30, 2026Design and implement data storage

Question

You have a traditional data warehouse storage with a snowflake schema with row-oriented storage that takes considerable time and low performance during queries. You plan to use clustered columnstore indexing. Will it improve query performance?

Options

  • AYes
  • BNo

Unlock DP-203 to see the answer

You've previewed enough free DP-203 questions. Unlock DP-203 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#clustered columnstore index#query performance#data warehouse#row vs column storage
Full DP-203 Practice