A new data engineering team 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…

Question

Options

• AGRANT ALL PRIVILEGES ON TABLE sales TO team;
• BGRANT SELECT CREATE MODIFY ON TABLE sales TO team;
• CGRANT SELECT ON TABLE sales TO team;
• DGRANT USAGE ON TABLE sales TO team;
• EGRANT ALL PRIVILEGES ON TABLE team TO sales;

• A
  95% (35)
• C
  3% (1)
• E
  3% (1)

Explanation

The SQL command GRANT ALL PRIVILEGES ON TABLE sales TO team; grants the full set of permissions (SELECT, INSERT, UPDATE, DELETE, etc.) on the table to the specified team. Option B is invalid SQL syntax - privileges must be separated by commas and 'MODIFY' is not a standard Databricks SQL privilege keyword. Option C grants only SELECT (read-only). Option D grants USAGE, which is typically a schema-level privilege, not full table access. Option E reverses the object and grantee, making it semantically incorrect.

No community discussion yet for this question.