A data engineer is masking a column containing email addresses. The goal is to produce output strings of identical length for all rows, while generating different outputs for different email values.
Which SQL function should be used to achieve this?

• A. mask(email, '?')
• B. hash(email)
• C. sha2(email, 0)
• D. sha1(email)

A member of the data engineering team has submitted a short notebook that they wish to schedule as part of a larger data pipeline. Assume that the commands provided below produce the logically correct results when run as presented.

Which command should be removed from the notebook before scheduling it as a job?

• A. Cmd 5
• B. Cmd 2
• C. Cmd 3
• D. Cmd 6
• E. Cmd 4

A platform team is creating a standardized template for Databricks Asset Bundles to support CI/CD. The template must specify defaults for artifacts, workspace root paths, and a run identity, while allowing a "dev" target to be the default and override specific paths. How should the team use databricks.yml to satisfy these requirements?

• A. Use bundle, artifacts, workspace, run_as, and targets at the top level; set one target with default:true and override workspace paths or artifacts under that target.
• B. Use deployment, builds, context, identity, and environments; set dev as default environment and override paths under builds.
• C. Use roots, modules, profiles, actor, and targets; where profiles contain workspace and artifacts defaults and actor sets run identity.
• D. Use project, packages, environment, identity, and stages; set dev as default stage and override workspace under environment.

The data architect has decided that once data has been ingested from external sources into the Databricks Lakehouse, table access controls will be leveraged to manage permissions for all production tables and views.
The following logic was executed to grant privileges for interactive queries on a production database to the core engineering group.
GRANT USAGE ON DATABASE prod TO eng;
GRANT SELECT ON DATABASE prod TO eng;
Assuming these are the only privileges that have been granted to the eng group and that these users are not workspace administrators, which statement describes their privileges?

• A. Group members are able to query and modify all tables and views in the prod database, but cannot create new tables or views.
• B. Group members have full permissions on the prod database and can also assign permissions to other users or groups.
• C. Group members are able to list all tables in the prod database but are not able to see the results of any queries on those tables.
• D. Group members are able to create, query, and modify all tables and views in the prod database, but cannot define custom functions.
• E. Group members are able to query all tables and views in the prod database, but cannot create or edit anything in the database.

The data engineer is using Spark's MEMORY_ONLY storage level. Which indicators should the data engineer look for in the spark UI's Storage tab to signal that a cached table is not performing optimally?

• A. The RDD Block Name included the '' annotation signaling failure to cache
• B. Size on Disk is < Size in Memory
• C. The number of Cached Partitions> the number of Spark Partitions
• D. Size on Disk is> 0
• E. On Heap Memory Usage is within 75% of off Heap Memory usage