Prova OCI DataBase

Prévia do material em texto

Review your answers, feedback, and question scores below.
Parte superior do formulário
1. Where should you store unstructured, high volume data sets of unknown value for best price/performance? 
OCI Data Catalog 
OCI Data Flow 
OCI GoldenGate 
OCI Object Storage 
Review your answers, feedback, and question scores below.
Parte superior do formulário
2. Which Lakehouse service should you use for serverless Spark processing? 
Oracle Analytics Cloud 
OCI Object Storage 
OCI Data Flow 
OCI Data Catalog 
3. 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 Autonomous Data Warehouse 
Oracle E-Business Suite 
OCI Data Catalog 
OCI Big Data Service 
OCI Data Flow 
4. 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? 
Big Data Service 
Autonomous Database 
OCI Data Flow 
NoSQL Service 
5. Oracle Data Lakehouse streamlines the integration, storage, and processing of data. Which two services are used for persistence of the data in Lakehouse? 
OCI GoldenGate 
Autonomous Database 
OCI Data Catalog 
OCI Object Storage ^
6. Which three can be selected when using the console to create an autonomous database on an Autonomous Exadata Cloud@Customer? 
amount of database storage required 
workload type 
client network 
size of the shared global area (SGA) to use 
amount of database OCPUs required 
7. Which two statements are true when deciding which Oracle Cloud Infrastructure (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. 
Exadata Cloud@Customer is hosted in a customer data center so the Exadata infrastructure is not registered in an OCI region. 
Consider any business policies or regulations that preclude the use of a particular 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. 
8. When should you change COMPATIBLE?   
When the database is stopped 
After patching  
After database downgrades  
After upgrades   
9. What is the Oracle recommended way to upgrade databases?   
AutoUpgrade 
Data Pump Export/Import 
Command Line Upgrade 
Database Upgrade Assistant (DBUA) 
10. What is the FINAL release suportem the non-CDB architecture?   
Oracle Database 23c  
Oracle Database 21c  
Oracle Database 18c  
Oracle Database 19c  
11. 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 
Oracle Machine Learning for Python (OML4Py) APIs 
Cognitive text 
Tuning of hyperparameter 
12. What three typical data types/models are covered by Oracle's Converged Database? 
Relational 
Spatial 
Events 
Graph 
Terraform 
Images 
Notifications 
13. 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. 
The database provides only one universal REST interfaces which makes integration of applications extremely agile. 
Each database comes with a REST-enabled compute instance to provide access to data. 
A REST API is automatically generated on top of SQL or stored procedures. 
14. Which are two characteristics of Autonomous Data Warehouse (ADW)? 
Statistics are gathered as part of DML operations  
Creates data summaries 
Stores data in row format 
Optimized for complex SQL 
Focuses on creation of indexes 
15. Which deployment option provides the highest degree of security and governance while providing a completely self-service database experience?
Oracle MySQL Database Service 
Oracle Autonomous Database 
Oracle Database Cloud Service 
Exadata Cloud Service 
16. 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?
Call Oracle Cloud Support and raise a request to increase number of OCPU. Expect a downtime of approximately one hour. 
Open the database in OCI Console and increase the number of OCPU. No downtime required. 
Plan for a one-hour downtime and increase the number of OCPU while database is offline. 
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 
17. What is NOT a feature of the Oracle Autonomous Database to protect data from external and internal threats? 
Admin passwords are disabled after provisioning 
Data is encrypted 
Security updates are applied online 
Protects data from admin snooping using Database Vault 
18. Which statement can be detected by monitoring of access to sensitive data? 
CREATE index emp_id_idx on EMPLOYEES(emp_id); 
SELECT SYSDATE from DUAL; 
UPDATE quarter_reference set Q1='012022' 
SELECT * from EMPLOYEES; 
19. What security control area determines if there is sensitive data in a system? 
Assess 
Detect 
Protect 
Users 
20. Exadata is the integration of the software and hardware and is available to customers on which deployments? 
only in a hybrid cloud 
only at the customer site 
only in public cloud environments 
in the Oracle Cloud and customer site 
21. 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 network connections in the Oracle public cloud. 
Operator Access Control can terminate Oracle operator connections. 
Allow only the Oracle Staff to perform control access. 
22. 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 
Compute Instances 
Database Servers 
Storage Disks 
23. Which feature allows you to logically group and isolate your Oracle Cloud Infrastructure resources? 
Identity and Access Management Groups 
Tenancy 
Availability Domain 
Compartments 
24. 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 
25. Which Oracle Cloud Infrastructure (OCI) Identity and Access Management (IAM) capability helps you to organize multiple users into teams? 
Users 
Roles 
Policies 
Groups 
26. What is NOT a workload that can be selected when provisioning an Autonomous Database? 
MySQL 
APEX 
Data Warehouse 
JSON 
27. 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 
28. 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. 
A DBA must enable ORDS first. 
A DBA must create APEX admin and APEX users first before starting APEX from Oracle Cloud Infrastructure Console. 
APEX can simply be installed by downloading the executable from OTN. 
29. What are three platforms where Oracle's Autonomous Database service can be deployed? 
Dedicated Region Cloud at Customer 
Oracle Public Cloud at Customer 
AWS Cloud at Customer 
Oracle Cloud Infrastructure 
Hybrid Cloud Configurations 
30. Which workload CANNOT be run onOracle Database 19c?
Machine Learning 
Gaming 
Hadoop Clusters 
Translytical 
31. Which Oracle Cloud Infrastructure (OCI) service is NOT available as part of Oracle Cloud Free Tier? 
Compute 
Monitoring 
Exadata DB Systems 
Autonomous Data Warehouse 
32. What are the two main features of APEX's low code platform? 
Simplified core-based licensing 
Use traditional computer programming paradigms 
Use graphical user interfaces and configuration 
Build scalable web apps for MongoDB 
Limited productivity 
Focus on business requirements 
33. What are two main benefits of Oracle APEX? 
Less productivity compared to hand coding 
Faster development time using hand coding 
Develop responsive web apps 
Store data in PL/SQL objects 
Rapidly develop, customize, and deliver secure applications 
34. Which two are objectives of Oracle's Data Management strategy? 
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. 
Provide for the fastest, most scalable converged SQL database. 
Provide the best platform for warehouse workloads only. 
35. Which two are key characteristics of Oracle Autonomous Database? 
Lower cost 
Oracle manages everything 
Higher cost 
Less automated 
Customer manages everything 
36. The Supply Side is data that is passive and means something. What two models and libraries are included in the supply side? 
Technical definitions of business terms 
Business rules 
Reports 
Domain objects 
37. 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 
Payloads 
Authorization 
38. What are two characteristics of CI/CD? 
It introduces automation into all stages of app/database development. 
It prevents developers from merging their code changes back to the shared branch for security. 
Development changes are automatically tested on push/commits and merges. 
It requires Liquibase 
39. What does ORDS stand for? 
Oracle Rapid Data Systems 
Oracle REST Data Services 
Oracle Resilient Data Security 
Oracle REAP Diagnosis Systems 
40. Which two target database environments provide both high availability (HA) and disaster recovery (DR) options in the cloud? 
Streaming Service 
Compute VM 
Autonomous Database 
Exadata Cloud Service 
41. 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 in on-premises local storage. 
You can store your DB system database backups on locally attached block storage volumes. 
You can store your DB system database backups locally in the Fast Recovery Area of the DB system. 
42. After you have provisioned a virtual machine (VM) database (DB) system, what action can you take to meet changes in block storage requirements? 
After you have provisioned a VM DB system, you cannot increase or decrease block storage. 
Only bare metal DB systems can increase block 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. 
If a VM DB system has different requirements for block storage, increase or decrease the storage at any time without impacting the system. 
43. What is the primary goal of Oracle Maximum Availability Architecture for customer systems? 
Data Protection, access and reporting 
Continuous Availability, network security and failover 
Scale out, application availability and protection 
Active Replication, Data Protection and continuous availability 
44. How can the goal of scale out high availability be achieved? 
By implementing Flashback 
By using the Zero Data Loss Recovery Appliance 
By provisioning nodes with Real Application Clusters 
By implementing Active Data Guard 
45. Oracle Cloud and Microsoft Azure have an interconnect for workloads across cloud.  Which two are also benefits this partnership and interconnect provide? 
Upgrade compliance 
Unified identity and access management 
Low Latency 
Connection to other multicloud environments 
46. In order to support multicloud strategies, what is offered as an industry first by Oracle? 
Private and public cloud network 
Cloud databases 
Oracle FastConnect 
Dedicated cloud region 
47. What set of NoSQL-style APIs can be used in Autonomous JSON Database? 
SODA (Simple Oracle Document Access) 
OSDA (Oracle Simple Document Access) 
OASD (Oracle Application Storage Definition) 
DOSA (Document Open Solution Access) 
48. 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 
Build scalable web apps for MongoDB 
Limited productivity 
Simplified core-based licensing 
49. Which three data file formats can be loaded using Oracle Database Actions? 
AVRO 
JSON 
VSAM 
CSV 
50. You have stopped the HeatWave cluster. Which two statements are correct? 
The HeatWave cluster stop action will also stop DB System. 
Billing will continue for the HeatWave cluster. 
Billing will stop for the HeatWave cluster. 
The data loaded in HeatWave cluster memory is lost. 
The HeatWave cluster data will remain loaded. 
51. Which two statements are true regarding MySQL Database Service HeatWave? 
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 uses periodic long-running ETL batch jobs to refresh the data. 
HeatWave data which is needed for analytic processing is stored in disk files. 
52. Which statement is true about MySQL Database Service? 
It is a fully managed Oracle Cloud Infrastructure (OCI) native service. 
It is a public cloud service built on MySQL Community Edition. 
It supports MySQL Enterprise Edition version 5.7 with InnoDB Storage Engine. 
Its users are responsible for database and operating system patching tasks. 
53. Which two are key features of MySQL Database Service? 
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 
Integration with Oracle Technologies: Uses a client's existing Oracle investments and easily integrates MySQL Database Service with Oracle technologies 
54. Which Oracle Cloud Infrastructure storage platform is used by MySQL Database Service for all data storage? 
Object Storage 
Flash Local Storage 
Block Volume Storage 
Archive Storage 
File Storage 
55. Which is NOT a resource type for NoSQL Database Cloud Service? 
Nosql-indexes 
Nosql-rows 
Nosql-keys 
Nosql-tables 
Parte inferior do formulário
Parte inferior do formulário
image3.wmf
image5.png
image6.png
image4.wmf
image1.wmf
image2.wmf