nerdexam
Oracle

1Z0-1072-20 · Question #243

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…

The correct answer is B. Grant the predefined database role DWROLE to the database user. C. Grant unlimited tablespace privilege to the database user. https://oracle.github.io/learning-library/oci-library/L100- LAB/Autonomous_Data_Warehouse/ADW_HOL.html

Implement OCI Database

Question

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.)

Options

  • ACreate a database user account for the business analyst.
  • BGrant the predefined database role DWROLE to the database user.
  • CGrant unlimited tablespace privilege to the database user.
  • DGrant the predefined database role DWADW to the database user.
  • EGrant the predefined database role DWUSER to the database user.

How the community answered

(50 responses)
  • A
    10% (5)
  • B
    74% (37)
  • D
    4% (2)
  • E
    12% (6)

Explanation

https://oracle.github.io/learning-library/oci-library/L100- LAB/Autonomous_Data_Warehouse/ADW_HOL.html

Topics

#ADW user management#DWROLE#database roles#tablespace privileges

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 1Z0-1072-20 Practice