MENU
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?
Suggested Answer: E
Get Premium Databricks Certified Data Engineer Associate Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
24 comments · newest first
CA
Casandra
11 months ago
I thought CREATE was for creating new databases, not granting access.
LA
Latosha
11 months ago
Option A is definitely not it, that's for sure.
ME
Meghann
11 months ago
Wait, can you really grant usage on a database like that? Seems off.
TH
Theola
11 months ago
Yeah, I agree, E makes the most sense here.
CA
Candida
12 months ago
I think option E is the right one for granting access.
EI
Eileen
12 months ago
I’m leaning towards option E, "GRANT USAGE ON DATABASE customers TO team," but I can't recall if that's the right syntax.
MA
Macy
12 months ago
I feel like "GRANT CREATE ON DATABASE" might be too much permission for just viewing tables.
RE
Rebecka
1 year ago
I remember practicing a similar question where we had to grant permissions, and "GRANT USAGE ON DATABASE" sounds familiar for accessing tables.
GO
Golda
1 year ago
I think the command we need is related to granting access to the database, but I'm not sure if it's "USAGE" or "VIEW."
PA
Page
1 year ago
This seems straightforward. The question is asking for a command to grant permissions on the entire database, so I'd go with option E - GRANT USAGE ON DATABASE customers TO team.
JA
Jani
1 year ago
I'm a little confused by the wording of the question. Does "customers" refer to the database name or the table name? That's going to impact the correct command to use.
NO
Noemi
1 year ago
Okay, I think I've got this. We need to grant the USAGE permission on the entire DATABASE to the new team. That should give them the necessary access to view the tables and metadata.
AZ
Azalee
1 year ago
Hmm, I'm a bit unsure about this one. I know we need to grant permissions, but I'm not sure if we should be using CATALOG or DATABASE in the command.
CO
Cora
1 year ago
This looks like a straightforward SQL permissions question. I think the key is to grant the necessary access to the new team on the entire database, not just a specific table.
SH
Shaun
1 year ago
This seems straightforward to me. The team needs access to the entire database, so the correct answer is option E - GRANT USAGE ON DATABASE customers TO team. I'm feeling good about that one.
SI
Silvana
1 year ago
I'm not totally sure about this one. The question mentions the team has its own group, so I'm wondering if we need to grant permissions the other way around, from the team to the customers. Option C looks interesting, but I'm not confident that's the right answer.
DA
Dacia
1 year ago
Okay, I think I've got this. The question is asking for a command to grant the team access to the entire database, not just the customers table. I'm going to go with option E - GRANT USAGE ON DATABASE customers TO team.
LA
Lavonda
1 year ago
Hmm, I'm a bit confused here. Do we need to grant permissions to the team on the entire database, or just on the customers table? The wording is a bit unclear.
RO
Ronnie
1 year ago
This looks like a straightforward SQL permissions question. I think the key is to grant the necessary access to the team on the entire database, not just a specific table or catalog.
JA
Jacob
1 year ago
I remember learning about IBM Rational Team Concert in one of my software engineering classes. It's an integrated development environment that includes version control, so that seems like the best answer here.
VI
Vivan
1 year ago
Okay, I think I've got this. The vendor is offering two different rebate amounts based on the quantity purchased, so selecting "exact match" for the unit of measure will make sure the right rebate is applied.
RE
Renato
1 year ago
Power Automate seems like the most logical choice here. It can handle the resume monitoring, parsing, and data storage into the Common Data Service without too much custom code.
MA
Marti
1 year ago
I'm pretty confident I know the answer to this one. It's going to be option D, "It will use the profile named 'Default'".
GA
Gary
1 year ago
If I recall, level-zero permissions don't require approval, while level-one permissions do. It's definitely a tricky topic.