Oracle Data Foundations

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

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

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

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

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 Lakehouse?. Autonomous Database. NoSQL Service. OCI Data Flow. Big Data Service.

What does the OCI Data Catalog primarily provide for data inthe Lakehouse in OCI?. Analytic enivronment. Metdata source of truth. Data Integration. Machine Learning. Converged Database.

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

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. A DBA must create APEX admin and APEX users first before starting APEX from OCI Console. 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 enable ORDS first.

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

A customer wants to use 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. Object Storage (standard). Block Volume. Archive Storage.

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

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

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

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

Which feature allows you to logically group and isolate your OCI resources?. Identity and Access Management Groups. Compartments. Tenancy. Availability Domains.

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

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

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

Which two are objectives of Oracle's Data Management strategy?. Offer multiple integration points for 3rd party databases that work better for mixed and analytic workloads. 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.

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

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

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

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

How does the Converged Database help to access data using an API?. 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. Each database comes with a REST-enabled compute instance toprovide access to data. The database provides only one universal REST interface which makes integration of applications extremely agile.

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

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

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

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

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

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

Which is NOT a resource type for NoSQL Database Cloud Service?. Nosql-rows. Nosql-indexes. Nosql-tables. Nosql-keys.

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

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

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

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

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 customers can perform which two tasks?. Operator Access Control can terminate Oracle operator connections. Allow only the Oracle Staff to perform control access. Allow network connections in the Oracle public cloud. Secure access configured to the customer network.

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

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

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

What are two characteristics of CI/CD?. It requires Liquibase. It introduces automation into all stages of app/database development. 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.