nerdexam
Microsoft

DP-600 · Question #215

What is the key feature of creating an empty materialized view?

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

Submitted by emma.c· Apr 18, 2026Prepare and serve data

Question

What is the key feature of creating an empty materialized view?

Options

  • AIt includes all records from the source table
  • BCreation might take a long while to complete
  • CIt is instantly available for query after creation
  • DIt requires the materialized view to be based on existing records

Unlock DP-600 to see the answer

You've previewed enough free DP-600 questions. Unlock DP-600 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

#Materialized Views#View Creation#Query Performance
Full DP-600 Practice