Kevin is the owner of both the sales table and regional_sales_vw view which uses the sales table as the underlying source for the data, and Kevin is looking to grant select privilege on the view regional_sales_vw to one of newly joined team members Steven. Which of the following is a true statement?

• A.Kevin can not grant access to Steven since he does not have security admin privilege
• B.Kevin although is the owner but does not have ALL PRIVILEGES permission
• C.Kevin can grant access to the view, because he is the owner of the view and the under-lying table
• D.Kevin can not grant access to Steven since he does have workspace admin privilege
• E.Steve will also require SELECT access on the underlying table

Comment: *

Name: *

Email: *

Verification: *

John Smith is a newly joined team member in the Marketing team who currently has access read access to sales tables but does not have access to delete rows from the table, which of the following commands help you accomplish this?

• A.GRANT USAGE ON TABLE table_name TO [email protected]
• B.GRANT DELETE ON TABLE table_name TO [email protected]
• C.GRANT DELETE TO TABLE table_name ON [email protected]
• D.GRANT MODIFY TO TABLE table_name ON [email protected]
• E.GRANT MODIFY ON TABLE table_name TO [email protected]

Comment: *

Name: *

Email: *

Verification: *

Which of the following commands can be used to query a delta table?

• A.1.%python
  2.spark.sql("select * from table_name")
• B.1.%sql
  2.Select * from table_name
• C.Both A & B
  (Correct)
• D.1.%python
  2.execute.sql("select * from table")
• E.1.%python
  2.delta.sql("select * from table")

Comment: *

Name: *

Email: *

Verification: *

Which of the following developer operations in CI/CD flow can be implemented in Databricks Re-pos?

• A.Delete branch
• B.Trigger Databricks CICD pipeline
• C.Commit and push code
• D.Create a pull request
• E.Approve the pull request

Correct Answer: C

Explanation
The answer is Commit and push code.
See the below diagram to understand the role Databricks Repos and Git provider plays when building a CI/CD workflow.
All the steps highlighted in yellow can be done Databricks Repo, all the steps highlighted in Gray are done in a git provider like Github or Azure Devops.
Exam focus: Please study the below image carefully to understand all of the steps in the CI/CD flow to understand the tasks that are implemented in Databricks Repo vs Git Provider, exam may ask a different type of questions based on this flow.
Diagram Description automatically generated

Comment: *

Name: *

Email: *

Verification: *

Which of the following array functions takes input column return unique list of values in an array?

• A.COLLECT_LIST
• B.COLLECT_SET
• C.COLLECT_UNION
• D.ARRAY_INTERSECT
• E.ARRAY_UNION

Correct Answer: B

Explanation
Table Description automatically generated

Comment: *

Name: *

Email: *

Verification: *