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

The data governance team is reviewing user for deleting records for compliance with GDPR. The following logic has been implemented to propagate deleted requests from the user_lookup table to the user aggregate table.

Assuming that user_id is a unique identifying key and that all users have requested deletion have been removed from the user_lookup table, which statement describes whether successfully executing the above logic guarantees that the records to be deleted from the user_aggregates table are no longer accessible and why?

• A.No; the Delta Lake DELETE command only provides ACID guarantees when combined with the MERGE INTO command
• B.Yes; Delta Lake ACID guarantees provide assurance that the DELETE command successed fully and permanently purged these records.
• C.Yes; the change data feed uses foreign keys to ensure delete consistency throughout the Lakehouse.
• D.No; files containing deleted records may still be accessible with time travel until a BACUM command is used to remove invalidated data files.
• E.No; the change data feed only tracks inserts and updates not deleted records.

A junior developer complains that the code in their notebook isn't producing the correct results in the development environment. A shared screenshot reveals that while they're using a notebook versioned with Databricks Repos, they're using a personal branch that contains old logic. The desired branch named dev-2.3.9 is not available from the branch selection dropdown.
Which approach will allow this developer to review the current logic for this notebook?

• A.Use Repos to make a pull request use the Databricks REST API to update the current branch to dev-2.3.9
• B.Merge all changes back to the main branch in the remote Git repository and clone the repo again
• C.Use Repos to pull changes from the remote Git repository and select the dev-2.3.9 branch.
• D.Use Repos to merge the current branch and the dev-2.3.9 branch, then make a pull request to sync with the remote repository
• E.Use Repos to checkout the dev-2.3.9 branch and auto-resolve conflicts with the current branch

A table is registered with the following code:

Both users and orders are Delta Lake tables. Which statement describes the results of querying recent_orders?

• A.All logic will execute at query time and return the result of joining the valid versions of the source tables at the time the query finishes.
• B.Results will be computed and cached when the table is defined; these cached results will incrementally update as new records are inserted into source tables.
• C.The versions of each source table will be stored in the table transaction log; query results will be saved to DBFS with each query.
• D.All logic will execute when the table is defined and store the result of joining tables to the DBFS; this stored data will be returned when the table is queried.
• E.All logic will execute at query time and return the result of joining the valid versions of the source tables at the time the query began.

Which distribution does Databricks support for installing custom Python code packages?

• A.jars
• B.Wheels
• C.nom
• D.sbt
• E.CRAM
• F.CRAN

A security team wants to enforce data protection for a customer table containing customer PII data. To comply with local policies, sales team members should only see customers from their region, while non-admin users should have email addresses masked. Which implementation approach should be used when using Unity Catalog row filters and column masks?

• A.Use table ACLs to restrict access using tags with GRANT SELECT ON table_name WITH TAG command, and rely on application-level filtering for sensitive data based on user region.
• B.Create SQL UDFs for row filtering based on user region and column masking based on group membership, then apply them using ALTER TABLE SET ROW FILTER and ALTER COLUMN SET MASK commands.
• C.Implement row filters with SQL UDFs based on user region only since column masks cannot be combined with row filters on the same table, then apply them be recreating the table with DROP TABLE and CREATE TABLE SET ROW FILTER commands.
• D.Create a view with dynamic WHERE clauses for region filtering and use string replacement functions for email masking using ALTER COLUMN SET MASK command.