Databricks-Certified-Data-Engineer-Associate 試験問題を無料オンラインアクセス

Which of the following statements regarding the relationship between Silver tables and Bronze tables is always true?

• A.Silver tables contain a more refined and cleaner view of data than Bronze tables.
• B.Silver tables contain more data than Bronze tables.
• C.Silver tables contain less data than Bronze tables.
• D.Silver tables contain aggregates while Bronze data is unaggregated.
• E.Silver tables contain a less refined, less clean view of data than Bronze data.

A data engineer has a Python variable table_name that they would like to use in a SQL query. They want to construct a Python code block that will run the query using table_name.
They have the following incomplete code block:
____(f"SELECT customer_id, spend FROM {table_name}")
Which of the following can be used to fill in the blank to successfully complete the task?

• A.spark.delta.sql
• B.dbutils.sql
• C.spark.delta.table
• D.spark.sql
• E.spark.table

A data engineer is maintaining a data pipeline. Upon data ingestion, the data engineer notices that the source data is starting to have a lower level of quality. The data engineer would like to automate the process of monitoring the quality level.
Which of the following tools can the data engineer use to solve this problem?

• A.Data Explorer
• B.Delta Lake
• C.Auto Loader
• D.Delta Live Tables
• E.Unity Catalog

Which of the following code blocks will remove the rows where the value in column age is greater than 25 from the existing Delta table my_table and save the updated table?

• A.UPDATE my_table WHERE age <= 25;
• B.SELECT * FROM my_table WHERE age > 25;
• C.DELETE FROM my_table WHERE age > 25;
• D.DELETE FROM my_table WHERE age <= 25;
• E.UPDATE my_table WHERE age > 25;

Which of the following commands will return the number of null values in the member_id column?

• A.SELECT count_null(member_id) FROM my_table;
• B.SELECT null(member_id) FROM my_table;
• C.SELECT count(member_id) FROM my_table;
• D.SELECT count(member_id) - count_null(member_id) FROM my_table;
• E.SELECT count_if(member_id IS NULL) FROM my_table;