Prepare with Databricks : Certified-Data-Engineer-Professional exam braindumps as your best preparation materials

A workspace admin has created a new catalog called finance_data and wants to delegate permission management to a finance team lead without giving them full admin rights. Which privilege should be granted to the finance team lead?

• A. GRANT OPTION privilege on the finance_data catalog.
• B. ALL PRIVILEGES on the finance_data catalog.
• C. MANAGE privilege on the finance_data catalog.
• D. Make the finance team lead a metastore admin.

A data company uses Databricks Unity Catalog and has multiple enterprise data sources, including PostgreSQL, Snowflake, and SQL Server. The central data platform team wants to configure Lakehouse Federation so analysts can query external tables directly in Databricks using Databricks SQL, without duplicating data. Which steps are necessary to configure Lakehouse Federation in a secure and governed manner?

• A. Use Partner Connect to create linked datasets, and apply table ACLs at the source system to govern access through Databricks.
• B. Create external locations and storage credentials to connect to each database, then register foreign tables in Unity Catalog.
• C. Mirror the external datasets into Delta Lake using Auto Loader, and govern them using Data Lineage and System Tables.
• D. Configure connections and foreign catalog in Unity Catalog, then grant access to foreign catalogs, schemas, and tables using Unity Catalog permissions.

Incorporating unit tests into a PySpark application requires upfront attention to the design of your jobs, or a potentially significant refactoring of existing code.
Which statement describes a main benefit that offset this additional effort?

• A. Troubleshooting is easier since all steps are isolated and tested individually
• B. Yields faster deployment and execution times
• C. Ensures that all steps interact correctly to achieve the desired end result
• D. Improves the quality of your data
• E. Validates a complete use case of your application

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. 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.
• B. Create a view with dynamic WHERE clauses for region filtering and use string replacement functions for email masking using ALTER COLUMN SET MASK command.
• C. 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.
• D. 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.

A data engineer wants to automate job monitoring and recovery in Databricks using the Jobs API.
They need to list all jobs, identify a failed job, and rerun it. Which sequence of API actions should the data engineer perform?

• A. Use the jobs/list endpoint to list jobs, check job run statuses with jobs/runs/list, and rerun a failed job using jobs/run-now.
• B. Use the jobs/list endpoint to list jobs, then use the jobs/create endpoint to create a new job, and run the new job using jobs/run-now.
• C. Use the jobs/cancel endpoint to remove failed jobs, then recreate them with jobs/create and run the new ones.
• D. Use the jobs/get endpoint to retrieve job details, then use jobs/update to rerun failed jobs.