A HR database has an Employees table with a Salary column and a SalaryType column that can be 'Hourly' or 'Salary'. The business rule states that hourly employees must have a salary less than 100, and salaried employees must have a salary between 500 and 1000. You need to enforce this rule at the database level. What should you implement?

A FOREIGN KEY to a lookup table for SalaryType.

A CHECK constraint that validates the salary range based on SalaryType.

A DEFAULT constraint on SalaryType.

What is the purpose of a FOREIGN KEY constraint?

To automatically delete rows from the parent table

To enforce that column values are unique

To maintain referential integrity between two tables

How can you improve the performance of queries that filter on a property inside a JSON column?

Create a full-text index on the JSON column

Create a columnstore index on the JSON column

Create a computed column for the JSON property and index it

Use a hash index on the JSON column

Microsoft Certified:SQL AI Developer Associate

Domain 1Objective 1

Design and Implement Database Objects DP-800 Practice Questions (Page 2)

Part of the Design and develop database solutions domain, which accounts for 35–40% of the DP-800 exam. Microsoft does not publish an official question count, but from its 120-minute exam (~50–80 total, ~18–32 in this domain), expect 5–8 from this objective — we provide 47 practice questions to prepare you well beyond it. (estimate)

47questions here

10free pages

17concepts

35–40%of the exam

Questions 6–10

6foundation · easy
Which database object defines how rows are distributed across partitions?
Select an answer first
7application · medium
A HR database has an Employees table with a Salary column and a SalaryType column that can be 'Hourly' or 'Salary'. The business rule states that hourly employees must have a salary less than 100, and salaried employees must have a salary between 500 and 1000. You need to enforce this rule at the database level. What should you implement?
Select an answer first
8foundation · easy
Which type of ledger table stores only the latest state of each row?
Select an answer first
9foundation · easy
What is the purpose of a FOREIGN KEY constraint?
Select an answer first
10foundation · easy
How can you improve the performance of queries that filter on a property inside a JSON column?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DP-800

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “DP-800” is a trademark of its owner, used for identification only.

Design and Implement Database Objects DP-800 Practice Questions (Page 2)

Questions 6–10

Which database object defines how rows are distributed across partitions?

Which type of ledger table stores only the latest state of each row?

What is the purpose of a FOREIGN KEY constraint?

How can you improve the performance of queries that filter on a property inside a JSON column?

Keep studying — Design and develop database solutions