Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
A new data engineering team has been assigned to work on a project. The team will need access to database customers in order to see what tables already exist. The team has its own group team. Which of the following commands can be used to grant the necessary permission on the entire database to the new team?
Real Exam
Community
KKeng
A
GRANT VIEW ON CATALOG customers TO team;
B
GRANT CREATE ON DATABASE customers TO team;
C
GRANT USAGE ON CATALOG team TO customers;
D
GRANT CREATE ON DATABASE team TO customers;
E
GRANT USAGE ON DATABASE customers TO team;
Explanation:
The correct answer is E because:
-
USAGE privilege is required to access and view objects within a database. The USAGE privilege on a database allows users to see what tables exist within that database.
-
Database context: The question specifies access to the "database customers" for the "team" group, so the syntax should be
GRANT USAGE ON DATABASE customers TO team; -
Why other options are incorrect:
- A:
GRANT VIEW ON CATALOG customers TO team;- This grants view permission on a catalog, not a database - B:
GRANT CREATE ON DATABASE customers TO team;- This grants CREATE permission, which allows creating new tables, but not necessarily viewing existing ones - C:
GRANT USAGE ON CATALOG team TO customers;- This reverses the direction (grants permission on catalog 'team' to 'customers') - D:
GRANT CREATE ON DATABASE team TO customers;- This grants CREATE permission on database 'team' to 'customers', which is the opposite of what's needed
- A:
-
Note: The explanation in the original text mentions
GRANT ALL PRIVILEGES ON DATABASE customers TO team;which would also work, but among the given options, only E provides the necessary USAGE privilege to view existing tables in the database.
Comments
Loading comments...