Study with Databricks : Databricks-Certified-Data-Analyst-Associate Exam Torrent as your best preparation materials

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 counters to the dashboard?

• A. A SQL warehouse (formerly known as SQL endpoint) must be turned on and selected.
• B. A markdown-based tile must be added to the top of the dashboard displaying the dashboard ' s name.
• C. The dashboard owner must also be the owner of the queries, data visualizations, and counters.
• D. All data visualizations and counters must be created using Queries.

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?

• A. The table ' s data was smaller than 10 GB
• B. The table was managed
• C. The table ' s data was larger than 10 GB
• D. The table did not have a location
• E. The table was external

A data analyst has been asked to configure an alert for a query that returns the income in the accounts_receivable table for a date range. The date range is configurable using a Date query parameter.
The Alert does not work.
Which of the following describes why the Alert does not work?

• A. Queries that return results based on dates cannot be used with Alerts.
• B. The wrong query parameter is being used. Alerts only work with Date and Time query parameters.
• C. The wrong query parameter is being used. Alerts only work with drogdown list query parameters, not dates.
• D. Alerts don ' t work with queries that access tables.
• E. Queries that use query parameters cannot be used with Alerts.

Which of the following Structured Streaming queries is performing a hop from a Silver table to a Gold table?

• A. Option B
• B. Option E
• C. Option D
• D. ( spark.table( " sales " ) .withColumn( " avgPrice " , col( " sales " ) / col( " units " )) .writeStream .option ( " checkpointLocation " , checkpointPath) .outputMode( " append " ) .table( " newSales " ))
• E. ( spark.readStream.load(rawSalesLocation) .writeStream .option( " checkpointLocation " , checkpointPath) .outputMode( " append " ) .table( " newSales " ))
• F. Option A
• G. ( spark.table( " sales " ) .withColumn( " avgPrice " , col( " sales " ) / col( " units " )) .writeStream .option ( " checkpointLocation " , checkpointPath) .outputMode( " append " ) .table( " newSales " ))
• H. ( spark.table( " sales " ) .groupBy( " store " ) .agg(sum( " sales " )) .writeStream .option( " checkpointLocation " , checkpointPath) .outputMode( " complete " ) .table( " newSales " ))
• I. Option C
• J. ( spark.table( " sales " ) .filter(col( " units " ) > 0) .writeStream .option( " checkpointLocation " , checkpointPath) .outputMode( " append " ) .table( " newSales " ))

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 should the data analyst proceed?

• A. Stop working with the data and delete the table and any existing metadata or data files.
• B. Drop the column containing PII data and continue with the project without notifying anybody.
• C. Stop working with the data and notify their supervisor to ensure the data is handled following organizational and legal best practices.
• D. Stop working with the data and proceed with the project using other data.