ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-1072-20 All Questions

View all questions & answers for the 1z0-1072-20 exam
Go to Exam

Exam 1z0-1072-20 topic 1 question 37 discussion

Actual exam question from Oracle's 1z0-1072-20
Question #: 37
Topic #: 1
[All 1z0-1072-20 Questions]

You provisioned an Oracle Autonomous Data Warehouse (ADW) on Oracle Cloud Infrastructure (OCI) and imported data into ADW.
You want to give your business analyst the ability to connect to the ADW database and run queries.
Which two actions can help you meet this requirement? (Choose two.)

  • A. Create a database user account for the business analyst.
  • B. Grant the predefined database role DWROLE to the database user.
  • C. Grant unlimited tablespace privilege to the database user.
  • D. Grant the predefined database role DWADW to the database user.
  • E. Grant the predefined database role DWUSER to the database user.
Show Suggested Answer Hide Answer
Suggested Answer: BC 🗳️
Reference:
https://oracle.github.io/learning-library/oci-library/L100-LAB/Autonomous_Data_Warehouse/ADW_HOL.html
by alfonso_223 at Dec. 9, 2020, 2:08 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
alfonso_223
Highly Voted 4 years, 4 months ago
AB is a better choice. The requirement doesn't state that the analyst needs to upload data (for him to receive unlimited tablespace) but it would be a fair assumption that we need to create a user for him. https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/manage-users-privileges.html#GUID-50450FAD-9769-4CF7-B0D1-EC14B465B873
upvoted 12 times
...
FreeHK
Most Recent 3 years, 4 months ago
LMAO!! C!?? unlimited tablespace to run queries???
upvoted 1 times
...
bryanl
3 years, 6 months ago
Should be A & B. Granting unlimited tablespace is not wrong but this requirement was not spelled out hence it's not mandatory as opposed to A & B which is the fundamental steps to fulfil the needs as stated in the question
upvoted 3 times
...
eacunha
3 years, 8 months ago
A and B!!
upvoted 2 times
...
sayhitosuresh
3 years, 10 months ago
Going with the https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/manage-users-privileges.html#GUID-50450FAD-9769-4CF7-B0D1-EC14B465B873 B & C is the right .. Creating user should be outside the scope
upvoted 1 times
PietroC
3 years, 7 months ago
Give UNLIMITED TABLESPACE permission to a user is not a good idea. It's a permission thought for admins only. Users should be given quotas on pertinent tablespaces
upvoted 2 times
Anjanaraj
3 years, 7 months ago
is the exam quetions accurate . I have a week only so was relaing on this dump
upvoted 1 times
...
PietroC
3 years, 7 months ago
Moreover, the questions says the user has only to run queries, so he/she doesn't need to be given any quota, as quota are only used for DML (INSERT, DELETE, UPDATE, MERGE) or DCL (CREATE, DROP, ALTER segments)
upvoted 1 times
...
...
...
satyalanka
4 years, 1 month ago
a and B
upvoted 1 times
...
AmrWaly
4 years, 3 months ago
A & B are the most adequate solutions. there are no roles called DWADW or DWUSER in autonomous DB, and there is no need to grant unlimited tablespace as the user will not create any tables and will just query the data. at the end A and B are 2 complementary steps you need firstly to create user and then grant him access
upvoted 4 times
...
dreadsi3
4 years, 3 months ago
I think it is A B
upvoted 2 times
...
omid25
4 years, 3 months ago
Autonomous Data Warehouse databases come with a predefined database role named DWROLE. This role provides the privileges necessary for most database users. Here are the privileges it grants a user: A and B are correct
upvoted 4 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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago