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

Questions 1–5

1. 1application · medium

   A bank maintains a customer account table in a relational database. The table has a primary key on AccountID and an index on CustomerID. The bank wants to retrieve all accounts for a specific customer quickly. Which aspect of structured data storage primarily enables this fast retrieval?

   • AThe use of a hierarchical folder structure to store each account as a separate file.
   • BThe use of indexes and keys that organize data for efficient lookup.
   • CThe storage of data in a key-value store where each key is the entire row.
   • DThe storage of data in a single large file that is read sequentially.
   Reveal Solution Discussion Select an answer first
2. 2application · medium

   A retail company maintains a customer database with columns for CustomerID, Name, Email, and Phone. Each row represents a distinct customer, and every column has a defined data type. The company wants to run aggregate queries to count customers by city. Which characteristic of structured data makes this aggregation efficient?

   • AThe data is stored as key-value pairs that can be indexed by any attribute.
   • BThe data has a fixed schema with rows and columns that enforce consistent data types.
   • CThe data is stored in a hierarchical tree structure that mirrors the company's org chart.
   • DThe data is stored as a single text file with delimiters that can be parsed at query time.
   Reveal Solution Discussion Select an answer first
4. 3application · medium

   An e-commerce company stores product information in a relational database with columns for ProductID, Name, Price, and Category. They also store customer reviews as free text. The company wants to run a report that shows the average price per category. Which data should they use for this report?

   • AThe unstructured customer review text.
   • BA combination of product data and reviews in a NoSQL database.
   • CThe product data stored as JSON documents.
   • DThe structured product data in the relational database.
   Reveal Solution Discussion Select an answer first
5. 4foundation · easy

   What is the primary benefit of storing structured data in a relational database?

   • AIt eliminates the need for indexing because data is stored in a single file.
   • BIt enables efficient querying and data integrity through the use of a fixed schema and relationships.
   • CIt allows for flexible schema changes without affecting existing data.
   • DIt allows storing data without any predefined structure, making it easy to add new fields.
   Reveal Solution Discussion Select an answer first
6. 5application · medium

   A research organization collects raw sensor data from scientific instruments. The data is stored as binary files with varying formats depending on the instrument. The organization wants to run analytics across all instruments. What is the primary challenge they must overcome?

   • AThe data cannot be processed by any analytics tool.
   • BThe data is too large to be stored in the cloud.
   • CThe data lacks a common schema, so they must parse and normalize each format before analysis.
   • DThe data must be manually entered into a spreadsheet.
   Reveal Solution Discussion Select an answer first