Which of the following describes the storage organization of a Delta table?

• A.Delta tables are stored in a collection of files that contain only the data stored within the table.
• B.Delta tables store their data in a single file and all metadata in a collection of files in a separate location.
• C.Delta tables are stored in a collection of files that contain data, history, metadata, and other attributes.
• D.Delta tables are stored in a single file that contains data, history, metadata, and other attributes.
• E.Delta tables are stored in a single file that contains only the data stored within the table.

Comment: *

Name: *

Email: *

Verification: *

Calculate the total sales amount for each region and store the results in a new dataframe called region_sales.
Given the expected result:

Which code will generate the expected result?

• A.region sales - sales_df.agg(sum("sales_amount").groupBy("region").alias("total sales amount"))
• B.region_sales = sales_df. sum ("salen_aiTiount") . groupBy ("region") .alias ("total_sale3_amount")
• C.region_sales= sales_df.groupBy("category").sum(nsales_amount").alias("t_otal_sales_amounl")
• D.region_sales = sales_df.groupBy("region").agg(sum("sales_amountM).alias("total_sales_amount"))

Comment: *

Name: *

Email: *

Verification: *

A data engineer team has decided to implement a new data platform on Databricks and is currently deciding how to store each kind of data on each data layer. What is the appropriate layer and data pairing for medallion architecture?

• A.Silver Layer - Raw data from deposit account application
• B.Bronze Layer - Summary of cash deposit amount for each country and city
• C.Silver Layer - Cleansed master customer data
• D.Gold Layer - Deduplicated money transfer transaction

Comment: *

Name: *

Email: *

Verification: *

A data engineer needs to provide access to a group named manufacturing-team. The team needs privileges to create tables in the quality schema. Which set of SQL commands will grant a group named manufacturing-team to create tables in a schema named production with the parent catalog named manufacturing with the least privileges?

• A.GRANT CREATE TABLE ON SCHEMA manufacturing.quality TO manufacturing-team; GRANT USE SCHEMA ON SCHEMA manufacturing.quality TO manufacturing-team; GRANT USE CATALOG ON CATALOG manufacturing TO manufacturing-team;
• B.GRANT USE TABLE ON SCHEMA manufacturing.quality TO manufacturing-team; GRANT USE SCHEMA ON SCHEMA manufacturing.quality TO manufacturing-team; GRANT USE CATALOG ON CATALOG manufacturing TO manufacturing-team;
• C.GRANT CREATE TABLE ON SCHEMA manufacturing.quality TO manufacturing-team; GRANT CREATE SCHEMA ON SCHEMA manufacturing.quality TO manufacturing-team; GRANT CREATE CATALOG ON CATALOG manufacturing TO manufacturing-team;
• D.GRANT CREATE TABLE ON SCHEMA manufacturing.quality TO manufacturing-team; GRANT CREATE SCHEMA ON SCHEMA manufacturing.quality TO manufacturing-team; GRANT USE CATALOG ON CATALOG manufacturing TO manufacturing-team;

Comment: *

Name: *

Email: *

Verification: *

Which query is performing a streaming hop from raw data to a Bronze table?

• A.
• B.
• C.
• D.

Comment: *

Name: *

Email: *

Verification: *