Oracle Cloud Infrastructure 2020 Architect Associate — Question 17

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

Answer options

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

Correct answer: B, C

Explanation

The correct actions are to grant the predefined database role DWROLE to the database user and provide unlimited tablespace privilege. Granting DWROLE ensures the user has the necessary permissions to run data warehouse operations, while unlimited tablespace privilege allows for sufficient storage space for the user’s queries. The other options either do not provide the required access or are not relevant for enabling query capabilities.