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
The correct answer is A. GRANT ALL PRIVILEGES ON TABLE sales TO team;
Why this is correct:
- SQL Syntax: The
GRANT ALL PRIVILEGEScommand is the standard SQL syntax for granting all available privileges on a database object to a user or role. - Object Specification:
ON TABLE salescorrectly specifies the target table. - Recipient Specification:
TO teamcorrectly specifies the recipient (user or role) receiving the privileges. - Complete Privilege Grant:
ALL PRIVILEGESgrants all available permissions including SELECT, INSERT, UPDATE, DELETE, CREATE, MODIFY, DROP, etc.
Why other options are incorrect:
- B. GRANT SELECT CREATE MODIFY ON TABLE sales TO team;: This syntax is invalid. While some database systems might support granting multiple specific privileges, the correct Databricks/ANSI SQL syntax uses
ALL PRIVILEGESfor granting all permissions. - C. GRANT SELECT ON TABLE sales TO team;: This only grants SELECT privilege, not full privileges as required by the question.
- D. GRANT ALL PRIVILEGES ON TABLE team TO sales;: This reverses the table and recipient, attempting to grant privileges on a table called 'team' to 'sales', which doesn't make sense in this context.
Key Learning Points:
- In Databricks SQL,
GRANT ALL PRIVILEGESis the correct way to grant all available permissions on a table. - The syntax follows the pattern:
GRANT <privileges> ON <object_type> <object_name> TO <user_or_role> - For table-level permissions in Databricks, you can also use more granular grants like
GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE sales TO team;butALL PRIVILEGESis the most comprehensive. - Always verify the object name and recipient are correctly specified in the grant statement.
Comments
Loading comments...