Create Managed Tables and External Tables, Including Creating Tables by Joining Data from Multiple Sources (e.g., CSV, Parquet, Delta Tables) to Create Unified Datasets, Including Unity Catalog. DATA-ANALYST-ASSOCIATE Practice Questions (Page 4)

Questions 16–18

1. 16foundation · easy

   Which SQL clause is used to read data from a CSV file in Databricks SQL?

   • ALOAD DATA FROM '/path/to/file.csv'
   • BSELECT * FROM csv.`/path/to/file.csv`
   • CREAD CSV
   • DOPEN '/path/to/file.csv'
   Reveal Solution Discussion Select an answer first
2. 17foundation · easy

   When you create a table using CREATE TABLE AS SELECT (CTAS), what is the default format of the new table?

   • ADelta
   • BJSON
   • CCSV
   • DParquet
   Reveal Solution Discussion Select an answer first
3. 18application · medium

   A data analyst needs to create a unified table that combines data from a CSV file and a Delta table. The CSV file has a header row and is located at `/mnt/data/events.csv`. The Delta table is named `users`. The analyst wants to join these sources on the `user_id` column. Which query should they use to read the CSV file?

   • ASELECT * FROM events
   • BSELECT * FROM delta.`/mnt/data/events.csv`
   • CSELECT * FROM csv.`/mnt/data/events.csv`
   • DSELECT * FROM parquet.`/mnt/data/events.csv`
   Reveal Solution Discussion Select an answer first