nerdexam
MicrosoftMicrosoft

PL-300 · Question #332

PL-300 Question #332: Real Exam Question with Answer & Explanation

Sign in or unlock PL-300 to reveal the answer and full explanation for question #332. The question stem and answer options stay visible for context.

Submitted by kim_seoul· Apr 18, 2026

Question

You are creating a query to be used as a Country dimension in a star schema. A snapshot of the source data is shown in the following table. You need to create the dimension. The dimension must contain a list of unique countries. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Options

  • ADelete the Country column.
  • BRemove duplicates from the table.
  • CRemove duplicates from the City column.
  • DDelete the City column.
  • ERemove duplicates from the Country column.

Unlock PL-300 to see the answer

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

Full PL-300 PracticeBrowse All PL-300 Questions