Oracle Autonomous Database Cloud 2024 Professional (1z0-931-24) Free Questions - Part 8
Question No : 106) You are requested to analyze a year's stock purchase data which is stored in Autonomous Data Warehouse instance. Which tool would you use to automate data exploration and create pivot tables?
A. Business Models
B. Data Load
C. SQL Developer Web
D. APEX
Question No : 107) When running lots of high concurrent queries in Autonomous Database, you should use which predefined service connection? (Choose the best answer.)
A. DBNAME_MEDIUM
B. DBNAME_HIGH
C. DBNAME_CONCURRENT
D. DBNAME_LOW
Question No : 108) A customer wants to increase the throughput of their inserts. They have discovered that the bottleneck is in the storage I/Os of their environment. What should they do to remove this bottleneck?
A. Run the DBMS_CLOUD.INCREASE_THROUGHPUT procedure.
B. Remove any non-JSON data from the database.
C. Increase the number of OCPUs allocated to the database.
D. Ask Support to migrate their setup to a node without noisy neighbors.
Question No : 109) While Autonomous Transaction Processing and Autonomous Data Warehouse use the same Oracle database, which statement is true about the workloads?
A. Autonomous Transaction Processing memory usage optimizes workloads for parallel joins and aggregations.
B. Autonomous Data Warehouse workloads are optimized for mixed workloads.
C. Autonomous Transaction Processing workloads are optimized for data warehouse, data mart, and data lake.
D. Data that is bulk loaded, by default, uses the row format in Autonomous Transaction. Processing where Autonomous Data Warehouse data format is columnar.
Question No : 110) When enabling auto-scaling, which three options do not change?
A. Number of OCPUs displayed in the console.
B. Amount of storage
C. I/O resources
D. parallelism settings
E. Level of concurrency
Question No : 111) According to Oracle documentation, it is a best practice when planning and instituting Access Controls for your Autonomous Dedicated environment regarding Subnets, Compartments and User Groups. Which statement is true?
A. Create a separate VCN that contains only public subnets
B. Only 1 of each is allowed to be allocated per environment.
C. Only 1 Subnet and 1 Compartment are allowed, multiple Groups highly advised.
D. Create at least 2 of each resource
Question No : 112) Which two license types does the customer need to benefit from BYOL when leveraging on-premise Enterprise Database licenses in Oracle Autonomous Database?
A. Exadata
B. Active Data Guard
C. RAC, but only when scaling beyond 16 OCPUs
D. Transparent Data Encryption
E. Multitenant
1z0-931-24 Answers