A junior data engineer on your team has implemented the following code block.

The viewnew_eventscontains a batch of records with the same schema as theeventsDelta table.
Theevent_idfield serves as a unique key for this table.
When this query is executed, what will happen with new records that have the sameevent_idas an existing record?

• A.They are merged.
• B.They are ignored.
• C.They are updated.
• D.They are inserted.
• E.They are deleted.

Comment: *

Name: *

Email: *

Verification: *

What are the different ways you can schedule a job in Databricks workspace?

• A.Continuous, Incremental
• B.On-Demand runs, File notification from Cloud object storage
• C.Cron, On Demand runs
• D.Cron, File notification from Cloud object storage
• E.Once, Continuous

Comment: *

Name: *

Email: *

Verification: *

A junior data engineer has manually configured a series of jobs using the Databricks Jobs UI. Upon reviewing their work, the engineer realizes that they are listed as the "Owner" for each job. They attempt to transfer
"Owner" privileges to the "DevOps" group, but cannot successfully accomplish this task.
Which statement explains what is preventing this privilege transfer?

• A.Databricks jobs must have exactly one owner; "Owner" privileges cannot be assigned to a group.
• B.The creator of a Databricks job will always have "Owner" privileges; this configuration cannot be changed.
• C.Other than the default "admins" group, only individual users can be granted privileges on jobs.
• D.A user can only transfer job ownership to a group if they are also a member of that group.
• E.Only workspace administrators can grant "Owner" privileges to a group.

Comment: *

Name: *

Email: *

Verification: *

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 thegeo_lookuptable.
Before executing the code, runningSHOWTABLESon the current database indicates the database contains only two tables:geo_lookupandsales.

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. Cmd 2 will search all accessible databases for a table or view named countries af: if this entity exists, Cmd 2 will succeed.
• C.Cmd 1 will succeed and Cmd 2 will fail, countries at will be a Python variable representing a PySpark DataFrame.
• D.Both commands will fail. No new variables, tables, or views will be created.
• E.Cmd 1 will succeed and Cmd 2 will fail, countries at will be a Python variable containing a list of strings.

Comment: *

Name: *

Email: *

Verification: *

The data engineering team has configured a job to process customer requests to be forgotten (have their data deleted). All user data that needs to be deleted is stored in Delta Lake tables using default table settings.
The team has decided to process all deletions from the previous week as a batch job at 1am each Sunday. The total duration of this job is less than one hour. Every Monday at 3am, a batch job executes a series ofVACUUMcommands on all Delta Lake tables throughout the organization.
The compliance officer has recently learned about Delta Lake's time travel functionality. They are concerned that this might allow continued access to deleted data.
Assuming all delete logic is correctly implemented, which statement correctly addresses this concern?

• A.Because the vacuum command permanently deletes all files containing deleted records, deleted records may be accessible with time travel for around 24 hours.
• B.Because the default data retention threshold is 24 hours, data files containing deleted records will be retained until the vacuum job is run the following day.
• C.Because Delta Lake time travel provides full access to the entire history of a table, deleted records can always be recreated by users with full admin privileges.
• D.Because Delta Lake's delete statements have ACID guarantees, deleted records will be permanently purged from all storage systems as soon as a delete job completes.
• E.Because the default data retention threshold is 7 days, data files containing deleted records will be retained until the vacuum job is run 8 days later.

Comment: *

Name: *

Email: *

Verification: *