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

Questions 21–25

1. 21foundation · easy

   Which database object is required to create an external table in Azure SQL Database?

   • AExternal file format
   • BMaster key
   • CDatabase scoped credential
   • DExternal data source
   Reveal Solution Discussion Select an answer first
2. 22application · medium

   A telemetry system stores billions of rows in a fact table partitioned by date. Queries often filter by a specific date range and also join on a DeviceID column. The table has a PRIMARY KEY on (DeviceID, Timestamp). You need to ensure that queries filtering by date range can eliminate partitions efficiently. What should you do?

   • ACreate a nonclustered index on DeviceID only.
   • BRemove the primary key to speed up inserts.
   • CUse a columnstore index without partitioning.
   • DAlign the clustered index and the primary key with the partitioning column.
   Reveal Solution Discussion Select an answer first
4. 23foundation · easy

   Which statement is true about a PRIMARY KEY constraint?

   • AA primary key column can contain NULL values
   • BA primary key is optional for every table
   • CA primary key can be created on a column with duplicate values
   • DA table can have only one primary key
   Reveal Solution Discussion Select an answer first
5. 24foundation · easy

   Which function is used to validate that a string contains valid JSON?

   • AISJSON
   • BTRY_PARSE
   • CJSON_QUERY
   • DJSON_VALUE
   Reveal Solution Discussion Select an answer first
6. 25foundation · easy

   When designing a table to store customer names, which data type is most appropriate for the FirstName column?

   • ANVARCHAR(50)
   • BTEXT
   • CVARCHAR(MAX)
   • DCHAR(50)
   Reveal Solution Discussion Select an answer first