Microsoft PL-200 QUESTIONS AND ANSWERS |
VERIFIED AND WELL DETAILED ANSWERS | PLUS
RATIONALES | GUARANTEED PASS | LATEST EXAM
UPDATE | EXAM PREP | STUDY GUIDE | PRACTICE
TEST
, Domain 1: Configure Microsoft Dataverse (25 questions)
1. A company wants to store data in Dataverse. They need to track customer information and ensure that each
customer has a unique email address. What should they use?
- A) A calculated column
- B) A rollup column
- C) An alternate key
- D) A business rule
Answer: C
Rationale: An alternate key enforces uniqueness on a column (or combination of columns) other than the
primary key. This ensures no duplicate email addresses exist.
, 2. A functional consultant needs to create a relationship where a single account can have many contacts, but
each contact belongs to only one account. What type of relationship is this?
- A) Many-to-many
- B) One-to-many
- C) Many-to-one
- D) One-to-one
Answer: B
Rationale: A one-to-many relationship is defined from the parent (account) perspective. From the contact
perspective, it is many-to-one.
3. Which column type automatically calculates values based on other columns in the same table?
- A) Rollup
- B) Calculated
- C) Formula
, - D) Composite
Answer: B
Rationale: Calculated columns derive their values from other columns in the same table using a formula. Rollup
columns aggregate data from related records.
4. A user wants to see data from a related table without creating a new table. What should they use?
- A) A virtual table
- B) A composite table
- C) A logical table
- D) A duplicate table
Answer: A
Rationale: Virtual tables allow you to integrate data from external systems into Dataverse without storing the
data natively.
VERIFIED AND WELL DETAILED ANSWERS | PLUS
RATIONALES | GUARANTEED PASS | LATEST EXAM
UPDATE | EXAM PREP | STUDY GUIDE | PRACTICE
TEST
, Domain 1: Configure Microsoft Dataverse (25 questions)
1. A company wants to store data in Dataverse. They need to track customer information and ensure that each
customer has a unique email address. What should they use?
- A) A calculated column
- B) A rollup column
- C) An alternate key
- D) A business rule
Answer: C
Rationale: An alternate key enforces uniqueness on a column (or combination of columns) other than the
primary key. This ensures no duplicate email addresses exist.
, 2. A functional consultant needs to create a relationship where a single account can have many contacts, but
each contact belongs to only one account. What type of relationship is this?
- A) Many-to-many
- B) One-to-many
- C) Many-to-one
- D) One-to-one
Answer: B
Rationale: A one-to-many relationship is defined from the parent (account) perspective. From the contact
perspective, it is many-to-one.
3. Which column type automatically calculates values based on other columns in the same table?
- A) Rollup
- B) Calculated
- C) Formula
, - D) Composite
Answer: B
Rationale: Calculated columns derive their values from other columns in the same table using a formula. Rollup
columns aggregate data from related records.
4. A user wants to see data from a related table without creating a new table. What should they use?
- A) A virtual table
- B) A composite table
- C) A logical table
- D) A duplicate table
Answer: A
Rationale: Virtual tables allow you to integrate data from external systems into Dataverse without storing the
data natively.
