Oracle Autonomous Database Cloud 2020 Specialist - 1Z0-931-20 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

What is the role of a Fleet Administrator in Autonomous Database (ADB) on Dedicated Infrastructure deployments?

A. Fleet administrators create, monitor and manage Autonomous Exadata Infrastructure and Autonomous Container Database resources. B. Fleet Administrators create, monitor and manage Autonomous Databases. C. Fleet Administrators are responsible for patching and backups of all container databases. D. Fleet Administrator defines and gains access to the ADMIN administrative user account for the database.

Discussion 0

Correct Answer: A Vote an answer

Question 2

Which two PL/SQL functions can be used to validate an analytic view? (Choose two.)

A. VALIDATE_ANALYTIC_VIEW B. VALIDATE_MEASURES C. VALIDATE_HIERARCHY D. VALIDATE_DIMENSION E. VALIDATE_LEVELS

Discussion 0

Correct Answer: A,C Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 3

Autonomous Data Warehouse configures and optimizes your database for you, therefore you do not need to perform some of the administration operations for configuring the database.
Which statement is true regarding the default configuration of the Autonomous Data Warehouse?

A. Compression is not enabled by default and you must specify the compression method for your tables with the compression clause in your CREATE TABLE and ALTER TABLE commands. B. In Autonomous Data Warehouse direct access to the database node and the local file system is allowed. C. Degree of parallelism for SQL statements is set based on the number of OCPUs in the system and the database service the user is connecting to. D. Adding, removing, or modifying tablespaces is allowed.

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 4

A Corporation is building a web application to allow its customers to schedule service requests online.
There is also a need to run operational reports at times during non-peak hours. The architecture team is debating whether such reports should be run on the OLTP database or in a separate data mart. The DBA Manager does not want to add anymore admin responsibility to the team and is looking for a database option that's low to zero maintenance, but meets their strict performance requirements as well.
Which Oracle Cloud Infrastructure database service is appropriate for this scenario?

A. It is best to build a separate data warehouse, and move the OLTP data on a nightly basis. B. ADW since operational reporting is a higher priority in this scenario. C. Since the application needs to be highly available, it should to be deployed on a Kubernetes Cluster. D. ATP. Using 'tpurgent' and 'high' TNS services to separate connection types.

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 5

Which two system privileges does a user need to create analytic views? (Choose two.)

A. CREATE ANALYTIC LEVEL B. CREATE ANALYTIC MEASURE C. CREATE ANALYTIC HIERARCHY D. CREATE ANALYTIC VIEW E. CREATE ATTRIBUTE DIMENSION

Discussion 0

Correct Answer: D,E Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 6

During the provisioning of an Autonomous Database on Dedicated hardware, what does the Database Administrator need to select to determine where the Autonomous Database is created on the Dedicated infrastructure?

A. the Compartment of the Dedicated infrastructure as each compartment only runs 1 Dedicated environment B. the Client Credentials wallet which is used to connect to the Autonomous Database C. the name or OCID of the Exadata infrastructure which was assigned by the the Fleet Administrator D. the 'High Availability Container Database' in which the Autonomous instance should run E. the Listener endpoint where the Autonomous Database should register on

Discussion 0

Correct Answer: B Vote an answer