Databricks Certified Data Engineer - Professional
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
A newly appointed data engineer requires USAGE privileges on two tables: the 'policy' table from the 'insurance' database and the 'demographics' table from the 'customers' database. What will be the outcome of executing the following query: GRANT USAGE ON TABLES customers.demographics, insurance.policy TO new_user;?_
A
The query will fail because privileges on multiple tables cannot be granted in a single GRANT statement.
B
The query will be successful, granting the new_user the requested privileges._
C
TABLES should be replaced with TABLE for the query to execute correctly.
D
The query will not be successful as the GRANT statement cannot be used to grant permissions on tables.
E
The query will execute without errors, but grants will only be given on the first table mentioned.