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

A. Heatmap B. Word Cloud C. Sankey D. IChoropleth E. Pivot Table

A. The area chart will use whatever value is chosen on the dashboard at the time the area chart is added to the dashboard. B. The area chart will use whatever is selected in the Dashboard Parameter along with all of the other visualizations in the dashboard that use the same parameter. C. The area chart will use whatever is selected in the Dashboard Parameter while all or the other visualizations will remain changed regardless of their parameter use. D. The area chart will use whatever value is input by the analyst when the visualization is added to the dashboard. The parameter cannot be changed by the user afterwards. E. The area chart will convert to a Dashboard Parameter.

A. A branch of statistics that uses quantitative variables that must take on a finite or countably infinite set of values. B. A branch of statistics that uses summary statistics to categorically describe and summarize data. C. A branch of statistics that uses a variety of data analysis techniques to infer properties of an underlying distribution of probability. D. A branch of statistics that uses summary statistics to quantitatively describe and summarize data. E. A branch of statistics that uses quantitative variables that must take on an uncountable set of values.

A. The data in the managed table were deleted, and the data in the unmanaged external table were left untouched. B. The data in both tables were deleted. C. The data in the unmanaged external table were deleted, and the data in the managed table were left untouched. D. The data in both tables were left untouched.

A. dbfs:/accounting/data.db B. dbfs:/accounting/data C. dbfs:/user/hive/warehouse/accounting.db D. dbfs:/accounting/data/accounting.db

A. Generic optimizations B. Open-source formats C. ACID transactions D. Schema enforcement

A. Data Intelligence Engine B. Databricks Assistant C. Genie Spaces D. Unity Catalog

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

A. Databricks web application B. Notebooks C. Repos D. Data E. Cluster management metadata