Databricks DATABRICKS-CERTIFIED-DATA-ANALYST-ASSOCIATE Online Practice Questions and Exam Preparation

Databricks DATABRICKS-CERTIFIED-DATA-ANALYST-ASSOCIATE Online Questions & Answers

• Question 11:

  In which of the following situations will the mean value and median value of variable be meaningfully different?

  A. When the variable contains no outliers
  B. When the variable contains no missing values
  C. When the variable is of the boolean type
  D. When the variable is of the categorical type
  E. When the variable contains a lot of extreme outliers
  E. When the variable contains a lot of extreme outliers

  ---

  Explanation/Reference:

• Question 12:

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

  A. None of these layers are used by data analysts
  B. Gold
  C. All of these layers are used equally by data analysts
  D. Silver
  E. Bronze
  B. Gold

  ---

  Explanation/Reference:

  Reference: https://www.databricks.com/glossary/medallion-architecture

• Question 13:

  A data team has been given a series of projects by a consultant that need to be implemented in the Databricks Lakehouse Platform.

  Which of the following projects should be completed in Databricks SQL?

  A. Testing the quality of data as it is imported from a source
  B. Tracking usage of feature variables for machine learning projects
  C. Combining two data sources into a single, comprehensive dataset
  D. Segmenting customers into like groups using a clustering algorithm
  E. Automating complex notebook-based workflows with multiple tasks
  C. Combining two data sources into a single, comprehensive dataset

  ---

  Explanation/Reference:

• Question 14:

  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?

  A. Edit the Owner field in the table page by removing their own account
  B. Edit the Owner field in the table page by selecting All Users
  C. Edit the Owner field in the table page by selecting the new owner's account
  D. Edit the Owner field in the table page by selecting the Admins group
  E. Edit the Owner field in the table page by removing all access
  C. Edit the Owner field in the table page by selecting the new owner's account

  ---

  Explanation/Reference:

• Question 15:

  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. Option A
  B. Option B
  C. Option C
  D. Option D
  E. Option E
  B. Option B

  ---

  Explanation/Reference:

• Question 16:

  A data analysis team is working with the table_bronze SQL table as a source for one of its most complex projects. A stakeholder of the project notices that some of the downstream data is duplicative. The analysis team identifies table_bronze as the source of the duplication.

  Which of the following queries can be used to deduplicate the data from table_bronze and write it to a new table table_silver?

  A. CREATE TABLE table_silver AS SELECT DISTINCT * FROM table_bronze;
  B. CREATE TABLE table_silver AS INSERT * FROM table_bronze;
  C. CREATE TABLE table_silver AS MERGE DEDUPLICATE * FROM table_bronze;
  D. INSERT INTO TABLE table_silver SELECT * FROM table_bronze;
  E. INSERT OVERWRITE TABLE table_silver SELECT * FROM table_bronze;
  A. CREATE TABLE table_silver AS SELECT DISTINCT * FROM table_bronze;

  ---

  Explanation/Reference:

• Question 17:

  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?

  A. Business analyst
  B. SQL analyst
  C. Data engineer
  D. Business intelligence analyst
  E. Data analyst
  C. Data engineer

  ---

  Explanation/Reference:

• Question 18:

  Which of the following statements about adding visual appeal to visualizations in the Visualization Editor is incorrect?

  A. Visualization scale can be changed.
  B. Data Labels can be formatted.
  C. Colors can be changed.
  D. Borders can be added.
  E. Tooltips can be formatted.
  D. Borders can be added.

  ---

  Explanation/Reference:

• Question 19:

  A data analyst has been asked to provide a list of options on how to share a dashboard with a client. It is a security requirement that the client does not gain access to any other information, resources, or artifacts in the database. Which of the following approaches cannot be used to share the dashboard and meet the security requirement?

  A. Download the Dashboard as a PDF and share it with the client.
  B. Set a refresh schedule for the dashboard and enter the client's email address in the "Subscribers" box.
  C. Take a screenshot of the dashboard and share it with the client.
  D. Generate a Personal Access Token that is good for 1 day and share it with the client.
  E. Download a PNG file of the visualizations in the dashboard and share them with the client.
  D. Generate a Personal Access Token that is good for 1 day and share it with the client.

  ---

  Explanation/Reference:

• Question 20:

  A data analyst creates a Databricks SQL Query where the result set has the following schema:

  region STRINGnumber_of_customer INT

  When the analyst clicks on the "Add visualization" button on the SQL Editor page, which of the following types of visualizations will be selected by default?

  A. Violin Chart
  B. Line Chart
  C. Bar Chart
  D. Histogram
  E. There is no default. The user must choose a visualization type.
  C. Bar Chart

  ---

  Explanation/Reference:

  Reference: https://docs.databricks.com/en/sql/user/visualizations/index.html