Oracle Cloud Data Management 2023 Foundations Associate (1Z0-1105-23)

Esta é uma pré-visualização de arquivo. Entre para ver o arquivo original

==== Test: Skill Check: Data Management Introduction ====
1. Which two statements are true about the Autonomous Database?
Auto-scaling is based on workloads. (*)
It has self-service tools for analytics and data access. (*)
2. Which two self-service tools are available with the Autonomous Database?
Oracle Machine Learning (*)
Low-Code App Dev, APEX (*)
3. Which two interconnect solutions are available to connect Oracle Cloud to other cloud providers?
FastConnect (*)
Cloud Router (*)
4. Which two statements are true about a converged Database?
It supports graph and spatial workloads. (*)
It supports both structured and unstructured data types. (*)
 =============== Autonomous Database (ADB) =============== 
1. Which statement is true about Autonomous Transaction Processing?
It is used for OLTP and mixed workloads. (*)
2. Which two statements are true about Autonomous Transaction Processing?
Data is stored in row format. (*)
Missing indexes are detected and created. (*)
3. Which three capabilities of Oracle Autonomous Database can accelerate innovation?
built-in AI and ML, which help find patterns that can identify undiscovered anomalies (*)
instant scaling of storage (*)
provisioning a data warehouse in seconds (*)
4. Which two actions can be performed from the OCI Console for an Oracle Autonomous Database?
Scale up or scale down the CPU. (*)
Increase the storage allocated for the database. (*)
5. Which three are required for provisioning an Oracle Autonomous Database instance?
number of CPUs (*)
database name (*)
workload type (*)
======= Exadata & Database Cloud Service (DBCS) =======
1. Which two statements are true about the default configuration for automatic database backups?
Archive redo log files are backed up every 30 minutes. (*)
Backups are executed in the primary site. (*)
2. Which is NOT the responsibility of a customer in a simple cloud management model?
Manage database servers and VM hosts. (*)
3. Which are two advantages of Oracle Databases on Virtual Machines?
lower cost with pay-per-use (*)
provisioned with block storage (*)
4. Which two are management interfaces for Exadata Cloud Service?
Oracle Cloud Web-Based UI (*)
Oracle Cloud Rest APIs (*)
5. Which update is Oracle’s responsibility for the maintenance of Exadata Cloud Service?
Infrastructure Updates (*)
======= MySQL and NoSQL =========
1. Which are two responsibilities of a developer or user when managing NoSQL Database Cloud Service?
setting roles and privileges (*)
application development (*)
2. Which component is not included in a MySQL Database Service DB System?
FastConnect (*)
3. Where is the data stored in MySQL Database?
Block Volumes (*)
4. Which two statements describe HeatWave Clusters?
It is exclusively available in OCI. (*)
It has an in-memory engine for fast execution of analytic queries. (*)
5. Which command for the MySQL Data Service will resume OCPU billing?
Restart (*)
===== Converged Database =======
1. Which three options can developers use to access spatial features?
Node.js (*)
Python (*)
PL/SQL (*)
2. Which two are true about Spatial Studio?
You can create interactive maps and perform spatial analysis on business data quickly and easily. (*)
Users can convert address data to coordinates so that they can plot locations on a map. (*)
3. Which two are true about Graph Analytics?
Oracle provides an Open-Source Graph Language (PGQL). (*)
Graph Analytics can be used to discover influencers, dependencies, communities, and ranking. (*)
4. Which two statements are true about an Autonomous JSON database?
The Autonomous JSON database is accessed via document APIs. (*)
It has instant auto-scaling. (*)
======== Resiliency ========
1. Which two are true about Oracle Real Application Clusters (RAC)?
utilizes two or more instances of an Oracle Database concurrently (*)
zero downtime rolling maintenance (*)
2. Which are the three security zones of control?
Prevent (*)
Detect (*)
Assess (*)
3. Which of the following has expanded flexibility with shared or dedicated Exadata infrastructure?
Oracle Autonomous Database (*)
4. Which two are true about Oracle Transparent Application Continuity (TAC)?
It uses Application Continuity and Oracle Real Application Clusters. (*)
It transparently tracks and records session information in case there is a failure. (*)
======== Developing in Oracle Database ========
1. Which is NOT an ORDS feature?
Impact analysis (*)
2. Which ADB tool can you use to discover anomalies, outliers, and hidden patterns in your data?
Data Insights (*)
3. Which ADB tool can you use to upload or access data from local files or remote databases?
Data Load (*)
4. Which is NOT true about low code?
rich functionality with more code (*)
====== Data Lake, Data Warehouse & ML ======
1. What is Data Mesh?
It is a data solution for enterprise-scale domains and/or event-driven data-centric cloud projects. (*)
2. Which three are a part of the five key Lakehouse elements?
Data Catalog (*)
Data Integration (*)
Managed open-source services (*)
3. Which two are true about Data Catalog?
It discovers data using a powerful search. (*)
It harvests object storage to derive schemas. (*)
4. What protects against external and internal threats?
Data Security (*)
5. Which of the following helps avoid manual or exhaustive search techniques?
Auto Model Tuning (*)
========== Skill Check: Upgrade and Migration ========== 
1. Which migration type uses Data Pump and GoldenGate tools?
Logical Migration (*)
2. Which is the recommended method to upgrade databases?
AutoUpgrade (*)
3. In which release is the non-CDB architecture supported?
Oracle Database 19c (*)
4. What is the most important reason for upgrading and patching a database?
Security (*)
==== Test: Practice Exam For - Oracle Cloud Data Management Foundations Associate ====
1. Which ADB tool can you use to discover anomalies, outliers, and hidden patterns in your data?
Data Insights (*)
2. Which self-service tools are available with the Autonomous Database?
Oracle Machine Learning (*)
Low-Code App Dev, APEX (*)
3. What is the most important reason to upgrade and patch?
Security (*)
4. Which two are true about the Autonomous JSON database?
Accessed via document APIs (*)
Instant auto-scaling (*)
5. What are the three security zones of control?
Detect (*)
Prevent (*)
Assess (*)
6.What interconnect solutions are available to connect Oracle Cloud to other cloud provider?
Cloud Router (*)
FastConnect (*)
7. Which migration types uses Datapump and GoldenGate tools?
Logical Migration (*)
8. Which two actions can be performed from the OCI Console for an Oracle Autonomous Database?
Scale up/down CPU (*)
Increase Storage allocated for Database (*)
9. What component is not included in a MySQL Database Service DB System?
FastConnect (*)
10. Which statements are included in default configuration for automatic database backups?
Archive redo log files are backed up every 30 minutes (*)
Backups are executed on primary site (*)
11. Which statement is not the responsibility of the customer in a simple cloud management model?
Manage database servers and VM hosts (*)
12. Which are the capabilities of Oracle Autonomous Database that can accelerate innovation? (Choose three)
Provisions a data warehouse in seconds (*)
Instant scaling of storage (*)
Built-in AI and ML helps find patterns that could identify undiscovered anomalies (*)
13. Which statement is true about Autonomous Transaction Processing?
It is used for OLTP and mixed workloads. (*)
14. Which of the following has expanded flexibility with shared or dedicated Exadata infrastructure?
Oracle Autonomous Database (*)
15. Which statements are true about built-in SQL Worksheet and
Notebook? (Choose two)
Quickly start running queries with built-in web-based notebooks (*)
No need to install a client query tool (*)
16. Which two are true about the Data Catalog?
Harvest object storage to derive schemas (*)
Discover data using powerful search (*)
17. Which three are required for provisioning an Oracle Autonomous Database instance? (Choose three)
Number of CPUs (*)
Workload Type (*)
Database Name (*)
18. Which command for the MySQL Data Service will resume OCPU billing?
Restart (*)
======= Prova 1 =======
1. Which statement is true about moving virtual machine (VM) database (DB) systems from one —) Markfor Review
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 Rh
current compartment.
2. Which two target database environments provide both high availability (HA) and disaster
recovery (DR) options in the cloud?
Autonomous Database
Exadata Cloud Service
�3. After you have provisioned a virtual machine (VM) database (DB) system, what action can you
take to meet changes in block storage requirements?
If a VM DB system requires more block storage, increase the storage at any time
without impacting the system.
�4, What is the FINAL release supporting the non-CDB architecture?
Oracle Database 19c
�5. What is the Oracle recommended way to upgrade databases?
AutoUpgrade
�6. What are two important reasons to upgrade and patch?
Support Compliance
Security
�7. Which three data file formats can be loaded using Oracle Database Actions?
JSON
CSV
AVRO
�8. What is a main feature of APEX's low code platform?
Use graphical interfaces and configuration for building web applications
�9. Which two are objectives of Oracle's Data Management strategy?
Provide for the fastest, most scalable converged SQL database.
Automate everything for developers, data analysts, DBAs and data scientists.
�10. Which two are key characteristics of Oracle Autonomous Database?
Lower cost
Oracle manages everything
�11. Which statement can be detected by monitoring of access to sensitive data?
SELECT * from EMPLOYEES;
�12. 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
Database Vault
�13. What is the primary goal of Oracle Maximum Availability Architecture for customer systems?
O active Replication, Data Protection and continuous availability
�14. How can the goal of scale out high availability be achieved?
By provisioning nodes with Real Application Clusters
�15. NoOSQL Database Cloud Service supports all three types of big data.
Which is NOT considered big data?
Free-structured data DR
�16. What are two characteristics of Oracle SQLcI (SQL Developer Command Line)?
Available in the OCI Cloud Shell by default
Ability to execute SQL batch files
�17. What set of NoSQL-style APIs can be used in Autonomous JSON Database?
SODA (Simple Oracle Document Access)
�18. 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?
Object Storage (standard)
�19. Which Oracle Cloud Infrastructure (OCI) Identity and Access Management (IAM) capability helps
you to organize multiple users into teams?
Groups DS
�20. Which Oracle Cloud Infrastructure (OCl) service is NOT available as part of Oracle Cloud Fre
Tier?
Exadata DB Systems
�21. Which two methods can you use to create or modify Oracle Cloud Infrastructure (OCI)
resources?
OCI REST APIs
OCI Command-line Interface (CLI)
�22. The Supply Side is data that is passive and means something. What two models and libraries
are included in the supply side?
Domain objects
Technical definitions of business terms
�23. The Demand Side is data that is active and does something. What two data services are
typically part of the demand side?
Payloads
Authorization
�24, Which Lakehouse service should you use for serverless Spark processing?
OCI Data Flow 
25. Lakehouse on Oracle Cloud Infrastructure (OCI) is the premier platform for analyzing any de
for any insights. Which is NOT a component of this solution?
Oracle E-Business Suite
�26. Where should you store unstructured, high volume data sets of unknown value for best
price/performance?
OCI Object Storage
�27. The Oracle Cloud Infrastructure (OCI) Data Catalogis an integral part of the Lakehouse
solution. What level of data detail does Data Catalog provide when integrated with Autonomous
Databases and Object storage?
View of data for discovery
�28. Oracle Data Lakehouse streamlines the integration, storage, and processing of data. Which two
services are used for persistence of the data in Lakehouse?
OCI Object Storage
Autonomous Database
�29. Which service is used by default by the MySQL Database Service to store user data to make it
more resistant to failures?
OCI Block Volumes
�30. 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
�31. Which Oracle Cloud Infrastructure storage platform is used by MySQL Database Service for all
data storage?
Block Volume Storage
�32. You have stopped the HeatWave cluster. Which two statements are correct?
The data loaded in HeatWave cluster memory is lost.
Billing will stop for the HeatWave cluster.
�33. Which three are prerequisites for using the MySQL Database Service?
You must create a compartment to store your resources.
You must create a tenancy and be able to sign in to it.
You or your group must be granted the policies described in Mandatory Policies.
�34. Which security measure is implemented out-of-the-box, and is included if you are not using
BYOL licensing with Exadata Cloud&Customer?
O oracle Native Network Encryption and TDE (Transparent Data Encryption)
�35. Which three can be selected when using the console to create an autonomous database on an
Autonomous Exadata CloudE&Customer?
amount of database storage required
amount of database OCPUs required
workload type 
�36. Exadata is the integration of the software and hardware and is available to customers on which
deployments?
In the Oracle Cloud and customer site
�37. 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
�38. When Customers are using the Exadata Cloud Service, what are they responsible for
managing?
Databases and Customer VM
�39. Which tool is provided to support Continuous Integration/Continuous Deliver (CI/CD)
workflows?
SQLcel (including Liquibase)
�40. How does the Converged Database help to access data using an API?
A REST API is automatically generated on top of SQL or stored procedures.
�41. What connections to multiple public clouds are provided through 3º party connectivity?
Megaport Cloud Router (MCR) and Virtual Cross Connect (VXC)
�42. 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 DS
�43. What are two main benefits of Oracle APEX?
Rapidly develop, customize, and deliver secure applications
Develop responsive web apps
�44. What are the two main features of APEX's low code platform?
Focus on business requirements
Use graphical user
interfaces and configuration
�45. Which are two characteristics of Autonomous Data Warehouse (ADW)?
Creates data summaries
Optimized for complex SQL
�46. Which are two characteristics of Autonomous Transaction Processing (ATP)?
Focuses on creation of indexes
Optimized for response time
�47. What is NOT a feature of the Oracle Autonomous Database to protect data from external and
internal threats?
Admin passwords are disabled after provisioning
�48. What are two typical reasons why customers CANNOT move their database into the public
cloud?
Regulations that prevent moving data into the public cloud
Putting data in the cloud would break data residency rules R
�49. 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.
�50. Which is NOT an option in Database Actions to load data into Autonomous Database?
Load data using FTP
�51. What is a prerequisite of running APEX on an Autonomous Database?
An Autonomous Database with the workload type Data Warehouse, Transaction
Processing, SON or APEX.
�52. What is NOT a workload that can be selected when provisioning an Autonomous Database?
MySQL
�53. What are three platforms where Oracle's Autonomous Database service can be deployed?
Dedicated Region Cloud at Customer
Oracle Public Cloud at Customer
Oracle Cloud Infrastructure
�54. Which workload CANNOT be run on Oracle Database 19c?
Hadoop Clusters
�55. Oracle Automated Machine Learning (AutoML) has options for using in-database and
opensource algorithms. Which is an example of an in-database option?
Oracle Machine Learning for Python (OMLA4Py) APIs
=============== Prova 2 ===============
1. Oracle Automated Machine Learning (AutoML) has options for using in-database and opensource algorithms. Which
is an example of an in-database option?
O Oorade Machine Leaming for Python (OMLAPy) APIs (*)
�2. What is NOT à workload that can be selected when provisioning an Autonomous Database?
MySQL (*)
�3. Which Oracle Cloud Infrastructure storage platform is used by MySQL Database Service for all data storage?
Block Volume Storage (*)
�4. Which two statements are true regarding MySQL Database Service HeatWave?
Heatwave uses machine leaming to automate operations, increasing DRA productivity and reducing costs.(*)
ER HeatwWave is a in-memory, query-processing engine designed for fast execution of analytic queries.(*)
�5. You have stopped the HeatiWave cluster. Which two statements are correct?
Billing will continue for the HearWave cluster. (*)
The data loaded in HeatWave cluster memory is lost.(*)
�6. Which two are key features of MySQL Database Service?
Integration with Grade Technologies: Uses a cient's existing Oracle investments and eashy integrates
MySQL Database Service with Oracle technologies (*)
Regulatory Compliance: Uses Advanced Segurity to help clients meet industry and regulatory compliance requirements, Including GDPR, PCI and
HIPPA (*)
�7. Which three are prerequisites for using the MySOL Database Service?
You Must create à tenancy and be able to sign in to it.(*)
You or your group must be granted the policies desenibed in Mandatory Polbcies.(*)
You must create à compartment to store your resources. (*)
�8. Which Lakehouse service should you use for serveriess Spark processing?
OCI Data Flow(*)
�9. What does the Oracle Cloud Infrastructure (OCI) Data Catalog primarily provide for data in the Lakehouse on OC?
Data Integration (*)
�10. Oracle Data Lakehouse streamilines 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 (*)
�11. Lakehouse on Oracle Cloud Infrastructure (OC) is the premier platform for analyring any data for any
insights. Which 15 NOT a component of this solution?
Oracle E-Business Suire (*)
�12. Where should you store unstructured, high volume data sets of unknown value for best price/performance?
OCI object Storage (*)
�13. What does ORDS stand for?
Orade REST Data Services (*)
�14. The Demand Side is data that i5 active and does something. What Dwo data services are typicaily part of the
demand side?
Payicads (*)
Authorization (*)
�15. The Supply Side is data that is passive and means something. What wo models and libraries are included in the
supply side?
Business rules (*)
Domain objects (*)
�16. Which tool is provided to support Continuous Integration/Continuous Deliver (CVCD) workflows?
SQLcl (including Liquibase) (*)
�17. How does the Converged Database help to access data using an API?
A REST API is automatically generated on top of SQL or stored procedures. (*)
�18. Which Oracle Cloud Infrastructure (OCl) service is NOT avaliable as part of Óracie Cloud Free Tier?
Exadata DB Systems (*)
�19. Which two statements are true when deciding which Oracle Cloud Infrastructure (OCI) region to register an Exadata
Cloud@Customer Infrastructure in?
Consider any business policies or regulations that predude the use of a particular region.(*)
Consider the physical proximity of the region you register the infrastructure in to your data center.(*)
�20. Which security measure is implemented out-of-the-box, and is included if you are not using BYOL licensing with
Exadata Cloudi&Customer?
Orade Native Nenwork Encrypnon and TDE (Transparent Data Encrypuon)(*)
�21. Which component is NOT included as part of an Oracle NoSOL table Oracie Cloud Identifier (OCIDJ?
Unique ID(*)
�22. What is a prerequisite of running APEX on an Autonomous Database?
An Autonomous Database with the workioad type Data Warehouse, Transaction Processing, JSON or
APEX. (*)
�23. Which is NOT an option in Database Actions to load data into Autonomous Database?
Load data using FTP (*)
�24, What is the FINAL release supporting the non-CDE6 architecture?
Orade Database 19c(*)
�25. What is the Oracle recommended way to upgrade databases?
Autouperade (*)
26. What are wo important reasons to upgrade and patch?
Security (*)
Validation of application (*)
�27. Which is NOT a prerequisite for patching Grid Infrastructure or database homes when using the console?
Oracle Clusterware is doam on the VM cluster. (*)
�28. After you have provisioned a virtual machine (VM) database (DB) system, what action can you take to meet changes
in block storage requirements?
If a VM DB system requires more block storage, increase the storage at any tirme without mparctine the
System. (*)
�29. Which two locations can be used to store your DS system database backups?
You can store your DB system database backups in Oracle Cloud Infrastructure Object Storage.(*)
You can store your DB system database backups on tocally anached biock srorage volumes.(*)
�30. Which two methods can you US5e Lo create or modify Oracke Cloud Infrastructure (OCl) resources?
OCI command-line Interface (CLI) (*)
OCI REST APIs(*)
�31. 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?
No dowrtime is required as number 6f OCPU can be increased from OC console. but users have to be
informed That hey must not use any application for at least one hour.(*)
�32. Which are two characteristics of Autonomous Data Warehouse (ADWWP)?
Statistics are gathered as part of DML operations (*)
Optimized for complex SQL. (*)
�33. Whatis NOT à feature of the Oracle Autonomous Database to protect data from external and internal threacts?
Admin passwords are disabled after provisioning (*)
�34. Which depltoyment option provides the highest degree of security and governance white providing a completely
seli-service database experience?
Oracle Autonomous Database
�35. What are three platforms where Oracie's Autonomous Database service can be deployed?
Orade Cloud Infrastruchure (*)
Dedicated Region Cloud at Customer (*)
Hybrid Cloud Configurations (*)
�36. Which workload CANNOT be run on Oracle Database 19c?
Hadoop Clusters (*)
�37. Which three data file formats can be loaded using Oracle Database Actions?
AVRO (*)
JSON (*)
CVS (*)
�38. What is a main feature of APEX's low code platform?
Use graphical interfaces and configuration for building web applications. (*)
�39. What set of NoSQL-style APIS can be used in Autonomous JSON Database?
SODA (Simple Oracle Document Access)(*)
�40, What are two characteristics of CI/CD?
It introduces automation into all stages of app/database development.(*)
Development changes are automatically tested on push/commits and merges.(*)
�41. What security control area determines 1f there 15 sensitive data in a system?
Assess (*)
�42. Which statement can be detected by monitoring of access to sensitive data?
Select * from EMPLOYEES: (*)
�43. Which two are objectives of Oracle's Data Management strategy?
Automate everything for developers, data analysis, DBAs and data scientists. (*)
Provide for the fastest, most scalable converged SOL database. (*)
�44. Which two are key characteristics of Oracie Autonomous Database?
Oracle manages everything (*)
Lower cost (*)
�45, À customer wants to use Oracle Cloud Infrastructure (O€i) for storing application backups which can be stored for
months, but retrieved immediately based on business needs.
Which OCl storage service can be used to meet this requirement?
Archive Storage (*)
�46, Which Oracle Cloud Infrastructure (OC) Identity and Access Management (IAM) capability helps you to organize
multiple users into teams?
Groups (*)
�47. Multicloud strategy eliminates the reliance of a single dioud provider but also provides which two advantages?
Compliance for use of specífic peographies for data sovereienty laws (*)
Ability to have prrvate clouds and mamtain customer data centers (*)
�48. In order to support multicloud strategies, what is offered as an industry first by Oracle?
Dedicated cloud region (*)
�49. How can the goal of scale out high availability be achieved?
By provisioning nodes with Real Application Clusters.(*)
�50, What is the primary goal of Oracle Maximum Availability Architecture for customer systems?
Active Replication, Data Protection and continuous avallabiliny (*)
�51. When Customers are using the Exadata Cloud Service, what are they responsible for managing?
Databases and Customer VM (*)
�52. New hardware innovations of The Exadata XEM allow customers to take advantage of Remote Direct Memory
Access (RDMA). What resource does RDMA access?
Persistert Memory (*)
�53. Exadata is the integration of the software and hardware and is available to customers on which deployments?
In the Oracle Cloud and customer site (*)
�54, What are vo main benefits of Oracle APEX?
Develop responsive web apps (*)
�55. What are the two main features of APÉEX's low code platform?
Use graphical user interfaces and configuration (*)
Focus on business requirements (*)
========== Prova 3 ============
2. NoSQL Database Cloud Service supports all three types of big data.
Which is NOT considered bie data?
structured data (*)
�3. How does the Converged Database help to access data using an API?
A REST AP! is automatically generated on top of SOL or stored procedures.(*)
�4, Which tool is provided to support Continuous Integration/Continuous Deliver (CI/CD) workflows?
SQLcl (including Liquibase)(*)
�
5. Which two methods can you use to create or modify Oracle Cloud Infrastructure (OC) resources?
OCI Command-line Interface (CLI) (*)
OCI Rest APIs (*)
�6. What security control area determines if there is sensitive data in a system?
ASSESS (*)
�7. 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?
Nevwort Encryption (*)
Database Vault (*)
�8. Which security measure is implemented out-of-the-box, and is included if you are not using BYOL licensing with
Exadata Cloud&QGCustoamer?
Oracle Native Network Encryption and TDE (Transparent Data Encryption) (*)
�9, 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 (*)
workload type (*)
�10. What does ORDS stand for?
Oracle REST Data Services (*)
�11. Which two are key characteristics of Oracle Autonomous Database?
Lower cost (*)
Oracle manages everything (*)
�12. Which two are objectives of Oracle's Data Management strategy?
Automate everything for developers, data analysts, DBAs and data scientists. (*)
Provide for the fastest, most scalable converged SOL database. (*)
�13, A customer wants to use Oracle Cloud Infrastructure (O€I) for storing application backups which can be stored for
manths, but retrieved immediately based on business needs.
Which OCI storage service can be used to meet this requirement?
Object Storage (standard) (*)
�14, 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?
Object Storage (standard) (*)
�15. 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. (*)
Operator Access Control can terminate Oracle operator connections. (*)
�16. Exadata is the integration of the software and hardware and is available to customers on which deployments?
In the Oracle Cloud and customer site (*)
�17. New hardware innovations of the Exadata XSM allow customers to take advantage of Remote Direct Memory
Access (RDMA). What resource does RDMA access?
Persistent Memory (*)
�18. What set of NoSQOL-style APIs can be used in Autonomous ISON Database?
SODA (Simple Oracle Document Access) (*)
�19, Which workload CANNOT be run on Oracle Database 19c?
Hadoop Clusters (*)
�20. What are three platforms where Oracle's Autonomous Database service can be deployed?
Oracle Cloud Infrastructure (*)
Oracle Public Cloud at Customer (*)
Dedicated Region Cloud at Customer (*)
�21. Which Lakehouse service should you use for serverless Spark processing?
OCI Data Flow (*)
�22. Oracle Data Lakehouse streamlines the integration, storage, and processing of data. Which two services are used
for persistence of the data in Lakehouse?
Autonomous Database (*)
OCI Object Storage (*)
�23. 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 (OC) Lakehouse?
NosqL Service (*)
�24. The Oracle Cloud Infrastructure (OCl) 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?
View of data for discovery (*)
�25. Where should you store unstructured, high volume data sets of unknown value for best price/performançe?
OCI Object Storage (*)
�26. How can the goal of scale out high availability be achieved?
By provisioning nodes with Real Application Clusters (*)
�27. What is the primary goal of Oracle Maximum Availability Architecture for customer systems?
Active Replication, Dara Protection and continuous availability (*)
�28. Which tool allows users to execute SOL statements, create relational models, load data, and monitor SOL queries
from your browser?
SOL Developer (*)
�29, What is a prerequisite of running APEX on an Autonomous Database?
An Autanomous
Database with the workload type Data Warehouse, Transaction Processing, JSON or
AFEX. (*)
�30. What are two characteristics of Oracle SOLcl (SQL Developer Command Line)?
Available in the OC Cloud Shell by default (*)
Ability to execute SOL batch files (*)
�31. You have stopped the HeatWave cluster. Which two statements are correct?
The data loaded in HeatWave cluster memory is lost. (*)
The HeatWave cluster stop action will-also stop DE System. (*)
�32. 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 compartiment to store your resources, (*)
You must create a tenancy and be able to sign in to it. (*)
�33. Which statement js true about MySQL Database Service?
It is fully managed Oracle Cloud Infrastructure (OCI) native service. (*)
�34, Which service is used by default by the MySQL Database Service to store user data to make it more resistant to
failures?
OCI Block Volumes (*)
�35. Which two statements are true regarding MySQL Database Service HeatWave?
Heatwave is a in-memo ny, query-processing engine designed for fast execution of analytic queries. (*)
HeatWave uses machine learning to automate operations, increasing DBA productivity and reducing
costs. (*)
�36. What is NOT a workload that can be selected when provisioning an Autonomous Database?
MySQL (*)
�37. Which two locations can be used to store your DB system database backups?
You can store your DB system database backups in Oracle Cloud Infrastructure Object Storage. (*)
You can store your DB system database backups locally in the Fast Recovery Area of the DB system. (*)
�38. 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 acess permissions to the compartment that
the resource is being moved to, as wll as the current compartment. (*)
�39. After you have provisioned a virtual machine (VM) database (DB) system, what action can you take to meet changes
in block storage requirements?
If a VM DB system has different requirements for block storage, increase or decrease the storage at any
time without impacting the system. (*)
�40. Which three data file formats can be loaded using Oracle Database Actions?
JSON (*)
CSV (*)
AVRO (*)
�41. Which ability is NOT provided out of the box with the Autonomous Database Tools set?
Data Labeling (*)
�42. What are two main benefits of Oracle APEX?
Develap responsive web apps (*)
Rapidly develop, customize, and deliver secure applications (*)
�43, What are the two main features of APEX's low code platform?
Use graphical user interfaces and configuration (*)
Focus on business requirements (*) 
�44, What is NOT a feature of the Oracle Autonomous Database to protect data from external and internal threats?
Admin passwords are disabled after provisioning (*)
�45. Which are two characteristics of Autonomous Data Warehouse (ADW)?
Optimized for complex SQL (*)
Statistics are gathered as part of DML operations (*)
�46. 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 OCL Console and increase the number of OCPU, No downtime required. (*)
47. What are two typical reasons why customers CANNOT move their database into the public cloud?
Putting data in the cloud would break data residency rules (*)
Regulations that prevent moving data into the public cloud (*)
�48. Oracle Cloud and Microsoft Azure have an interconnect for workloads across cloud. Which two are also benefits
this partnership and interconnect provide?
Unified identity and access management (*)
Connection to other muiticioud environments (*)
�49, What connections to multiple public clouds are provided through 3"* party connectivity?
O Megaport Cloud Router (MCR) and Virtual Cross Connect (VXC) (*)
�50, The Demand Side is data that is active and does something. What two data services are typically part of the
demand side?
Ed Authorization (*)
Inert algorithms (*)
�51. The Supply Side is data that is passive and means something. What two models and libraries are included in the
supply side?
Reports (*)
Domain objects (*)
�52. Which Oracle Cloud Infrastructure (OCI) service is NOT available for provisioning in your tenancy as an Always Free
resource?
Fast Connect (1 Gbps public peering) (*)
�53, Which is NOT a key to successful database uperades?
O Enable Performance Sta bility with SPM, STA, and RAT (*)
�54. When should you change COMPATIBLE?
O After upgrades (*)
�55. What is the Oracle recommended way to uperade databases?
AutoUpgrade (*)