Microsoft
DP-203 · Question #254
You need to create a quick object in a test environment and therefore you decide to create a temporal table with an "anonymous" history table. From the given below statement/remarks about the history
Sign in or unlock DP-203 to reveal the answer and full explanation for question #254. The question stem and answer options stay visible for context.
Submitted by carlos_mx· Mar 30, 2026Design and implement data storage
Question
You need to create a quick object in a test environment and therefore you decide to create a temporal table with an "anonymous" history table. From the given below statement/remarks about the history table in this context, choose the statement(s) that is/are true.
Options
- AYou need to manually create the anonymous history table and provide its specific schema
- BThe history table is created as a rowstore table
- CThe history table is created as a columnstore table
- DA default clustered index is developed for the history table
- EA history table is always uncompressed. No compression is ever applied on the history table
Unlock DP-203 to see the answer
You've previewed enough free DP-203 questions. Unlock DP-203 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
#temporal tables#anonymous history table#rowstore index#clustered index