Use Data Acquisition Methods DA0-001 Practice Questions (Page 4)

Questions 16–20

1. 16foundation · easy

   What is the primary purpose of using an API to acquire data from an external system?

   • ATo transform data from one format to another
   • BTo provide a user interface for manual data entry
   • CTo allow automated retrieval of data in a structured format
   • DTo store data in a data warehouse
   Reveal Solution Discussion Select an answer first
2. 17application · easy

   A data scientist needs to pull real-time weather data from a public API to enrich a dataset of delivery locations. The API returns data in JSON format. The data scientist's code is in Python. What is the most appropriate way to acquire this data?

   • AManually copy the weather data from the API's website
   • BDownload a static CSV file from the API provider's website
   • CUse the `requests` library in Python to call the API and parse the JSON response
   • DUse a web scraper to extract data from the API's documentation page
   Reveal Solution Discussion Select an answer first
4. 18foundation · easy

   A data analyst needs to retrieve only the first 10 rows from a table named 'sales' ordered by the 'sale_date' column. Which SQL query accomplishes this?

   • ASELECT * FROM sales ORDER BY sale_date LIMIT 10;
   • BSELECT * FROM sales LIMIT 10;
   • CSELECT * FROM sales WHERE ROWNUM <= 10 ORDER BY sale_date;
   • DSELECT TOP 10 * FROM sales ORDER BY sale_date;
   Reveal Solution Discussion Select an answer first
5. 19foundation · easy

   A data analyst needs to combine customer records from a CRM system and a billing system into a single dataset for reporting. Which data integration technique is most appropriate for this task?

   • AData profiling
   • BData replication
   • CData integration
   • DData blending
   Reveal Solution Discussion Select an answer first
6. 20expert · hard

   A database administrator needs to identify customers who have placed orders in the last 30 days but have not placed any orders in the last 7 days. The `orders` table has `customer_id`, `order_date`, and `order_amount`. The query must be efficient on a large table. Which SQL query is most appropriate?

   • ASELECT DISTINCT customer_id FROM orders WHERE order_date >= CURRENT_DATE - 30 AND customer_id NOT IN (SELECT customer_id FROM orders WHERE order_date >= CURRENT_DATE - 7);
   • BSELECT customer_id FROM orders WHERE order_date < CURRENT_DATE - 30;
   • CSELECT customer_id FROM orders WHERE order_date > CURRENT_DATE - 7;
   • DSELECT customer_id FROM orders WHERE order_date BETWEEN CURRENT_DATE - 30 AND CURRENT_DATE - 7;
   Reveal Solution Discussion Select an answer first