Database OCI Management Foundations

Which two target database environments provide both high availability (HA) and disaster recovery (DR) options in the cloud?. Streaming Service. Autonomous Database. Exadata Cloud Service. Compute VM.

After you have provisioned a virtual machine (VM) database (DB) system, what action can you take to meet changes in block storage requirements?. Only bare metal DB systems can increase block storage at any time without impacting the system. After you have provisioned a VM DB system, you cannot increase or decrease block storage. If a VM DB system has different requirements for block storage, increase or decrease the storage at any time without impacting the system. If a VM DB system requires more block storage, increase the storage at any time without impacting the system.

What is the FINAL release supporting the non-CDB architecture?. Oracle Database 23c. Oracle Database 19c. Oracle Database 21c. Oracle Database 18c.

What is the Oracle recommended way to upgrade databases?. Data Pump Export/Import. AutoUpgrade. Command Line Upgrade. Database Upgrade Assistant (DBUA).

What is a main feature of APEX's low code platform?. Limited productivity. Build scalable web apps for MongoDB. Simplified core-based licensing. Use traditional computer programming paradigms. Use graphical interfaces and configuration for building web applications.

Which two are objectives of Oracle's Data Management strategy?. Provide the best platform for warehouse workloads only. Provide for the fastest, most scalable converged SQL database. Automate everything for developers, data analysts, DBAs and data scientists. Offer multiple integration points for 3rd party databases that work better for mixed and analytic workloads.

Which two are key characteristics of Oracle Autonomous Database?. Less automated. Higher cost. Oracle manages everything. Lower cost. Customer manages everything.

Which statement can be detected by monitoring of access to sensitive data?. SELECT SYSDATE from DUAL;. CREATE index emp_id_idx on EMPLOYEES(emp_id);. UPDATE quarter_reference set Q1='012022'. SELECT * from EMPLOYEES;.

What is the primary goal of Oracle Maximum Availability Architecture for customer systems?. Data Protection, access and reporting. Active Replication, Data Protection and continuous availability. Scale out, application availability and protection. Continuous Availability, network security and failover.

How can the goal of scale out high availability be achieved?. By provisioning nodes with Real Application Clusters. By using the Zero Data Loss Recovery Appliance. By implementing Active Data Guard. By implementing Flashback.

NoSQL Database Cloud Service supports all three types of big data. Which is NOT considered big data?. unstructured data. free-structured data. semi-structured data. structured data.

What set of NoSQL-style APIs can be used in Autonomous JSON Database?. SODA (Simple Oracle Document Access). OASD (Oracle Application Storage Definition). OSDA (Oracle Simple Document Access). DOSA (Document Open Solution Access).

A customer is looking to migrate their old database backups from their on-premises data center to Oracle Cloud Infrastructure (OCI). Which OCI service is the most cost-effective?. File Storage. Object Storage (standard). Block Volume. Archive Storage.

Which Oracle Cloud Infrastructure (OCI) Identity and Access Management (IAM) capability helps you to organize multiple users into teams?. Users. Policies. Roles. Groups.

Which two methods can you use to create or modify Oracle Cloud Infrastructure (OCI) resources?. Serial console connection (SCC). OCI Command-line Interface (CLI). Remote Desktop Protocol (RDP). Secure Shell (SSH). OCI REST APIs.

The Supply Side is data that is passive and means something. What two models and libraries are included in the supply side?. Domain objects. Reports. Technical definitions of business terms. Business rules.

The Demand Side is data that is active and does something. What two data services are typically part of the demand side?. Data Models. Inert algorithms. Authorization. Payloads.

Which Lakehouse service should you use for serverless Spark processing?. OCI Object Storage. Oracle Analytics Cloud. OCI Data Catalog. OCI Data Flow.

Lakehouse on Oracle Cloud Infrastructure (OCI) is the premier platform for analyzing any data for any insights. Which is NOT a component of this solution?. Oracle E-Business Suite. Oracle Autonomous Data Warehouse. OCI Big Data Service. OCI Data Catalog. OCI Data Flow.

The Oracle Cloud Infrastructure (OCI) Data Catalog is an integral part of the Lakehouse solution. What level of data detail does Data Catalog provide when integrated with Autonomous Databases and Object storage?. Analytic environments. Data Warehouse. Source of managed services. View of data for discovery.

Which Oracle Cloud Infrastructure storage platform is used by MySQL Database Service for all data storage?. File Storage. Flash Local Storage. Block Volume Storage. Object Storage. Archive Storage.

You have stopped the HeatWave cluster. Which two statements are correct?. Billing will continue for the HeatWave cluster. The HeatWave cluster stop action will also stop DB System. The data loaded in HeatWave cluster memory is lost. The HeatWave cluster data will remain loaded. Billing will stop for the HeatWave cluster.

Which three are prerequisites for using the MySQL Database Service?. You or your group must be granted the policies described in Mandatory Policies. You must create a compartment to store your resources. You must download the latest MySQL version from https://edelivery.oracle.com/. You must install the downloaded MySQL version onto Oracle Cloud Infrastructure. You must create a tenancy and be able to sign in to it.

Which three can be selected when using the console to create an autonomous database on an Autonomous Exadata Cloud@Customer?. amount of database OCPUs required. amount of database storage required. client network. workload type. size of the shared global area (SGA) to use.

Exadata is the integration of the software and hardware and is available to customers on which deployments?. only at the customer site. only in public cloud environments. only in a hybrid cloud. in the Oracle Cloud and customer site.

When Customers are using the Exadata Cloud Service, what are they responsible for managing?. Databases and Customer VM. Host VM and Storage. Internal Fabric and Customer VMs. Hypervisor and Internal Fabric.

How does the Converged Database help to access data using an API?. Each database comes with a REST-enabled compute instance to provide access to data. Developers can point their application to the location of ADB Wallet which integrates all REST API calls. A REST API is automatically generated on top of SQL or stored procedures. The database provides only one universal REST interfaces which makes integration of applications extremely agile.

What are two main benefits of Oracle APEX?. Rapidly develop, customize, and deliver secure applications. Faster development time using hand coding. Store data in PL/SQL objects. Less productivity compared to hand coding. Develop responsive web apps.

What are the two main features of APEX's low code platform?. Use traditional computer programming paradigms. Simplified core-based licensing. Limited productivity. Use graphical user interfaces and configuration. Build scalable web apps for MongoDB. Focus on business requirements.

Which are two characteristics of Autonomous Transaction Processing (ATP)?. Optimized for response time. Statistics are gathered as part of bulk load operations. Focuses on creation of indexes. Creates autonomous data summaries. Stores data in columnar format.

What is NOT a feature of the Oracle Autonomous Database to protect data from external and internal threats?. Protects data from admin snooping using Database Vault. Security updates are applied online. Admin passwords are disabled after provisioning. Data is encrypted.

What are two typical reasons why customers CANNOT move their database into the public cloud?. Public cloud does not provide storage for more than 10TB. Putting data in the cloud would break data residency rules. Total Cost of Ownership in public cloud is higher than on-premises. Regulations that prevent moving data into the public cloud.

Which two statements about ORDS are true?. ORDS makes REST APIs in the Oracle Database available. ORDS stores, manages and indexes JSON documents. ORDS is a low code development platform to build responsive applications. ORDS creates servlets for the Data Dictionary.

Which is NOT an option in Database Actions to load data into Autonomous Database?. Load data from a remote database. Load data from cloud storage (Oracle, S3, Azure, Google). Load data using Data Pump. Load data from a local file such as text or Excel. Load data using FTP.

What is NOT a workload that can be selected when provisioning an Autonomous Database?. JSON. APEX. Data Warehouse. MySQL.

What are three platforms where Oracle's Autonomous Database service can be deployed?. AWS Cloud at Customer. Dedicated Region Cloud at Customer. Hybrid Cloud Configurations. Oracle Cloud Infrastructure. Oracle Public Cloud at Customer.

Which workload CANNOT be run on Oracle Database 19c?. Machine Learning. Gaming. Translytical. Hadoop Clusters.

Oracle Automated Machine Learning (AutoML) has options for using in-database and opensource algorithms. Which is an example of an in-database option?. REST Interface. Cognitive text. Tuning of hyperparameter. Oracle Machine Learning for Python (OML4Py) APIs.

Which statement is true about moving virtual machine (VM) database (DB) systems from one compartment to another?. You can move DB systems to a different compartment if you have sufficient access permissions to the compartment that the resource is being moved to, as well as the current compartment. You can move VM DB systems from one compartment to another by only using Oracle Cloud Infrastructure REST APIs. You have to move dependent resources like Database Homes and databases to the destination compartment before moving the VM DB system. You do not need access permissions to the compartment that the resource is being moved to when moving VM DB systems to a different compartment.

What are two important reasons to upgrade and patch?. Support Compliance. Security. Restructure the database. Validation of application.

Which three data file formats can be loaded using Oracle Database Actions?. JSON. CSV. AVRO. VSAM.

Oracle Maximum Security Architecture is used for data that requires something higher than normal baseline security. Which two controls added to the baseline security apply to maximum security architecture?. Database Firewall. Strong passwords. Privilege Analysis. Network Encryption. Database Vault.

What are two characteristics of Oracle SQLCI (SQL Developer Command Line)?. Available in the OCI Cloud Shell by default. Creates isolated development environments. Ability to execute SQL batch files. Tracks database schema changes.

Which Oracle Cloud Infrastructure (OCI) service is NOT available as part of Oracle Cloud Free Tier?. Autonomous Data Warehouse. Compute. Exadata DB Systems. Monitoring.

Where should you store unstructured, high volume data sets of unknown value for best price/performance?. OCI Object Storage. OCI Data Flow. OCI Data Catalog. OCI GoldenGate.

Oracle Data Lakehouse streamlines the integration, storage, and processing of data. Which two services are used for persistence of the data in Lakehouse?. OCI Data Catalog. OCI Object Storage. OCI GoldenGate. Autonomous Database.

Which service is used by default by the MySQL Database Service to store user data to make it more resistant to failures?. OCI Data Safe. OCI Object Storage. O OCI Block Volumes. OCI File Storage.

Which two are key features of MySQL Database Service?. Integration with Oracle Technologies: Uses a client's existing Oracle investments and easily integrates MySQL Database Service with Oracle technologies. Regulatory Compliance: Uses advanced security to help clients meet industry and regulatory compliance requirements, including GDPR, PCI, and HIPPA. Interactive Documents: Uses a built-in web-based notebook tool for designing and sharing SQL-based data-driven scripts. In-Memory Lookups: Avoids unnecessary I/O operations by replacing storage indexes with a few in-memory lookups.

Which security measure is implemented out-of-the-box, and is included if you are not using BYOL licensing with Exadata Cloud@Customer?. Database Vault and Data Masking Pack. Audit Vault and Database Firewall. Oracle Key Vault. Oracle Native Network Encryption and TDE (Transparent Data Encryption).

New hardware innovations of the Exadata X8M allow customers to take advantage of Remote Direct Memory Access (RDMA). What resource does RDMA access?. Persistent Memory. Storage Disks. Compute Instances. Database Servers.

Which tool is provided to support Continuous Integration/Continuous Deliver (CI/CD) workflows?. Database Actions (including real time SQL monitor). SQLcl (including Liquibase). ADB console (including Performance Hub). SQL Developer (including ADB wallet).

What connections to multiple public clouds are provided through 3rd party connectivity?. FastConnect and Direct Connect. Layer 3 and FastConnect. Megaport Cloud Router (MCR) and Virtual Cross Connect (VXC). Virtual Cloud Networks (VCNS) and Amazon Virtual Private Cloud (VPC).

Oracle Cloud and Microsoft Azure have an interconnect for workloads across cloud. Which two are also benefits this partnership and interconnect provide?. Low Latency. Unified identity and access management. Connection to other multicloud environments. Upgrade compliance.

Which are two characteristics of Autonomous Data Warehouse (ADW)?. Focuses on creation of indexes. Statistics are gathered as part of DML operations. Creates data summaries. Stores data in row format. Optimized for complex SQL.

What is a prerequisite of running APEX on an Autonomous Database?. APEX can only be used when selecting APEX as a workload when provisioning an Autonomous Database. An Autonomous Database with the workload type Data Warehouse, Transaction Processing, JSON or APEX. APEX can simply be installed by downloading the executable from OTN. A DBA must create APEX admin and APEX users first before starting APEX from Oracle Cloud Infrastructure Console. A DBA must enable ORDS first.

What three typical data types/models are covered by Oracle's Converged Database?. Events. Graph. Images. Spatial. Relational. Notifications. Terraform.

Which statement is true about MySQL Database Service?. It is a fully managed Oracle Cloud Infrastructure (OCI) native service. Its users are responsible for database and operating system patching tasks. It supports MySQL Enterprise Edition version 5.7 with InnoDB Storage Engine. It is a public cloud service built on MySQL Community Edition.

Which two statements are true regarding MySQL Database Service HeatWave?. HeatWave uses periodic long-running ETL batch jobs to refresh the data. HeatWave uses machine learning to automate operations, increasing DBA productivity and reducing costs. HeatWave is a in-memory, query-processing engine designed for fast execution of analytic queries. HeatWave data which is needed for analytic processing is stored in disk files.

Which tool allows users to execute SQL statements, create relational models, load data, and monitor SQL queries from your browser?. Database Actions. OCI Operational Insights. Enterprise Manager. Service Console. SQL Developer.

When should you change COMPATIBLE?. When the database is stopped. After database downgrades. After patching. After upgrades.

What does the Oracle Cloud Infrastructure (OCI) Data Catalog primarily provide for data in the Lakehouse on OCI?. Converged Database. Data Integration. Analytic environment. Metdata source of truth. Machine Learning.

Oracle Lakehouse provides extensive data processing capabilities, to accommodate the migration of existing architectures or the creation of new, agile ones. Which service does NOT provide data processing on Oracle Cloud Infrastructure (OCI) Lakehouse?. Autonomous Database. Big Data Service. NoSQL Service. OCI Data Flow.

Oracle ExaC@C brings the Oracle Cloud to the customer data center. The Oracle Cloud Infrastructure is the same, but responsibilities are adjusted so that customer can perform which two tasks?. Allow only the Oracle Staff to perform control access. Allow network connections in the Oracle public cloud. Secure access configured to the customer network. Operator Access Control can terminate Oracle operator connections.

Multicloud strategy eliminates the reliance of a single cloud provider but also provides which two advantages?. Workload utilization of specific services. Duplication of data and applications. Ability to have private clouds and maintain customer data centers. Compliance for use of specific geographies for data sovereignty laws.

In order to support multicloud strategies, what is offered as an industry first by Oracle?. Cloud databases. Oracle FastConnect. Dedicated cloud region. Private and public cloud network.

Which two locations can be used to store your DB system database backups?. You can store your DB system database backups locally in the Fast Recovery Area of the DB system. You can store your DB system database backups on locally attached block storage volumes. You can store your DB system database backups in on-premises local storage. You can store your DB system database backups in Oracle Cloud Infrastructure Object Storage.

Which Oracle Cloud Infrastructure (OCI) service is NOT available for provisioning in your tenancy as an Always Free resource?. Autonomous Database (up to two database instances). Fast Connect (1 Gbps public peering). Block Volume (up to 100 GB total storage). Load Balancing (one load balancer).

Which two statements are true when deciding which Oracle Cloud Infrastructure (OCI) region to register an Exadata Cloud@Customer infrastructure in?. Exadata Cloud@Customer is hosted in a customer data center so the Exadata infrastructure is not registered in an OCI region. Consider which availability domain (within the region) to create the Exadata Cloud@Customer infrastructure in. The Exadata Cloud@Customer region can be changed after the infrastructure is created. Consider any business policies or regulations that preclude the use of a particular region. Consider the physical proximity of the region you register the infrastructure in to your data center.

What are two characteristics of CI/CD?. It introduces automation into all stages of app/database development. It requires Liquibase. Development changes are automatically tested on push/commits and merges. It prevents developers from merging their code changes back to the shared branch for security.

What security control area determines if there is sensitive data in a system?. Users. Protect. Detect. Assess.

Which ability is NOT provided out of the box with the Autonomous Database Tools set?. Data Labeling. Cataloging. Data Insight. Data Loading.

The DBA has determined that number of OCPU assigned to an Autonomous Database does not provide sufficient performance. Which option does the DBA have in this case?. Open the database in OCI Console and increase the number of OCPU. No downtime required. No downtime is required as number of OCPU can be increased from OCI console, but users have to be informed that they must not use any application for at least one hour. Call Oracle Cloud Support and raise a request to increase number of OCPU. Expect a downtime of approximately one hour. Plan for a one-hour downtime and increase the number of OCPU while database is offline.

What information is required to connect to the NoSQL Database Cloud Service?. API signing key, admin ID, user ID. user ID, tenancy ID, component ID. tenancy ID, passphrase, handshake key. signing key fingerprint, API signing key, tenancy OCID.

Which deployment option provides the highest degree of security and governance while providing a completely self-service database experience?. Oracle Autonomous Database. Exadata Cloud Service. Oracle Database Cloud Service. Oracle MySQL Database Service.

A customer wants to use Oracle Cloud Infrastructure (OCI) for storing application backups which can be stored for months, but retrieved immediately based on business needs. Which OCI storage service can be used to meet this requirement?. File Storage. Block Volume. Object Storage (standard). Archive Storage.

Which is NOT a key to successful database upgrades?. Download and install Oracle 19c. Download and install newest RU. Enable Performance Stability with SPM, STA, and RAT. Download and use AutoUpgrade. Download and install Oracle 21c.

In what two ways does Oracle Cloud Infrastructure (OCI) offer industry leading price-performance?. OCI hypervisor provides industry leading performance. OCI leverages advanced encryption that results in fast performance. With OCI, pricing is low and predictable across all regions and services. OCI does not over subscribe CPU, but only memory. OCI backs performance claims with Service Level Agreements.

What does ORDS stand for?. Oracle REST Data Services. Oracle Resilient Data Security. Oracle REAP Diagnosis Systems. Oracle Rapid Data Systems.