Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
A new data engineering team has been assigned to an ELT project. The new data engineering team will need full privileges on the table sales to fully manage the project. Which of the following commands can be used to grant full permissions on the database to the new data engineering team?
Real Exam
Community
KKeng
A
GRANT ALL PRIVILEGES ON TABLE sales TO team;
B
GRANT SELECT CREATE MODIFY ON TABLE sales TO team;
C
GRANT SELECT ON TABLE sales TO team;
D
GRANT USAGE ON TABLE sales TO team;
E
GRANT ALL PRIVILEGES ON TABLE team TO sales;
Explanation:
Explanation
Correct Answer: A
Why Option A is correct:
GRANT ALL PRIVILEGES ON TABLE sales TO team;is the proper SQL syntax for granting all available privileges on a specific table to a user or group.- In Databricks Unity Catalog, this command would grant all permissions including SELECT, MODIFY, CREATE, USAGE, and other privileges on the
salestable to theteamprincipal. - This matches the requirement of giving the new data engineering team "full privileges" to "fully manage the project."
Why other options are incorrect:
Option B: GRANT SELECT CREATE MODIFY ON TABLE sales TO team; - This syntax is incorrect. While it lists specific privileges, the proper syntax would be GRANT SELECT, CREATE, MODIFY ON TABLE sales TO team; with commas separating privileges.
Option C: GRANT SELECT ON TABLE sales TO team; - This only grants SELECT privilege, which is insufficient for full management of the table.
Option D: GRANT USAGE ON TABLE sales TO team; - USAGE privilege alone is insufficient for managing the table. USAGE typically allows using the object but not modifying it.
Option E: GRANT ALL PRIVILEGES ON TABLE team TO sales; - This has the syntax reversed. It's trying to grant privileges on the team table to sales, which doesn't make sense in this context.
Key Concepts:
- In Databricks Unity Catalog, the
GRANTcommand is used to assign privileges to principals (users or groups). ALL PRIVILEGESis a shorthand for granting all available privileges on an object.- Proper table privilege management is essential for data governance and security in the Databricks Lakehouse Platform.
Comments
Loading comments...