When using the complete mode to write stream data, how does it impact the target table?

• A.Entire stream waits for complete data to write
• B.Stream must complete to write the data
• C.Target table cannot be updated while stream is pending
• D.Target table is overwritten for each batch
• E.Delta commits transaction once the stream is stopped

Comment: *

Name: *

Email: *

Verification: *

Which of the following section in the UI can be used to manage permissions and grants to tables?

• A.User Settings
• B.Admin UI
• C.Workspace admin settings
• D.User access control lists
• E.Data Explorer

Comment: *

Name: *

Email: *

Verification: *

You are asked to debug a databricks job that is taking too long to run on Sunday's, what are the steps you are going to take to identify the step that is taking longer to run?

• A.A notebook activity of job run is only visible when using all-purpose cluster.
• B.Under Workflow UI and jobs select job you want to monitor and select the run, notebook activity can be viewed.
• C.Enable debug mode in the Jobs to see the output activity of a job, output should be available to view.
• D.Once a job is launched, you cannot access the job's notebook activity.
• E.Use the compute's spark UI to monitor the job activity.

Correct Answer: B

Explanation
The answer is, Under Workflow UI and jobs select job you want to monitor and select the run, notebook activity can be viewed.
You have the ability to view current active runs or completed runs, once you click the run you can see the A picture containing graphical user interface Description automatically generated

Click on the run to view the notebook output
Graphical user interface, text, application, email Description automatically generated

Comment: *

Name: *

Email: *

Verification: *

The default threshold of VACUUM is 7 days, internal audit team asked to certain tables to maintain at least
365 days as part of compliance requirement, which of the below setting is needed to implement.

• A.ALTER TABLE table_name set TBLPROPERTIES (del-ta.deletedFileRetentionDuration= 'interval 365 days')
• B.MODIFY TABLE table_name set TBLPROPERTY (delta.maxRetentionDays = 'inter-val 365 days')
• C.ALTER TABLE table_name set EXENDED TBLPROPERTIES (del-ta.deletedFileRetentionDuration=
  'interval 365 days')
• D.ALTER TABLE table_name set EXENDED TBLPROPERTIES (delta.vaccum.duration= 'interval 365 days')

Comment: *

Name: *

Email: *

Verification: *

You are tasked to set up a set notebook as a job for six departments and each department can run the task parallelly, the notebook takes an input parameter dept number to process the data by department, how do you go about to setup this up in job?

• A.Use a single notebook as task in the job and use dbutils.notebook.run to run each note-book with parameter in a different cell
• B.A task in the job cannot take an input parameter, create six notebooks with hardcoded dept number and setup six tasks with linear dependency in the job
• C.A task accepts key-value pair parameters, creates six tasks pass department number as parameter foreach task with no dependency in the job as they can all run in parallel.
  (Correct)
• D.A parameter can only be passed at the job level, create six jobs pass department number to each job with linear job dependency
• E.A parameter can only be passed at the job level, create six jobs pass department number to each job with no job dependency

Correct Answer: C

Explanation
Here is how you setup
Create a single job and six tasks with the same notebook and assign a different parameter for each task , Graphical user interface, text, application, email Description automatically generated

All tasks are added in a single job and can run parallel either using single shared cluster or with individual clusters.
Graphical user interface, application, Teams Description automatically generated

Comment: *

Name: *

Email: *

Verification: *