Databricks Certified Data Analyst Associate practice questions

1. Question 1 of 25

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

   • ANone of these layers are used by data analysts
   • BGold
   • CAll of these layers are used equally by data analysts
   • DSilver
   • EBronze

   Show answer

   Correct answer: B

   How others answered

   • B100%

2. Question 2 of 25

   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?

   • AData page
   • BDashboards page
   • CQueries page
   • DAlerts page
   • ESQL Editor page

   Show answer

   Correct answer: E

   How others answered

   • E91%
   • C9%

3. Question 3 of 25

   Which of the following describes how Databricks SQL should be used in relation to other business intelligence (BI) tools like Tableau, Power BI, and looker?

   • AAs an exact substitute with the same level of functionality
   • BAs a substitute with less functionality
   • CAs a complete replacement with additional functionality
   • DAs a complementary tool for professional-grade presentations
   • EAs a complementary tool for quick in-platform BI work

   Show answer

   Correct answer: E

   How others answered

   • E100%

4. Question 4 of 25

   Which of the following approaches can be used to connect Databricks to Fivetran for data ingestion?

   • AUse Workflows to establish a SQL warehouse (formerly known as a SQL endpoint) for Fivetran to interact with
   • BUse Delta Live Tables to establish a cluster for Fivetran to interact with
   • CUse Partner Connect's automated workflow to establish a cluster for Fivetran to interact with
   • DUse Partner Connect's automated workflow to establish a SQL warehouse (formerly known as a SQL endpoint) for Fivetran to interact with
   • EUse Workflows to establish a cluster for Fivetran to interact with

   Show answer

   Correct answer: D

   How others answered

   • D100%

5. Question 5 of 25

   Data professionals with varying titles use the Databricks SQL service as the primary touchpoint with the Databricks Lakehouse Platform. However, some users will use other services like Databricks Machine Learning or Databricks Data Science and Engineering. Which of the following roles uses Databricks SQL as a secondary service while primarily using one of the other services?

   • ABusiness analyst
   • BSQL analyst
   • CData engineer
   • DBusiness intelligence analyst
   • EData analyst

   Show answer

   Correct answer: C

   How others answered

   • C100%

6. Question 6 of 25

   A data analyst has set up a SQL query to run every four hours on a SQL endpoint, but the SQL endpoint is taking too long to start up with each run. Which of the following changes can the data analyst make to reduce the start-up time for the endpoint while managing costs?

   • AReduce the SQL endpoint cluster size
   • BIncrease the SQL endpoint cluster size
   • CTurn off the Auto stop feature
   • DIncrease the minimum scaling value
   • EUse a Serverless SQL endpoint

   Show answer

   Correct answer: E

   How others answered

   • E100%

7. Question 7 of 25

   A data engineering team has created a Structured Streaming pipeline that processes data in micro-batches and populates gold-level tables. The microbatches are triggered every minute. A data analyst has created a dashboard based on this gold-level data. The project stakeholders want to see the results in the dashboard updated within one minute or less of new data becoming available within the gold-level tables. Which of the following cautions should the data analyst share prior to setting up the dashboard to complete this task?

   • AThe required compute resources could be costly
   • BThe gold-level tables are not appropriately clean for business reporting
   • CThe streaming data is not an appropriate data source for a dashboard
   • DThe streaming cluster is not fault tolerant
   • EThe dashboard cannot be refreshed that quickly

   Show answer

   Correct answer: A

   How others answered

   • A100%

8. Question 8 of 25

   Which of the following approaches can be used to ingest data directly from cloud-based object storage?

   • ACreate an external table while specifying the DBFS storage path to FROM
   • BCreate an external table while specifying the DBFS storage path to PATH
   • CIt is not possible to directly ingest data from cloud-based object storage
   • DCreate an external table while specifying the object storage path to FROM
   • ECreate an external table while specifying the object storage path to LOCATION

   Show answer

   Correct answer: E

   How others answered

   • E100%

9. Question 9 of 25

   A data analyst wants to create a dashboard with three main sections: Development, Testing, and Production. They want all three sections on the same dashboard, but they want to clearly designate the sections using text on the dashboard. Which of the following tools can the data analyst use to designate the Development, Testing, and Production sections using text?

   • ASeparate endpoints for each section
   • BSeparate queries for each section
   • CMarkdown-based text boxes
   • DDirect text written into the dashboard in editing mode
   • ESeparate color palettes for each section

   Show answer

   Correct answer: C

   How others answered

   • C71%
   • D29%

   Only 71% agreed on this answer — treat it as contested rather than settled.

10. Question 10 of 25

    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?

    • ADelta Lake
    • BDatabricks Notebooks
    • CTableau
    • DDatabricks Machine Learning
    • EDatabricks SQL

    Show answer

    Correct answer: E

    How others answered

    • E100%

11. Question 11 of 25

    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?

    • AThe table's data was larger than 10 GB
    • BThe table did not have a location
    • CThe table was external
    • DThe table's data was smaller than 10 GB
    • EThe table was managed

    Show answer

    Correct answer: C

    How others answered

    • C100%

12. Question 12 of 25

    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?

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

    Show answer

    Correct answer: E

    How others answered

    • E100%

13. Question 13 of 25

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

    • AOrganization-specific best practices for PII data
    • BLegal requirements for the area in which the data was collected
    • CNone of these considerations
    • DLegal requirements for the area in which the analysis is being performed
    • EAll of these considerations

    Show answer

    Correct answer: E

    How others answered

    • E100%

14. Question 14 of 25

    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?

    • ANone of these
    • BTable metadata, data summary visualizations, and owner account information
    • CTable metadata
    • DData summary visualizations
    • EOwner account information

    Show answer

    Correct answer: C

    How others answered

    • C100%

15. Question 15 of 25

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

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

    Show answer

    Correct answer: B

    How others answered

    • B100%

16. Question 16 of 25

    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?

    • AThe view remains available and SELECT * FROM stakeholders.eur_customers will execute correctly.
    • BThe view has been dropped.
    • CThe view is not available in the metastore, but the underlying data can be accessed with SELECT * FROM delta. `stakeholders.eur_customers`.
    • DThe 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.
    • EThe view has been converted into a table.

    Show answer

    Correct answer: B

    How others answered

    • B78%
    • A22%

17. Question 17 of 25

    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?

    • AEdit the Owner field in the table page by removing their own account
    • BEdit the Owner field in the table page by selecting All Users
    • CEdit the Owner field in the table page by selecting the new owner's account
    • DEdit the Owner field in the table page by selecting the Admins group
    • EEdit the Owner field in the table page by removing all access

    Show answer

    Correct answer: C

    How others answered

    • C100%

18. Question 18 of 25

    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?

    • ADROP DATABASE database_name;
    • BDROP TABLE database_name.table_name;
    • CDELETE TABLE database_name.table_name;
    • DDELETE TABLE table_name FROM database_name;
    • EDROP TABLE table_name FROM database_name;

    Show answer

    Correct answer: B

    How others answered

    • B100%

19. Question 19 of 25

    A data analyst runs the following command: SELECT age, country - FROM my_table - WHERE age >= 75 AND country = 'canada'; Which of the following tables represents the output of the above command?

    • A//IMG//
    • B//IMG//
    • C//IMG//
    • D//IMG//
    • E//IMG//

    Show answer

    Correct answer: E

    How others answered

    • E100%

20. Question 20 of 25

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

    • AThe 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.
    • BThe command fails because it is written incorrectly.
    • CThe 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.
    • DThe suppliers table now contains the data from the new_suppliers table, and the new_suppliers table now contains the data from the suppliers table.
    • EThe suppliers table now contains only the data from the new_suppliers table.

    Show answer

    Correct answer: C

    How others answered

    • C100%

21. Question 21 of 25

    A business analyst has been asked to create a data entity/object called sales_by_employee. It should always stay up-to-date when new data are added to the sales table. The new entity should have the columns sales_person, which will be the name of the employee from the employees table, and sales, which will be all sales for that particular sales person. Both the sales table and the employees table have an employee_id column that is used to identify the sales person. Which of the following code blocks will accomplish this task?

    • A//IMG//
    • B//IMG//
    • C//IMG//
    • D//IMG//
    • E//IMG//

    Show answer

    Correct answer: D

    How others answered

    • D75%
    • B13%
    • E13%

22. Question 22 of 25

    A data analyst has been asked to use the below table sales_table to get the percentage rank of products within region by the sales:

    

    The result of the query should look like this:

    

    Which of the following queries will accomplish this task?

    • A//IMG//
    • B//IMG//
    • C//IMG//
    • D//IMG//
    • E//IMG//

    Show answer

    Correct answer: B

    How others answered

    • B100%

23. Question 23 of 25

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

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

    Show answer

    Correct answer: C

    How others answered

    • C100%

24. Question 24 of 25

    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?

    • AThe 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.
    • BWhen 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.
    • CThere is no difference between the result sets for both statements.
    • DBoth statements will fail because Databricks SQL does not support those join types.
    • EWhen 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.

    Show answer

    Correct answer: B

    How others answered

    • B100%

25. Question 25 of 25

    A data analyst has created a user-defined function using the following line of code: CREATE FUNCTION price(spend DOUBLE, units DOUBLE) RETURNS DOUBLE - RETURN spend / units; Which of the following code blocks can be used to apply this function to the customer_spend and customer_units columns of the table customer_summary to create column customer_price?

    • ASELECT PRICE customer_spend, customer_units AS customer_price FROM customer_summary
    • BSELECT price - FROM customer_summary
    • CSELECT function(price(customer_spend, customer_units)) AS customer_price FROM customer_summary
    • DSELECT double(price(customer_spend, customer_units)) AS customer_price FROM customer_summary
    • ESELECT price(customer_spend, customer_units) AS customer_price FROM customer_summary

    Show answer

    Correct answer: E

    How others answered

    • E100%

Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page

DA-ASSOC practice, question 1 of 25