Free Certified Data Analyst Associate Exam braindumps download (Certified Data Analyst Associate exam dumps Free)

QUESTION: 9

A data analyst wants to create a dashboard with three main sections: Development, Testing, and Production. The data analyst wants all three sections on the same dashboard, but wants to clearly designate the sections using text on the dashboard.

Which tool can the data analyst use to designate the Development, Testing, and Production sections using text?

Separate endpoints for each section
Separate queries for each section
Markdown-based text boxes
Direct text written into the dashboard in editing mode

Answer(s): C

Show Answer Next Question

QUESTION: 10

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 Databricks Lakehouse Platform service/capability meets all of these requirements?

Tableau
Delta Lake
Databricks Notebooks
Databricks SQL

Answer(s): D

Show Answer Next Question

QUESTION: 11

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.

What describes why the data files still exist and the metadata files were deleted?

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

Answer(s): C

Show Answer Next Question

QUESTION: 12

After running DESCRIBE EXTENDED accounts.customers;, the following was returned:

Now, a data analyst runs the following command:

DROP accounts.customers;

Which describes the result of running this command?

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

Answer(s): C

Show Answer Next Question

QUESTION: 13

What should data analysts consider when working with personally identifiable information (PII) data?

The legal requirements for the area in which the data was collected
The organization-specific best practices for PII data
All of these considerations
The legal requirements for the area in which the analysis is being performed

Answer(s): C

Show Answer Next Question

QUESTION: 14

Delta Lake stores table data as a series of data files, but it also stores a lot of other information.

What is stored alongside data files when using Delta Lake?