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

Questions 11–15

1. 11application · medium

   A startup is building a real-time recommendation engine. The data consists of user interactions (clicks, views, purchases) that arrive at high velocity and have varying attributes. The team needs to store this data for quick retrieval by user ID and timestamp, and they do not require complex joins or transactions. Which type of database is most appropriate?

   • AA relational database with normalized tables for users, interactions, and products.
   • BA hierarchical database with users as parents and interactions as children.
   • CA graph database to model relationships between users and products.
   • DA key-value NoSQL database with user ID and timestamp as the key.
   Reveal Solution Discussion Select an answer first
2. 12foundation · easy

   Which of the following is a primary advantage of using JSON for data interchange?

   • AIt is easy for both humans to read and machines to parse
   • BIt is specifically designed for storing large multimedia files
   • CIt is a highly compressed binary format that saves storage space
   • DIt enforces a strict schema that must be defined before data is written
   Reveal Solution Discussion Select an answer first
4. 13application · medium

   A marketing team maintains a customer database in a relational system. Each customer record includes a unique customer ID, first name, last name, email address, and a boolean field indicating whether the customer has opted into promotional emails. The team needs to export only customers who have opted in, along with their full names and email addresses, for an upcoming campaign. The recipient system expects a plain-text file with one record per line and fields separated by commas. Which approach should the data analyst take?

   • AExport the entire customer table as a CSV file and let the recipient system filter out non-opted customers.
   • BRun a SQL query filtering on the opt-in field, then export the result set as a CSV file.
   • CCreate a JSON file containing all customer fields and send it to the recipient.
   • DUse a flat file with pipe delimiters instead of commas to avoid conflicts with email addresses.
   Reveal Solution Discussion Select an answer first
5. 14foundation · easy

   How does a network data structure represent data compared to a hierarchical structure?

   • AIt allows each node to have multiple parents and children, forming a graph
   • BIt organizes data into documents with nested fields
   • CIt stores all data in a single table without any links
   • DIt uses a strict tree format where each node has only one parent
   Reveal Solution Discussion Select an answer first
6. 15application · easy

   A file system organizes folders and files. Each folder can contain multiple files and subfolders, but each file or subfolder belongs to exactly one parent folder. The system needs to support queries like 'list all files under a given folder, including files in subfolders.' Which data structure best represents this organization?

   • AA hierarchical tree structure with the root directory as the root node.
   • BA network graph where each file is connected to every folder it could potentially be moved to.
   • CA relational database with a single table storing all files and folders.
   • DA flat file listing all files with their full paths.
   Reveal Solution Discussion Select an answer first