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

Questions 21–25

1. 21foundation · easy

   What is the primary purpose of the .xml file extension?

   • ATo store data in a binary format for efficient database storage
   • BTo store data as a collection of key-value pairs without any tags
   • CTo store tabular data in a simple comma-separated format
   • DTo store and transport data using a set of custom-defined tags
   Reveal Solution Discussion Select an answer first
2. 22foundation · easy

   Which data type is most appropriate for storing a value that can only be TRUE or FALSE?

   • AFloat
   • BBoolean
   • CString
   • DInteger
   Reveal Solution Discussion Select an answer first
4. 23expert · medium

   A company is migrating a customer relationship management (CRM) system from a relational database to a NoSQL document store. The current system heavily relies on transactions that update multiple tables atomically (e.g., updating a customer record and their orders in one transaction). The team is concerned about data consistency. What is the most important consideration for this migration?

   • AThe migration is trivial because NoSQL databases support the same SQL syntax.
   • BJSON documents cannot store nested data, so the migration is impossible.
   • CNoSQL databases are always slower than relational databases for read operations.
   • DNoSQL databases may not support multi-document ACID transactions, which could break the current atomic update patterns.
   Reveal Solution Discussion Select an answer first
5. 24application · easy

   A data analyst receives a file named 'sales_data.csv' from a colleague. The file contains sales transactions with columns for transaction ID (integer), date (string), and amount (decimal). The analyst needs to load this data into a Python script for processing. What is the most important characteristic of this file that the analyst should be aware of?

   • AIt is a binary file that requires special software to read.
   • BIt is a plain-text file where each line represents a record and fields are separated by commas.
   • CIt is a JSON file with a .csv extension.
   • DIt is a hierarchical file with nested records.
   Reveal Solution Discussion Select an answer first
6. 25application · medium

   An HR system stores employee records where each employee reports to exactly one manager, and every manager is also an employee who reports to a higher-level manager, up to the CEO. The organization frequently needs to answer questions like 'list all employees who report directly or indirectly to a given manager.' Which data structure most naturally represents this reporting relationship?

   • AA flat file with one line per employee including the manager's name in a text field.
   • BA relational table with a self-referencing foreign key where each employee row stores their manager's employee ID.
   • CA network structure where each employee is a node connected to all other employees they interact with.
   • DA hierarchical structure with the CEO as the root and each employee as a child of their manager.
   Reveal Solution Discussion Select an answer first