CERTIFIED-DATA-ANALYST-ASSOCIATE Practice Questions

A stakeholder has provided a data analyst with a lookup dataset in the form of a 50-row CSV file. The data analyst needs to upload this dataset for use as a table in Databricks SQL...

Data professionals with varying responsibilities use the Databricks Lakehouse Platform. Which role in the Databricks Lakehouse Platform use Databricks SQL as their primary service?

What describes the variance of a set of values?

What is a benefit of using Databricks SQL for business intelligence (Bl) analytics projects instead of using third-party Bl tools?

Where in the Databricks SQL workspace can a data analyst configure a refresh schedule for a query when the query is not attached to a dashboard or alert?

A data analyst needs to share a Databricks SQL dashboard with stakeholders that are not permitted to have accounts in the Databricks deployment. The stakeholders need to be notifie...

A data scientist has asked a data analyst to create histograms for every continuous variable in a data set. The data analyst needs to identify which columns are continuous in the d...

Which location can be used to determine the owner of a managed table?

A data analyst wants to create a Databricks SQL dashboard with multiple data visualizations and multiple counters. What must be completed before adding the data visualizations and...

In which circumstance will there be a substantial difference between the variable's mean and median values?

Which statement describes descriptive statistics?

A data analyst wants the following output: customer_name number_of_orders John Doe 388 Zhang San 234 Which statement will produce this output?

What is used as a compute resource for Databricks SQL?

A data analyst has created a Query in Databricks SQL, and now wants to create two data visualizations from that Query and add both of those data visualizations to the same Databric...

Query History provides Databricks SQL users with a lot of benefits. A data analyst has been asked to share all of these benefits with their team as part of a training exercise. One...

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

How should Databricks SQL be used in relation to other business intelligence (BI) tools like Tableau, Power BI, and Looker?

Which approach should be used to connect Databricks to Fivetran for data ingestion?

A data analyst needs to query the data in my_table. They want to return the values in columns user_id and email_address where records fit the following filter criteria: age is grea...

Which example of data projects represents a common analytics application to be completed in Databricks SQL?

What is an advantage of using a Delta Lake-based data lakehouse over classic enterprise data warehouse solutions?

A data analyst has been asked to use the below table sales_table to rank products within region by the sales: The result of the query should look like this: Which query will accomp...

A database was created in Databricks SQL using the following statement: CREATE SCHEMA accounting LOCATION 'dbfs:/accounting/data'; Where will data for this database be stored?

A managed table and an unmanaged (external) table were both created in Databricks SQL, and data were ingested into each table. Later, both tables were dropped. What is the status o...

Which statement about visualizations is true?

Which SQL standards does Databricks SQL use as its default SQL dialect?

A data analyst is working in an organization that utilizes a multi-hop, medallion architecture. They have been tasked with creating a new Gold table from an existing Silver table....

A data analyst has opened up the SQL Editor page and written a new SQL statement. The data analyst now wants to save that statement to easily refer back to it later to add it to a...

An analyst has been asked to combine the data in two tables: suppliers and new_suppliers. It's possible that some of the supplier_id values match in both tables, meaning that those...

A data analyst is working with a nested array column products in table transactions. The analyst wants to return the first item in the array for each row. The data analyst is using...

A dashboard contains a bar chart visualization. The bar chart has a Date widget parameter associated with it. Which statement about the Date widget parameter is true?

In which scenario should a data analyst create and use a user-defined function (UDF)?

A data analyst has produced a visualization. A stakeholder has viewed the visualization and is complaining that the visualization is difficult to interpret. After looking at the vi...

Which example of data projects represents a common analytics application to be completed in Databricks SQL?

A data analyst has two data sources that are providing similar but complementary information. The analyst wants to combine these sources of data into a single, comprehensive datase...

A data analyst has been asked to determine which customers have placed an order in the past year and which customers have not placed an order in the past year. This can be determin...

A data analyst has come across a column in a table that contains personally identifiable information (PII). The data analyst should not have access to this type of PII data. How sh...

Which open-source project helps to enable the data lakehouse by adding organization, reliability, performance, and data governance to data lake architectures?

Which data visualization use cases is best completed using Databricks SQL relative to other visualization tools?

A data analyst has written and saved a series of queries that reveal trends that need to be monitored by several stakeholders. Which tool should the data analyst use to share the r...

A data analyst needs to create an empty managed table table_name in database database_name with a specific schema. The table needs to be recreated and empty, regardless of whether...

A data analyst is working with the following table my_table: customer_name dollars_spent Hex Sprockets [125.34, 100.15, 9003.99] Dented Fenders [16.99, 200.85, 33.49, 88.17] The an...

Where can an admin or Data owner grant database, table, and view permissions to a group?

A data architect has informed a data analyst team that its organization will now use a data design pattern that will logically organize data in a lakehouse, with the goal of increm...