What is the purpose of an external table in a database?

To store data in a separate database

To enforce referential integrity across databases

To provide a queryable interface over data stored outside the database

To create a backup of the database

What happens if you try to insert a row into a child table with a foreign key value that does not exist in the parent table?

The parent row is automatically created

The insert is allowed but flagged

The insert is rejected with an error

The row is inserted with a NULL foreign key

A large fact table is partitioned by month. Queries frequently aggregate sales amounts by product across a full year. The table has billions of rows. You need to improve query performance for these aggregations. What should you implement?

Create a partitioned view instead of a partitioned table.

Create a nonclustered rowstore index on the product column.

Create a clustered columnstore index aligned with the partitioning scheme.

Create a nonclustered columnstore index on the amount column only.

Microsoft Certified:SQL AI Developer Associate

Domain 1Objective 1

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

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 26–30

26foundation · easy
What is the purpose of an external table in a database?
Select an answer first
27foundation · easy
What happens if you try to insert a row into a child table with a foreign key value that does not exist in the parent table?
Select an answer first
28application · medium
A large fact table is partitioned by month. Queries frequently aggregate sales amounts by product across a full year. The table has billions of rows. You need to improve query performance for these aggregations. What should you implement?
Select an answer first
29foundation · easy
Which constraint would you use to ensure that an Email column does not contain duplicate values, but allows NULL?
Select an answer first
30foundation · easy
Which two columns are required in a system-versioned temporal table?
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 6)

Questions 26–30

What is the purpose of an external table in a database?

What happens if you try to insert a row into a child table with a foreign key value that does not exist in the parent table?

A large fact table is partitioned by month. Queries frequently aggregate sales amounts by product across a full year. The table has billions of rows. You need to improve query performance for these aggregations. What should you implement?

Which constraint would you use to ensure that an Email column does not contain duplicate values, but allows NULL?

Which two columns are required in a system-versioned temporal table?

Keep studying — Design and develop database solutions