Explain Data Concepts DA0-001 Practice Questions (Page 6)

Questions 26–30

1. 26foundation · easy

   Which of the following best describes the fundamental structure of a relational database?

   • AA set of tables that store data in rows and columns, with relationships defined between tables
   • BA collection of documents stored in a flexible, schema-less format
   • CA tree-like structure where each record has a single parent and potentially multiple children
   • DA graph of nodes and edges representing interconnected data points
   Reveal Solution Discussion Select an answer first
2. 27application · medium

   A ride-sharing company stores driver locations and trip events. Each event has a variable set of attributes (e.g., weather, traffic, surge multiplier) that change frequently as new data sources are added. The data team needs a storage system that can ingest these records without requiring a fixed schema and can scale horizontally across many servers. Which type of database best fits this requirement?

   • AA flat file structure where each event is appended as a new line with a fixed field order.
   • BA document-oriented NoSQL database storing each event as a JSON document.
   • CA relational database with a wide table containing a column for every possible attribute.
   • DA hierarchical database where each trip is a parent node with child nodes for each attribute.
   Reveal Solution Discussion Select an answer first
4. 28application · medium

   A healthcare organization needs to exchange patient records with an external system. The external system requires a format that supports custom tags and strict schema validation, and the organization values the ability to define their own document structure. Which file format is most appropriate for this data interchange?

   • AXML
   • BCSV
   • CJSON
   • DA relational database dump
   Reveal Solution Discussion Select an answer first
5. 29expert · medium

   A data engineer receives a large CSV file (5 GB) containing sensor readings. The file has a header row and uses commas as delimiters. Some fields contain quoted values with embedded commas (e.g., "device, model"). The engineer needs to load this file into a data warehouse. What is the most important consideration when parsing this file?

   • AThe parser must handle quoted fields to correctly interpret embedded commas.
   • BThe file size is too large for any data warehouse to handle.
   • CThe header row should be removed before parsing.
   • DThe file must be converted to JSON before loading into the warehouse.
   Reveal Solution Discussion Select an answer first
6. 30application · easy

   A data analyst is cleaning a CSV file containing customer records. One column, 'age', contains values like '25', 'thirty', and 'N/A'. Another column, 'is_active', contains 'true', 'false', and 'yes'. The analyst needs to standardize these columns for analysis. What is the most appropriate data type for each column after cleaning?

   • Aage as string, is_active as string
   • Bage as boolean, is_active as integer
   • Cage as integer, is_active as boolean
   • Dage as float, is_active as integer
   Reveal Solution Discussion Select an answer first