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 command 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 ALL PRIVILEGES ON TABLE team TO sales;
Explanation:
Explanation
Correct Answer: A
GRANT ALL PRIVILEGES ON TABLE sales TO team; is the correct command to grant full permissions on the sales table to the team.
Why this is correct:
- The
GRANT ALL PRIVILEGESsyntax grants all available privileges on the specified object (table sales) to the specified user/group (team). - This includes privileges like SELECT, INSERT, UPDATE, DELETE, CREATE, MODIFY, DROP, etc., which would be needed for full management of the project.
- The syntax follows the standard SQL pattern:
GRANT ALL PRIVILEGES ON TABLE <table_name> TO <user/group>;
Why other options are incorrect:
B. GRANT SELECT CREATE MODIFY ON TABLE sales TO team; - This syntax is incorrect. While it attempts to list specific privileges, the proper syntax would require separate privilege specifications or using ALL PRIVILEGES.
C. GRANT SELECT ON TABLE sales TO team; - This only grants SELECT privilege, which is insufficient for full project management. The team needs more than just read access.
D. GRANT ALL PRIVILEGES ON TABLE team TO sales; - This reverses the table and recipient, granting privileges on the 'team' table to 'sales', which is the opposite of what's needed.
Key Points:
- In Databricks Unity Catalog, the
GRANT ALL PRIVILEGEScommand provides comprehensive access to manage tables. - For ELT projects, data engineering teams typically need full control over tables to perform transformations, load data, and manage schema changes.
- Always verify the direction of the grant statement: privileges ON object TO recipient.
Comments
Loading comments...