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

Questions 6–10

1. 6expert · hard

   A company has a customer database with a table that stores customer ID, name, and email. They also have a separate table for orders. The company needs to generate a report that shows each customer and the total number of orders they have placed. The report must include customers who have never placed an order. Which query approach is correct?

   • AUse a subquery to count orders and then filter out customers with zero orders
   • BUse a RIGHT JOIN between customers and orders, then GROUP BY customer
   • CUse an INNER JOIN between customers and orders, then GROUP BY customer
   • DUse a LEFT JOIN between customers and orders, then GROUP BY customer
   Reveal Solution Discussion Select an answer first
2. 7foundation · easy

   A web application stores user preferences in a file that uses key-value pairs and can have nested objects. What type of data is this?

   • ASemi-structured data, because it uses key-value pairs and nested objects.
   • BUnstructured data, because it is not stored in a database.
   • CStructured data, because it has a defined format.
   • DStructured data, because it is stored in a file.
   Reveal Solution Discussion Select an answer first
4. 8foundation · easy

   Which statement best describes unstructured data?

   • AData that is stored in a key-value store with flexible attributes.
   • BData that uses tags to organize information into a hierarchy.
   • CData that has a predefined schema and is stored in tables.
   • DData that has no predefined format or organization, making it difficult to search and analyze.
   Reveal Solution Discussion Select an answer first
5. 9application · medium

   A mobile app sends analytics events to the cloud. Each event has a common set of properties (event name, user ID, timestamp) and a variable set of custom properties that differ by event type. The analytics team wants to query events by event name and user ID, and also filter on custom properties. Which storage solution is most appropriate?

   • AAzure Blob Storage storing each event as a separate text file
   • BAzure SQL Database with a table that has a column for every possible custom property
   • CAzure Table Storage with a row per event and a column per custom property
   • DAzure Cosmos DB storing each event as a JSON document
   Reveal Solution Discussion Select an answer first
6. 10foundation · easy

   Which of the following is an example of unstructured data?

   • AAn audio recording of a customer service call.
   • BA SQL database table with customer orders.
   • CAn XML file with configuration settings.
   • DA JSON file containing product details.
   Reveal Solution Discussion Select an answer first