Free Databricks Certified Data Analyst Associate Exam Databricks-Certified-Data-Analyst-Associate Exam Practice Test

A data organization has a team of engineers developing data pipelines following the medallion architecture using Delta Live Tables. While the data analysis team working on a project is using gold - layer tables from these pipelines, they need to perform some additional processing of these tables prior to performing their analysis.Which of the following terms is used to describe this type of work?

• Data blending
• Last-mile
• Data testing
• Last-mile ETL
• Data enhancement

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?

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

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?

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

A data analyst has created a Query in Databricks SQL, and now they want to create two data visualizations from that Query and add both of those data visualizations to the same Databricks SQL Dashboard.Which of the following steps will they need to take when creating and adding both data visualizations to the Databricks SQL Dashboard?

• They will need to alter the Query to return two separate sets of results.
• They will need to add two separate visualizations to the dashboard based on the same Query.
• They will need to create two separate dashboards.
• They will need to decide on a single data visualization to add to the dashboard.
• They will need to copy the Query and create one data visualization per query.

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?

• 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;

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

• Organization-specific best practices for Pll 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

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

• Create an external table while specifying the DBFS storage path to FROM
• Create an external table while specifying the DBFS storage path to PATH
• It is not possible to directly ingest data from cloud-based object storage
• Create an external table while specifying the object storage path to FROM
• Create an external table while specifying the object storage path to LOCATION

A data analyst has been asked to produce a visualization that shows the flow of users through a website.Which of the following is used for visualizing this type of flow?

• Heatmap
• IChoropleth
• Word Cloud
• Pivot Table
• Sankey

A data analyst creates a Databricks SQL Query where the result set has the following schema: region STRINGnumber_of_customer INTWhen 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?

• Violin Chart
• Line Chart
• IBar Chart
• Histogram
• There is no default. The user must choose a visualization type.

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?

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