certifhub logo
Use code BLOG30 | 30% OFF
Copied! Paste at checkout

Databricks Certified Data Engineer Associate · Free Practice Question Easy

Question 26

Which of the following commands can a data engineer use to grant full permissions to the HR team on the table employees ?

  • A

    GRANT ALL PRIVILEGES ON TABLE employees TO hr_team

  • B

    GRANT FULL PRIVILEGES ON TABLE employees TO hr_team

  • C

    GRANT SELECT, MODIFY, CREATE, READ_METADATA ON TABLE employees TO hr_team

  • D

    GRANT ALL PRIVILEGES ON employees TO hr_team

Reveal correct answer

Correct answer: A

Explanation

ALL PRIVILEGES is used to grant full permissions on an object to a user or group of users. The syntax for the GRANT command is as follows:


GRANT <privilege> ON TABLE <table_name> TO <principal>;


Study materials from our exam preparation course on Udemy:


Discussion

Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.

You must be logged in to post a comment.

Preparing For

Your Certification?

255+ certifications
Detailed explanations
Free PDF samples

Has All The Questions You Need