Oracle Cloud Data Management Foundations

 

Which two self-service tools are available with the Autonomous Database?

 

• Oracle Machine Learning 
• Low-Code App Dev, APEX 
• Encryption only in Object Storage
• Business Objects

Question

Which two statements are true about the Autonomous Database?

 

• Indexes are added manually only after recommendations.
• Running of complex applications, such as Siebel, is not available.
• It has self-service tools for analytics and data access. 
• Auto-scaling is based on workloads. 

 

Question

Which two statements are true about a converged Database?

 

• It supports graph and spatial workloads. 
• It does not support analytical workloads.
• It requires a dedicated hardware.
• It supports both structured and unstructured data types. 

Question

Which two interconnect solutions are available to connect Oracle Cloud to other cloud providers?

 

• Cloud Router 
• Virtual Private Cloud
• FastConnect 
• Virtual Cloud Network

 

Question

Which three are required for provisioning an Oracle Autonomous Database instance?

 

• workload type 
• number of tablespaces
• database name 
• number of CPUs 
• backup location FRA size

 

Question

Which two statements are true about Autonomous Transaction Processing?

 

• Missing indexes are detected and created.
• Data is stored in columnar format.
• Data is stored in row format.
• Complex SQL queries are optimized.

Question

Which two actions can be performed from the OCI Console for an Oracle Autonomous Database?

 

• Scale up or scale down memory.
• Increase network bandwidth.
• Scale up or scale down the CPU.
• Increase the storage allocated for the database.

 

Question

Which statement is true about Autonomous Transaction Processing?

 

• Data is stored in columnar format.
• It is used for analytic workloads.
• It is used for OLTP and mixed workloads. 
• It is used with data marts and machine learning.

 

Question

Which three capabilities of Oracle Autonomous Database can accelerate innovation?

 

• built-in AI and ML, which help find patterns that can identify undiscovered anomalies 
• provisioning a data warehouse in seconds 
• scaling of CPUs with very little down time
• instant scaling of storage 

Question

Which is the recommended method to upgrade databases?

 

• Manual upgrade
• Upgrading the database is not recommended
• Data Pump Export/Import
• AutoUpgrade 

Question

In which release is the non-CDB architecture supported?

 

• Oracle Database 20c
• Oracle Database 18c
• Oracle Database 21c
• Oracle Database 19c

Question

What is the most important reason for upgrading and patching a database?

 

• Restructure the database
• Upgrading and patching the database is not important.
• Fix bugs
• Security

Question

Which migration type uses Data Pump and GoldenGate tools?

 

• Logical Migration
• Physical Migration
• Direct Connection
• Indirect Connection

Question

Which is NOT the responsibility of a customer in a simple cloud management model?

• Manage database servers and VM hosts.
• Control access to customer VMs.
• Subscribe to database servers.
• Manage everything inside the database.

Question

Which update is Oracle’s responsibility for the maintenance of Exadata Cloud Service?

 

• Grid Infrastructure
• Infrastructure Updates 
• Exadata OS Updates
• Database Updates

Question

Which are two advantages of Oracle Databases on Virtual Machines?

 

• run only OLTP database workloads
• provisioned with block storage
• lower cost with pay-per-use
• provide dedicated resources

Question

Which two are management interfaces for Exadata Cloud Service?

 

• OCI Console
• Oracle Cloud Rest APIs 
• Oracle Cloud Web-Based UI 
• SQL Worksheet

 

Question

Which two statements are true about the default configuration for automatic database backups?

 

• The retention period is set at 14 days.
• Archive redo log files are backed up every 30 minutes. 
• Backups occur weekly
• Backups are executed in the primary site. 

Question

Which two statements describe HeatWave Clusters?

 

• Restarting will only make the existing data available again.
• It is exclusively available in OCI. 
• It has an in-memory engine for fast execution of analytic queries. 
• Stopping Heatwave Clusters continues billing because of the data.

Question

 

Which are two responsibilities of a developer or user when managing NoSQL Database Cloud Service?

 

• replication across multiple availability domains
• application development
• setting roles and privileges 
• installation of software and updates

Question

 

Where is the data stored in MySQL Database?

 

• Block Volumes 
• Storage Management
• Object Storage
• File systems

Question

Which command for the MySQL Data Service will resume OCPU billing?

 

• Stop
• Restart 
• Start
• Backup

 

Question

Which component is not included in a MySQL Database Service DB System?

 

• Block Storage
• Compute Instance
• FastConnect 
• Virtual Network Interface