Exam Certified Data Engineer Associate topic 1 question 90 discussion

Actual exam question from Databricks's Certified Data Engineer Associate

Question #: 90
Topic #: 1

[All Certified Data Engineer Associate Questions]

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 commands can be used to grant full permissions on the database to the new data engineering team?

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 USAGE ON TABLE sales TO team;
E. GRANT ALL PRIVILEGES ON TABLE team TO sales;

Show Suggested Answer

Suggested Answer: A 🗳️

by meow_akk at Oct. 22, 2023, 7:59 p.m.

Comments

Submit Cancel

meow_akk

Highly Voted 1 year, 1 month ago

Ans A : grant "privilege" on "object" object_name to <user or group>

upvoted 5 times

...

sandbar_dorados_09

Most Recent 3 months, 3 weeks ago

Selected Answer: A

The closest answer to solving the problem is A. Since “sales” is a database (schema) the correct answer should be GRANT ALL PRIVILEGES ON SCHEMA <schema_name> TO <principal>;

upvoted 1 times

...