Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
exam questions

Exam Certified Data Engineer Associate All Questions

View all questions & answers for the Certified Data Engineer Associate exam

Exam Certified Data Engineer Associate topic 1 question 135 discussion

Actual exam question from Databricks's Certified Data Engineer Associate
Question #: 135
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 command 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 ALL PRIVILEGES ON TABLE team TO sales;
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
CommanderBigMac
2 months, 1 week ago
Selected Answer: A
A is correct. Grant all on table sales to team, not table team to sales.
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...