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

Questions 36–40

1. 36foundation · easy

   How is structured data typically stored and organized in a database?

   • AIn a graph with nodes and edges to represent relationships.
   • BIn a flat file with no defined schema, such as a text file.
   • CIn documents with key-value pairs, where each document can have different fields.
   • DIn tables with rows and columns, where each column has a predefined data type.
   Reveal Solution Discussion Select an answer first
2. 37foundation · easy

   What is a common challenge when storing and processing unstructured data?

   • AIt cannot be stored in the cloud because of its large size.
   • BIt is difficult to search and analyze because there is no predefined schema.
   • CIt requires a relational database to be stored efficiently.
   • DIt is always encrypted, making it inaccessible to applications.
   Reveal Solution Discussion Select an answer first
4. 38application · medium

   A university maintains a student enrollment system. Each student record has a fixed set of attributes: student ID, name, date of birth, and enrolled courses. The university needs to generate reports that count the number of students enrolled in each course. How should the data be structured to support this reporting efficiently?

   • AA single table with a column for each possible course
   • BA CSV file with one row per student and a comma-separated list of courses
   • CA normalized relational schema with separate tables for students, courses, and enrollments
   • DA JSON document per student with an array of course names
   Reveal Solution Discussion Select an answer first
5. 39expert · hard

   A company receives product data from suppliers in both XML and JSON formats. The data has a common core (product ID, name, price) but each supplier includes different additional attributes. The company needs to load this data into a data warehouse for reporting, and the reporting team wants a single consistent schema. What is the most efficient approach?

   • ALoad the raw XML and JSON files directly into the data warehouse
   • BStore the raw files in Azure Blob Storage and query them with Azure Synapse Serverless SQL
   • CUse Azure Data Factory to transform both formats into a common structured schema before loading
   • DAsk each supplier to send data in a single agreed-upon format
   Reveal Solution Discussion Select an answer first
6. 40application · medium

   A financial institution maintains a ledger of transactions in a relational database. Each transaction has a fixed set of attributes: TransactionID, Date, Amount, and AccountID. The institution needs to ensure that all transactions have the same structure and that data integrity is maintained. Which characteristic of structured data supports this requirement?

   • AThe data is stored as a collection of JSON documents.
   • BThe data is stored as key-value pairs that can vary between records.
   • CThe data conforms to a predefined schema with data types and constraints.
   • DThe data is stored in a hierarchical format that allows nested records.
   Reveal Solution Discussion Select an answer first