Databricks Certified Data Analyst Associate - Certified Data Analyst Associate Exam
Page: 3 / 28
Total 140 questions
Question #11 (Topic: Exam A)
A data analyst is attempting to drop a table my_table. The analyst wants to delete all table metadata and data.
They run the following command:
DROP TABLE IF EXISTS my_table;
While the object no longer appears when they run SHOW TABLES, the data files still exist.
Which of the following describes why the data files still exist and the metadata files were deleted?
They run the following command:
DROP TABLE IF EXISTS my_table;
While the object no longer appears when they run SHOW TABLES, the data files still exist.
Which of the following describes why the data files still exist and the metadata files were deleted?
A. The table's data was larger than 10 GB
B. The table did not have a location
C. The table was external
D. The table's data was smaller than 10 GB
E. The table was managed
Answer: C
Question #12 (Topic: Exam A)
After running DESCRIBE EXTENDED accounts.customers;, the following was returned:
Now, a data analyst runs the following command:
DROP accounts.customers;
Which of the following describes the result of running this command?
Now, a data analyst runs the following command:
DROP accounts.customers;
Which of the following describes the result of running this command?
A. Running SELECT * FROM delta. `dbfs:/stakeholders/customers` results in an error.
B. Running SELECT * FROM accounts.customers will return all rows in the table.
C. All files with the .customers extension are deleted.
D. The accounts.customers table is removed from the metastore, and the underlying data files are deleted.
E. The accounts.customers table is removed from the metastore, but the underlying data files are untouched.
Answer: E
Question #13 (Topic: Exam A)
Which of the following should data analysts consider when working with personally identifiable information (PII) data?
A. Organization-specific best practices for PII data
B. Legal requirements for the area in which the data was collected
C. None of these considerations
D. Legal requirements for the area in which the analysis is being performed
E. All of these considerations
Answer: E
Question #14 (Topic: Exam A)
Delta Lake stores table data as a series of data files, but it also stores a lot of other information.
Which of the following is stored alongside data files when using Delta Lake?
Which of the following is stored alongside data files when using Delta Lake?
A. None of these
B. Table metadata, data summary visualizations, and owner account information
C. Table metadata
D. Data summary visualizations
E. Owner account information
Answer: C
Question #15 (Topic: Exam A)
Which of the following is an advantage of using a Delta Lake-based data lakehouse over common data lake solutions?
A. ACID transactions
B. Flexible schemas
C. Data deletion
D. Scalable storage
E. Open-source formats
Answer: A
