Certified Data Analyst Associate practice test

1. Question 1 · 1

   Which of the following layers of the medallion architecture is most commonly used by data analysts?

   Choose one answer.

   • None of these layers are used by data analysts
   • Gold
   • All of these layers are used equally by data analysts
   • Silver
   • Bronze

2. Question 2 · 1

   A data analyst needs to use the Databricks Lakehouse Platform to quickly create SQL queries and data visualizations. It is a requirement that the compute resources in the platform can be made serverless, and it is expected that data visualizations can be placed within a dashboard. Which of the following Databricks Lakehouse Platform services/capabilities meets all of these requirements?

   Choose one answer.

   • Delta Lake
   • Databricks Notebooks
   • Tableau
   • Databricks Machine Learning
   • Databricks SQL

3. Question 3 · 1

   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?

   Choose one answer.

   • The table's data was larger than 10 GB
   • The table did not have a location
   • The table was external
   • The table's data was smaller than 10 GB
   • The table was managed

4. Question 4 · 1

   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?

   Choose one answer.

   

   • Running SELECT * FROM delta. `dbfs:/stakeholders/customers` results in an error.
   • Running SELECT * FROM accounts.customers will return all rows in the table.
   • All files with the .customers extension are deleted.
   • The accounts.customers table is removed from the metastore, and the underlying data files are deleted.
   • The accounts.customers table is removed from the metastore, but the underlying data files are untouched.

5. Question 5 · 1

   Which of the following should data analysts consider when working with personally identifiable information (PII) data?

   Choose one answer.

   • Organization-specific best practices for PII data
   • Legal requirements for the area in which the data was collected
   • None of these considerations
   • Legal requirements for the area in which the analysis is being performed
   • All of these considerations

6. Question 6 · 1

   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?

   Choose one answer.

   • None of these
   • Table metadata, data summary visualizations, and owner account information
   • Table metadata
   • Data summary visualizations
   • Owner account information

7. Question 7 · 1

   Which of the following is an advantage of using a Delta Lake-based data lakehouse over common data lake solutions?

   Choose one answer.

   • ACID transactions
   • Flexible schemas
   • Data deletion
   • Scalable storage
   • Open-source formats

8. Question 8 · 1

   Which of the following benefits of using Databricks SQL is provided by Data Explorer?

   Choose one answer.

   • It can be used to run UPDATE queries to update any tables in a database.
   • It can be used to view metadata and data, as well as view/change permissions.
   • It can be used to produce dashboards that allow data exploration.
   • It can be used to make visualizations that can be shared with stakeholders.
   • It can be used to connect to third party BI cools.

9. Question 9 · 1

   The stakeholders.customers table has 15 columns and 3,000 rows of data. The following command is run: After running SELECT * FROM stakeholders.eur_customers, 15 rows are returned. After the command executes completely, the user logs out of Databricks. After logging back in two days later, what is the status of the stakeholders.eur_customers view?

   Choose one answer.

   

   • The view remains available and SELECT * FROM stakeholders.eur_customers will execute correctly.
   • The view has been dropped.
   • The view is not available in the metastore, but the underlying data can be accessed with SELECT * FROM delta. `stakeholders.eur_customers`.
   • The view remains available but attempting to SELECT from it results in an empty result set because data in views are automatically deleted after logging out.
   • The view has been converted into a table.

10. Question 10 · 1

    A data analyst created and is the owner of the managed table my_ table. They now want to change ownership of the table to a single other user using Data Explorer. Which of the following approaches can the analyst use to complete the task?

    Choose one answer.

    • Edit the Owner field in the table page by removing their own account
    • Edit the Owner field in the table page by selecting All Users
    • Edit the Owner field in the table page by selecting the new owner's account
    • Edit the Owner field in the table page by selecting the Admins group
    • Edit the Owner field in the table page by removing all access

11. Question 11 · 1

    A data analyst has a managed table table_name in database database_name. They would now like to remove the table from the database and all of the data files associated with the table. The rest of the tables in the database must continue to exist. Which of the following commands can the analyst use to complete the task without producing an error?

    Choose one answer.

    • DROP DATABASE database_name;
    • DROP TABLE database_name.table_name;
    • DELETE TABLE database_name.table_name;
    • DELETE TABLE table_name FROM database_name;
    • DROP TABLE table_name FROM database_name;

12. Question 12 · 1

    A data analyst has recently joined a new team that uses Databricks SQL, but the analyst has never used Databricks before. The analyst wants to know where in Databricks SQL they can write and execute SQL queries. On which of the following pages can the analyst write and execute SQL queries?

    Choose one answer.

    • Data page
    • Dashboards page
    • Queries page
    • Alerts page
    • SQL Editor page

13. Question 13 · 1

    A data analyst runs the following command: INSERT INTO stakeholders.suppliers TABLE stakeholders.new_suppliers; What is the result of running this command?

    Choose one answer.

    • The suppliers table now contains both the data it had before the command was run and the data from the new_suppliers table, and any duplicate data is deleted.
    • The command fails because it is written incorrectly.
    • The suppliers table now contains both the data it had before the command was run and the data from the new_suppliers table, including any duplicate data.
    • The suppliers table now contains the data from the new_suppliers table, and the new_suppliers table now contains the data from the suppliers table.
    • The suppliers table now contains only the data from the new_suppliers table.

14. Question 14 · 1

    In which of the following situations should a data analyst use higher-order functions?

    Choose one answer.

    • When custom logic needs to be applied to simple, unnested data
    • When custom logic needs to be converted to Python-native code
    • When custom logic needs to be applied at scale to array data objects
    • When built-in functions are taking too long to perform tasks
    • When built-in functions need to run through the Catalyst Optimizer

15. Question 15 · 1

    Consider the following two statements: Statement 1: Statement 2: Which of the following describes how the result sets will differ for each statement when they are run in Databricks SQL?

    Choose one answer.

    

    

    • The first statement will return all data from the customers table and matching data from the orders table. The second statement will return all data from the orders table and matching data from the customers table. Any missing data will be filled in with NULL.
    • When the first statement is run, only rows from the customers table that have at least one match with the orders table on customer_id will be returned. When the second statement is run, only those rows in the customers table that do not have at least one match with the orders table on customer_id will be returned.
    • There is no difference between the result sets for both statements.
    • Both statements will fail because Databricks SQL does not support those join types.
    • When the first statement is run, all rows from the customers table will be returned and only the customer_id from the orders table will be returned. When the second statement is run, only those rows in the customers table that do not have at least one match with the orders table on customer_id will be returned.

Paid access to all 44 questions

Each purchase applies to this certification. Prices are one-time payments, not monthly subscriptions.