1. Which statement is true about MySQL Database Service?
It supports MySQL Enterprise Edition version 5.7 with InnoDB Storage Engine.
It is a fully managed Oracle Cloud Infrastructure (OCI) native service.
It is a public cloud service built on MysOL Community Edition.
Its users are responsible for database and operating system patching tasks.
2. Which Oracle Cloud Infrastructure storage platform is used by MySQL Database Service for all data storage?
Block Volume Storage
Archive Storage
Object Storage
File Storage
Flash Local Storage
3. Which two are key features of MySQL Database Service?
In-Memory Lookups: Avoidsunnecessary 1/O operations by replacina storageindexes with a few in-memory lookups
Regulatory Compliance: Uses advanced security to help clients meet industry and regulatory compliance requirements, including GDpR, Pcr, and HIPPA
Interactive Documents: Uses a built-in web-based notebook tool for designing and sharing SOL-based data-driven scripts
Integration with Orace Technologies: Uses a client's existing Oracle invetments and easily integrates MySOL Database Service with Oracle technologies
4. 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 Block Volumes
OCI Data Safe
OCI Object Storage
5. Which two statements are true regarding MySQL Database Service HeatWave?
HeatWave data which is needed for analytic processing is stored in disk files.
HeatWave is a in-memory, query-processing engine designed for fast execution of analytic queries
HeatWave uses machine learning to automate operations, increasing DBA productivity and reducing costs.
HeatWave uses periodic long-running ETL batch jobs to refresh the data.
6. 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 thesystem.
If a VM DB system has different requirements for block storage, increase or decrease thestorage at any time without impacting the system.
If a VM DB system requires more block storage, increase the storage at any time withoutimpacting the system.
After you have provisioned a VM DB system, you cannot increase or decrease block storage.
7. Which is NOT a prerequisite for patching Grid Infrastructure or database homes when using the console?
8. Which two target database environments provide both high availability (HA) and disaster recovery (DR) options in the cloud?
Autonomous Database
Compute VM
Streaming Service
Exadata Cloud Service
9. What connections to multiple public clouds are provided through 3rd party connectivity?
Layer 3 and FastConnect
Virtual Cloud Networks (VCNs) and Amazon Virtual Private Cloud (VPc)
FastConnect and Direct Connect
Megaport Cloud Router (MCR) and Virtual Cross connect (VXC)
10. Multicloud strategy eliminates the reliance of a single cloud provider but also provides which two advantages?
Ability to have private clouds and maintain customer data centers
Duplication of data and applications
Compliance for use of specific geographies for data sovereignty laws
Workload utilization of specific services
11. Where should you store unstructured, high volume data sets of unknown value for best price/performance?
OCI Data Catalog
OCI Object Storage<<
OCI GoldenGate
OCI Data Flow
12. What does the Oracle Cloud Infrastructure (OCI) Data Catalog primarily provide for data in the Lakehouse on OCI?
Metdata source of truth <<<
Machine Learning
Data Integration
Analytic environment
Converged Database
13. 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?
Data Warehouse
Analytic environments
View of data for discovery《《
Source of managed services
14. Which Lakehouse service should you use for serverless Spark processing?
OCI Data Catalog
OCI Object Storage
Oracle Analytics Cloud
OCI Data Flow
15. 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
OCI Data Flow
NoSQL Service
Big Data Service
16. What are three platforms where Oracle's Autonomous Database service can be deployed?
Hybrid Cloud Configurations
Oracle Cloud Infrastructure
Oracle Public Cloud at Customer
AWS Cloud at Customer
Dedicated Region Cloud at Customer
17. Which workload CANNOT be run on Oracle Database 19c?
Machine Learning
Translytical
Hadoop Clusters
Gaming 《《
18. What is the Oracle recommended way to upgrade databases?
Database Upgrade Assistant (DBUA)
AutoUpgrade
Data Pump Export/Import
Command Line Upgrade
19. What are two important reasons to upgrade and patch?
Support compliance
Security
Restructure the database
Validation of application
20. When should you change COMPATIBLE?
After patching
When the database is stopped
After database downgrades
After upgrades
21. What set of NoSQL-style APIs can be used in Autonomous JSON Database?
OSDA (Oracle Simple Document Access)
SODA (Simple Oracle Document Access)
OASD (Oracle Application Storage Definition)
DOSA(Document Open Solution Access)
22. Which deployment option provides the highest degree of security and governance while providing a completely self-service database experience?
Oracle Database Cloud Service
Exadata Cloud Service
Oracle MySQL Database Service
Oracle Autonomous Database
23. What is NOT a feature of the Oracle Autonomous Database to protect data from external and internal threats?
Data is encrypted
Security updates are applied online
Protects data from admin snooping using Database Vault
Admin passwords are disabled after provisioning
24. 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
Total Cost of ownership in public cloud is higher than on-premises
Putting data in the cloud would break data residency rules
Regulations that prevent moving data into the public cloud
25. Which are two characteristics of Autonomous Transaction Processing (ATP)?
Stores data in columnar format
Creates autonomous data summaries
Optimized for response time
Focuses on creation of indexes
Statistics are gathered as part of bulk load operations
26. What is NOT a workload that can be selected when provisioning an Autonomous Database?
APEX
Data Warehouse
JSON
MySQL
27. Which two are key characteristics of Oracle Autonomous Database?
Customer manages everything
Less automated
Oracle manages everything
Lower cost
Higher cost
28. Which two are objectives of Oracle's Data Management strategy?
Provide for the fastest, most scalable converged SQL database.
Offer multiple integration points for 3rd party databases that work better for mixed and analyticworkloads.
Provide the best platform for warehouse workloads only.
Automate everything for developers, data analysts, DBAs and data scientists.
29. 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
30. New hardware innovations of the Exadata X8M allow customers to take advantage of Remote Direct Memory Access (RDMA). What resource does RDMA access?
Storage Disks
Persistent Memory
Compute Instances
Database Servers
31. 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?
Secure access configured to the customer network.
Allow only the Oracle Staff to perform control access.
Allow network connections in the Oracle public cloud.
Operator Access Control can terminate Oracle operator connections.
32. Which two statements about ORDS are true?
ORDS stores, manages and indexes jsON documents.
ORDS is a low code development platform to build responsive applications.
ORDS makes REST APIs in the Oracle Database available.
ORDS creates servlets for the Data Dictionary.
33. What security control area determines if there is sensitive data in a system?
Users
Detect
Assess
Protect
34. 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?
Strong passwords
Database Firewall
Database Vault
Network Encryption
Privilege Analysis
35. 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
Oracle Machine Learning for Python (OML4Py)
APISTuning of hyperparameter
36. Which Oracle Cloud Infrastructure (OCI) service is NOT available as part of Oracle Cloud Free Tier?
Autonomous Data Warehouse
Compute
Monitoring
Exadata DB Systems
37. What are two main benefits of Oracle APEX?
Faster development time using hand coding
Less productivity compared to hand coding
Develop responsive web apps
Rapidly develop,customize, and deliver secure applications
Store data in PL/sQL objects
38. What are the two main features of APEX's low code platform?
Limited productivity
Simplified core-based licensing
Use graphical user interfaces and configuration
Build scalable web apps for MongoDB
Use traditional computer programming paradigms
Focus on business requirements
39. Which three data file formats can be loaded using Oracle Database Actions?
CSV
AVRO
VSAM
JSON
40. What is a main feature of APEX's low code platform?
Use traditional computer programming paradigms
Use graphical interfaces and configuration for building web applications
Limited productivity
Simplified core-based licensing
Build scalable web apps for MongoDB
41. Which feature allows you to logically group and isolate your Oracle Cloud Infrastructure resources?
Identity and Access Management Groups
Tenancy
Availability Domain
Compartments
42. What are two characteristics of Oracle SQLcl (SQL Developer Command Line)?
Available in the ocr cloud Shell by default
Tracks database schema changes
Creates isolated development environments
Ability to execute SQL batch files
44. 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.
The database provides only one universal REST interfaces which makes integration ofapplications extremely agile.
Developers can point their application to the location of ADB Wallet which integrates all RESTAPI calls.
A REST API is automatically generated on top of SQL or stored procedures.
45. The Supply Side is data that is passive and means something. What two models and libraries are included in the supply side?
Reports
Technical definitions of business terms
Domain objects
Business rules
46. The Demand Side is data that is active and does something. What two data services are typically part of the demand side?
Inert algorithms
Authorization
Payloads
Data Models
47. 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 isnot registered in an OCl region.
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 the physical proximity of the region you register the infrastructure in to your datacenter.
Consider which availability domain (within the region) to create the Exadata cloud@customerinfrastructure in.
48. 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
size of the shared global area(SGA) to use
amount of database storage required
workload type
client network
49. 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
52. Which Oracle Cloud Infrastructure (OCI) Identity and Access Management (IAM) capability helps you to organize multiple users into teams?
Which component is NOT included as part of an Oracle NoSQL table Oracle Cloud Identifier (OCID)?
Compartment ID
Resource type
Unique ID
Region
Which is NOT an option in Database Actions to load data into Autonomous Database?
55. Which tool allows users to execute SQL statements, create relational models, load data, and monitor SQL queries from your browser?
