1Z0-1105-23

Prévia do material em texto

TEST: 1Z0-1105-23 
1. Which statement is true about moving virtual machine (VM) database (DB) systems from 
one compartment to another? 
You can move DB systems to a diferente compartment if you have suficiente access 
permissions to the compartment that the resource is being moved to, as well as the 
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. Whats 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 importante 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 main feature os 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 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? 
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. NoSQL Database Cloud Service supports all three types of big data. 
Free-structured data 
16. What are two characteristics of Oracle SQLcl (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) identify and Access Management (IAM) 
capability helps you to organize multiple users into teams? 
Groups 
20. Which Oracle Cloud Infrastructure (OCI) service is NOT available as part of Oracle Free 
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 Sid eis 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 Sid eis 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 
data 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 unknown value for best 
price/performance? 
OCI Object Storage 
27. The Oracle Cloud Infrastructure (OCI) Data Catalog is na integral part of the Lakehouse 
solution. What level os 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 Investiments and 
easily integrates MySQL Database Service with Oracle Technologies. 
Regulatory Compliance: Uses advanced security to help clientes meet industry and 
regulatory compliance requirements, including GDPR, PCI and HIPPA. 
31. Which Oracle 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? 
Oracle Native Network Encryption and TDE (Transport Data Encryption) 
35. Which three can be selected when using the console to create na autonomous database 
on an Autonomous Exadata Cloud@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 os 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? 
SQLcl (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. Whats connections to multiple public clouds are provided through 3rd 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 pastnership and interconnect provide? 
Low Latency 
Unified identity and access management 
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 os 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 sumaries 
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 os 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 
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 os running APEX on an Autonomous Database? 
An Autonomous Database with the workload type Data Warehouse, Transaction 
Processing, JSON 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 (OML4Py) APIs 
56. Which deployment option provides the highest degree os security and governance while 
providing a completely self-service database experience? 
Oracle Autonomous Database 
57. The DBA has determined that number of OCPU assigned to an Autonomous Database 
does not provide suficiente performance. Which option does the DBA have in this case? 
Plan for a one-hour downtime and increase the number of OCPU while database is off-
line. 
 
 
 
 
58. Which two statements are true regarding MySQL Database Service HeatWave? 
HeatWave is a in-memory, query-processing engine designed for fast execution of 
analytic queries. 
HeatWave user machine learning to automate operations, increasing DBA productivity 
and reducing costs. 
59. Which statement is true about MySQL Database Service? 
It is a fully managed Oracle Cloud Infrastructure (OCI) native service. 
60. What security control área determines if there is sensitive data in a system? 
Assess 
61. 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. 
62. Which is NOT a resource type for NoSQL Database Cloud Service? 
Nosql-keys 
63. Which Oracle Cloud Infrastructure (OCI) service is NOT available for provisioning in your 
tenancy as an Always Free Resource? 
Fast Connect 
64. Which is NOT a key to successful database upgrades? 
Enable Performance Stability with SPM, STA and RAT 
65. When Should you change COMPATIBLE? 
After database downgrades 
66. 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. 
67. Which tool allows users to execute SQL statements, create relational models, load data, 
and monitor SQL queries from your browser? 
SQL developer 
68. What does the Oracle Cloud Infrastructure (OCI) Data Catalog primarily provide for data 
in the LakeHouse on OCI? 
Metdata source of truth 
69. Which feature allows you to logically group and isolate your Oracle Cloud Infrastructure 
resources? 
Identify and Access Management Groups 
70. Which ability is NOT provided out of the box with the Autonomous Database Tools set? 
Data Labeling