Describe Ways to Represent Data DP-900 Practice Questions (Page 9)

Questions 41–45

1. 41expert · hard

   A company currently stores product catalog data in a relational database. The catalog has a fixed set of attributes, but the marketing team wants to add a flexible field for product specifications that vary by product type. The company also needs to maintain strong consistency for inventory updates. Which approach best balances flexibility and consistency?

   • AMove the entire catalog to Azure Cosmos DB with JSON documents
   • BKeep the relational database and add a JSON column for the variable specifications
   • CStore specifications as unstructured text files in Azure Blob Storage
   • DCreate a separate NoSQL database for specifications and keep inventory in the relational database
   Reveal Solution Discussion Select an answer first
2. 42application · medium

   A bank maintains a customer account table with columns for account number, customer name, balance, and branch code. The bank needs to enforce that each account number is unique and that the branch code must reference a valid branch in a separate branch table. What should the bank implement in the database?

   • AA trigger that validates branch code on every insert and update
   • BA clustered index on branch code and a nonclustered index on account number
   • CA primary key on account number and a foreign key on branch code
   • DA unique index on customer name and a check constraint on balance
   Reveal Solution Discussion Select an answer first
4. 43application · medium

   A travel agency receives booking requests from partners in different formats. Some partners send XML, others send JSON, and the fields are not consistent. The agency wants to store all requests in a single repository and be able to query by booking date and destination. What is the most appropriate approach?

   • AStore each request as a separate text file with a fixed naming convention
   • BConvert all requests to a common JSON schema and store in Azure Cosmos DB
   • CStore the original XML and JSON files in Azure Blob Storage
   • DLoad the data into a SQL table with columns for every possible field
   Reveal Solution Discussion Select an answer first
5. 44foundation · easy

   What is a key feature of JSON as a semi-structured data format?

   • AIt uses tags to define elements and attributes, similar to HTML.
   • BIt is a binary format that is not human-readable.
   • CIt uses key-value pairs and supports nested objects and arrays.
   • DIt requires a predefined schema before any data can be stored.
   Reveal Solution Discussion Select an answer first
6. 45foundation · easy

   What is a key characteristic of unstructured data?

   • AIt is stored in a relational database with a fixed schema.
   • BIt does not have a predefined data model and is often stored as files.
   • CIt is always in a binary format and cannot be read by humans.
   • DIt has a flexible schema that allows different fields in each record.
   Reveal Solution Discussion Select an answer first