Databricks Certified Data Engineer Professional - Certified-Data-Engineer-Professional Free Exam Questions

A. SELECT sku_name,
identity_metadata.created_by AS user_email,
SUM(usage_quantity * usage_unit) AS total_dbus
FROM system.billing.usage
GROUP BY user_email, sku_name
ORDER BY total_dbus DESC
LIMIT 10

B. SELECT sku_name,
identity_metadata.created_by AS user_email,
COUNT(usage_quantity) AS total_dbus
FROM system.billing.usage
GROUP BY user_email, sku_name
ORDER BY total_dbus DESC
LIMIT 10

C. SELECT identity_metadata.run_as AS user_email,
SUM(usage_quantity) AS total_dbus
FROM system.billing.usage
GROUP BY user_email
ORDER BY total_dbus DESC
LIMIT 10

D. SELECT sku_name,
usage_metadata.run_name AS user_email,
SUM(usage_quantity) AS total_dbus
FROM system.billing.usage
GROUP BY user_email, sku_name
ORDER BY total_dbus DESC
LIMIT 10

A. Configure cloudFiles.maxPartitionBytes with 1GB to limit data in each partition.

B. Configure cloudFiles.maxSizePerTrigger with 1 GB to place a limit.

C. Configure cloudFiles.maxFilesPerTrigger and estimate the average file size to approximate a size-based throttle of 1 GB.

D. Configure cloudFiles.maxBytesPerTrigger with 1 GB to place a limit.

A. Stop the existing pipeline; use the returned settings in a reset command

B. Use the alone command to create a copy of an existing pipeline; use the get JSON command to get the pipeline definition; save this to git

C. Use list pipelines to get the specs for all pipelines; get the pipeline spec from the return results parse and use this to create a pipeline

D. Use the get command to capture the settings for the existing pipeline; remove the pipeline_id and rename the pipeline; use this in a create command

A. An external table will be created in the storage container mounted to /mnt/finance eda bucket.

B. A managed table will be created in the DBFS root storage container.

C. An managed table will be created in the storage container mounted to /mnt/finance_eda_bucket.

D. A logical table will persist the physical plan to the Hive Metastore in the Databricks control plane.

E. A logical table will persist the query plan to the Hive Metastore in the Databricks control plane.

A. Can Read

B. Can Edit

C. No permissions

D. Can Manage

E. Can Run

A. Execute a query to calculate the difference between the new version and the previous version using Delta Lake's built-in versioning and time travel functionality.

B. Parse the Delta Lake transaction log to identify all newly written data files.

C. Execute DESCRIBE HISTORY customer_churn_params to obtain the full operation metrics for the update, including a log of all records that have been added or modified.

D. Parse the Spark event logs to identify those rows that were updated, inserted, or deleted.

A. Use salting by adding a random prefix to skewed keys before aggregation, then aggregate again after removing the prefix.

B. Filter out the skewed users before the aggregation.

C. Increase the Spark driver memory and retry.

D. Use reduceByKey instead of groupBy to avoid shuffles.

A. Update the task by adding the missing task parameter, and manually run the job.

B. Share the analysis with the failing notebook owner so that they can fix it quickly.

C. Repair the run with the new parameter, and update the task by adding the missing task parameter.

D. Repair the run with the new parameter.

A. databricks compute add 14.3.x-scala2.12 --num-workers 5 --node-type-id i3.xlarge --cluster-name Data Engineer_cluster

B. databricks compute create 14.3.x-scala2.12 --num-workers 5 --node-type-id i3.xlarge --cluster- name Data Engineer_cluster

C. databricks clusters add 14.3.x-scala2.12 --num-workers 5 --node-type-id i3.xlarge --cluster-name Data Engineer_cluster

D. databricks clusters create 14.3.x-scala2.12 --num-workers 5 --node-type-id i3.xlarge --cluster- name DataEngineer_cluster