Databricks Databricks-Certified-Data-Engineer-Professional 試験概要:

Databricks Databricks-Certified-Data-Engineer-Professional 試験シラバストピック:

Databricks Certified Data Engineer Professional 認定 Databricks-Certified-Data-Engineer-Professional 試験問題：

1. The marketing team is looking to share data in an aggregate table with the sales organization, but the field names used by the teams do not match, and a number of marketing specific fields have not been approval for the sales org.
Which of the following solutions addresses the situation while emphasizing simplicity?

A) Use a CTAS statement to create a derivative table from the marketing table configure a production jon to propagation changes.
B) Instruct the marketing team to download results as a CSV and email them to the sales organization.
C) Create a new table with the required schema and use Delta Lake's DEEP CLONE functionality to sync up changes committed to one table to the corresponding table.
D) Create a view on the marketing table selecting only these fields approved for the sales team alias the names of any fields that should be standardized to the sales naming conventions.
E) Add a parallel table write to the current production pipeline, updating a new sales table that varies as required from marketing table.

2. A data team's Structured Streaming job is configured to calculate running aggregates for item sales to update a downstream marketing dashboard. The marketing team has introduced a new field to track the number of times this promotion code is used for each item. A junior data engineer suggests updating the existing query as follows: Note that proposed changes are in bold.
Original query:

Proposed query:

Which step must also be completed to put the proposed query into production?

A) Increase the shuffle partitions to account for additional aggregates
B) Run REFRESH TABLE delta, /item_agg'
C) Specify a new checkpointlocation
D) Register the data in the "/item_agg" directory to the Hive metastore
E) Remove .option (mergeSchema', true') from the streaming write

3. A data engineering team needs to implement a tagging system for their tables as part of an automated ETL process, and needs to apply tags programmatically to tables in Unity Catalog.
Which SQL command adds tags to a table programmatically?

A) APPLY TAGS ON table_name VALUES ('key1' = 'value1', 'key2' = 'value2');
B) SET TAGS FOR table_name AS ('key1' = 'value1', 'key2' = 'value2');
C) ALTER TABLE table_name SET TAGS ('key1' = 'value1', 'key2' = 'value2');
D) COMMENT ON TABLE table_name TAGS ('key1' = 'value1', 'key2' = 'value2');

4. A data engineering team is configuring access controls in Databricks Unity Catalog. They grant the SELECT privilege on the sales catalog to the analyst_group, expecting that members of this group will automatically have SELECT access to all current and future schemas, tables, and views within the catalog. What describes the privilege inheritance behavior in Unity Catalog?

A) Granting SELECT on a catalog automatically applies SELECT to all current and future schemas, tables, and views within that catalog.
B) Granting SELECT at the catalog level applies to existing schemas and tables but not to those created in the future.
C) Privileges in Unity Catalog do not cascade; SELECT must be explicitly granted on each schema and table, even if granted at the catalog level.
D) Privileges granted at the schema level override any catalog-level privileges and prevent access unless explicitly revoked.

5. A junior member of the data engineering team is exploring the language interoperability of Databricks notebooks. The intended outcome of the below code is to register a view of all sales that occurred in countries on the continent of Africa that appear in the geo_lookup table.
Before executing the code, running SHOW TABLES on the current database indicates the database contains only two tables: geo_lookup and sales.

Which statement correctly describes the outcome of executing these command cells in order in an interactive notebook?

A) Both commands will succeed. Executing show tables will show that countries at and sales at have been registered as views.
B) Cmd 1 will succeed and Cmd 2 will fail, countries at will be a Python variable representing a PySpark DataFrame.
C) Both commands will fail. No new variables, tables, or views will be created.
D) Cmd 1 will succeed. Cmd 2 will search all accessible databases for a table or view named countries af: if this entity exists, Cmd 2 will succeed.
E) Cmd 1 will succeed and Cmd 2 will fail, countries at will be a Python variable containing a list of strings.

質問と回答：