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

Questions 31–32

1. 31expert · medium

   A data analyst is merging two CSV files containing customer data. File A has a 'customer_id' column stored as integers. File B has a 'customer_id' column stored as strings, with some values like '00123' and '123'. The analyst needs to join these files on customer_id. What is the most important issue to address before merging?

   • AConvert both files to JSON before merging.
   • BRemove all rows with missing customer_id values.
   • CStandardize the customer_id data type and format across both files.
   • DSort both files by customer_id before merging.
   Reveal Solution Discussion Select an answer first
2. 32expert · medium

   A logistics company needs to model delivery routes. Each delivery location is a node, and roads between locations are edges. The company wants to find the shortest path between two locations, but also needs to account for road closures that change over time. The data team is considering a graph database versus a relational database. Which consideration is most important in this decision?

   • ARelational databases are the only option that supports ACID transactions.
   • BGraph databases are always faster than relational databases for all queries.
   • CRelational databases cannot store graph data at all.
   • DGraph databases are optimized for path traversal queries, which are central to this use case.
   Reveal Solution Discussion Select an answer first