[Apr 14, 2024] Get New 1z0-1105-23 Certification – Valid Exam Dumps Questions
100% Passing Guarantee - Brilliant 1z0-1105-23 Exam Questions PDF
NEW QUESTION # 45
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?
- A. 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.
- B. Call Oracle Cloud Support and raise a request to increase number of OCPU. Expect a downtime of approximately one hour.
- C. Open the database in OCI Console and increase the number of OCPU. No downtime required.
- D. Plan for a one-hour downtime and increase the number of OCPU while database is of-fline.
Answer: C
Explanation:
This option is the correct way to increase the number of OCPU assigned to an Autonomous Database. According to the Oracle documentation2, "You can scale your Autonomous Database on demand by adding CPU cores or storage. You can also enable auto scaling to allow your Autonomous Database to automatically use up to three times more CPU and IO resources than its allocated CPU core count." The scaling operation does not require any downtime or affect the availability of the database.
NEW QUESTION # 46
Which workload CANNOT be run on Oracle Database 19c?
- A. Machine Learning
- B. Translytical
- C. Hadoop Clusters
- D. Gaming
Answer: C
Explanation:
Hadoop clusters cannot be run on Oracle Database 19c. Hadoop is a framework for distributed processing of large data sets across clusters of computers using simple programming models. Oracle Database 19c is a relational database management system that supports SQL and PL/SQL queries and transactions. Hadoop clusters require a different architecture and storage model than Oracle Database 19c. Oracle Database 19c does not support the Hadoop Distributed File System (HDFS) or the MapReduce programming model.
NEW QUESTION # 47
What set of NoSQL-style APIs can be used in Autonomous JSON Database?
- A. DOSA (Document Open Solution Access)
- B. OASD (Oracle Application Storage Definition)
- C. SODA (Simple Oracle Document Access)
- D. OSDA (Oracle Simple Document Access)
Answer: C
Explanation:
SODA (Simple Oracle Document Access) is the set of NoSQL-style APIs that can be used in Autonomous JSON Database. According to the Oracle documentation, "SODA provides a set of APIs for various application-development languages and for RESTful web services that let you create and store collections of JSON documents in an Oracle Database without needing any knowledge of SQL or how the data is stored in the database."
NEW QUESTION # 48
Which is NOT an option in Database Actions to load data into Autonomous Database?
- A. Load data from a local file such as text or Excel
- B. Load data from cloud storage (Oracle, S3, Azure, Google)
- C. Load data from a remote database
- D. Load data using FTP
- E. Load data using Data Pump
Answer: D
Explanation:
Loading data using FTP is not an option in Database Actions to load data into Autonomous Database. According to the Oracle documentation5, "On the Database Actions Data Load page you can choose to load data from a file on your local device, from cloud storage, or from a database. You can also choose to explore the data in your Oracle Autonomous Database." There is no mention of FTP as a source for loading data.
NEW QUESTION # 49
Which two are key characteristics of Oracle Autonomous Database? (Choose all correct an-swers)
- A. Higher cost
- B. Oracle manages everything
- C. Customer manages everything
- D. Less automated
- E. Lower cost
Answer: B,E
Explanation:
These are two key characteristics of Oracle Autonomous Database. According to the Oracle documentation10, "Autonomous Database provides an easy-to-use, fully autonomous database that scales elastically, delivers fast query performance, and requires no database administration." As a service, Autonomous Database handles all the tasks related to provisioning, patching, upgrading, scaling, backup, and recovery of the database, so that customers do not need to manage anything. Additionally, Autonomous Database offers lower cost compared to other cloud database services by providing features such as auto scaling, performance optimization, and pay-per-use pricing model.
NEW QUESTION # 50
What is NOT a feature of the Oracle Autonomous Database to protect data from external and internal threats?
- A. Protects data from admin snooping using Database Vault
- B. Data is encrypted
- C. Security updates are applied online
- D. Admin passwords are disabled after provisioning
Answer: B
NEW QUESTION # 51
Oracle ExaC@C brings the Oracle Cloud to the customer data center. The Oracle Cloud In-frastructure is the same, but responsibilities are adjusted so that customer can perform which two tasks? (Choose all correct answers)
- A. Allow only the Oracle Staff to perform control access.
- B. Secure access configured to the customer network.
- C. Allow network connections in the Oracle public cloud.
- D. Operator Access Control can terminate Oracle operator connections.
Answer: A,B
NEW QUESTION # 52
Which security measure is implemented out-of-the-box, and is included if you are not using BYOL licensing with Exadata Cloud@Customer?
- A. Database Vault and Data Masking Pack
- B. Audit Vault and Database Firewall
- C. Oracle Native Network Encryption and TDE (Transparent Data Encryption)
- D. Oracle Key Vault
Answer: C
Explanation:
Oracle Native Network Encryption and TDE are security measures that are implemented out-of-the-box, and are included if you are not using BYOL licensing with Exadata Cloud@Customer. According to the Oracle documentation5, "Oracle Native Network Encryption encrypts all data sent over the network between database clients and servers using industry-standard encryption algorithms." Additionally, according to the Oracle documentation6, "Transparent Data Encryption (TDE) enables you to encrypt sensitive data, such as credit card numbers, stored in tables and tablespaces."
NEW QUESTION # 53
You have stopped the HeatWave cluster. Which two statements are correct?
- A. The HeatWave cluster stop action will also stop DB Syster
- B. The data loaded in HeatWave cluster memory is lost.
- C. Billing will stop for the HeatWave cluster.
- D. The HeatWave cluster data will remain loaded.
- E. Billing will continue for the HeatWave cluster.
Answer: A,B
NEW QUESTION # 54
Oracle Data Lakehouse streamlines the integration, storage, and processing of dat a. Which two services are used for persistence of the data in Lakehouse? (Choose all correct answers)
- A. Autonomous Database
- B. OCI Object Storage
- C. OCI GoldenGate
- D. OCI Data Catalog
Answer: B,D
NEW QUESTION # 55
NoSQL Database Cloud Service supports all three types of big data.
Which is NOT considered big data?
- A. semi-structured data
- B. free-structured data
- C. unstructured data
- D. structured data
Answer: D
NEW QUESTION # 56
Which Lakehouse service should you use for serverless Spark processing?
- A. OCI Object Storage
- B. OCI Data Flow
- C. Oracle Analytics Cloud
- D. OCI Data Catalog
Answer: B
Explanation:
OCI Data Flow is the Lakehouse service that you should use for serverless Spark processing. According to the Oracle documentation, "Oracle Cloud Infrastructure Data Flow is a fully managed big data service that lets you run Apache Spark applications with no infrastructure to deploy or manage. Data Flow lets you create, run, and manage Apache Spark applications with minimal coding and no infrastructure provisioning or management."
NEW QUESTION # 57
What does ORDS stand for?
- A. Oracle REST Data Services
- B. Oracle REAP Diagnosis Systems
- C. Oracle Rapid Data Systems
- D. Oracle Resilient Data Security
Answer: A
Explanation:
ORDS stands for Oracle REST Data Services, which is a Java application that enables developers to access and manipulate data in Oracle Database using RESTful web services. According to the Oracle documentation2, "Oracle REST Data Services (ORDS) bridges HTTPS and your Oracle Database. A mid-tier Java application, ORDS provides a Database Management REST API, SQL Developer Web, a PL/SQL Gateway, SODA for REST, and the ability to publish RESTful Web Services for interacting with the data and stored procedures in your Oracle Database."
NEW QUESTION # 58
Which is NOT a prerequisite for patching Grid Infrastructure or database homes when using the console?
- A. All database compute nodes of the VM cluster are up and running.
- B. The /u01 directory on the database host file system has at least 15 GB of free space for the execution of patching processes.
- C. The required patch is available on the Control Plane server.
- D. Oracle Clusterware is down on the VM cluster.
Answer: D
Explanation:
This statement is not a prerequisite for patching Grid Infrastructure or database homes when using the console. According to the Oracle documentation8, "Before you patch Grid Infrastructure or database homes, ensure that the following prerequisites are met: All database compute nodes of the VM cluster are up and running. The /u01 directory on the database host file system has at least 15 GB of free space for the execution of patching processes. The required patch is available on the Control Plane server." This means that Oracle Clusterware must be up and running on the VM cluster before patching, not down.
NEW QUESTION # 59
Which statement is true about MySQL Database Service?
- A. It is a public cloud service built on MySQL Community Edition.
- B. Its users are responsible for database and operating system patching tasks.
- C. It is a fully managed Oracle Cloud Infrastructure (OCI) native service.
- D. It supports MySQL Enterprise Edition version 5.7 with InnoDB Storage Engine.
Answer: C
Explanation:
This statement is true about MySQL Database Service. According to the Oracle documentation3, "MySQL Database Service is a fully managed Oracle Cloud Infrastructure native service, developed, managed, and supported by the MySQL team in Oracle. Oracle automates tasks such as backup and recovery, and database and operating system patching. You are responsible solely for managing your data, schema designs, and access policies."
NEW QUESTION # 60
Which Oracle Cloud Infrastructure (OCI) service is NOT available as part of Oracle Cloud Free Tier?
- A. Exadata DB Systems
- B. Autonomous Data Warehouse
- C. Monitoring
- D. Compute
Answer: A
Explanation:
Exadata DB Systems is an OCI service that is NOT available as part of Oracle Cloud Free Tier. According to the Oracle website5, "Oracle Cloud Free Tier includes a free time-limited promotional trial that allows you to explore a wide range of Oracle Cloud Infrastructure products, and a set of Always Free offers that never expire." The list of eligible services for the Free Tier does not include Exadata DB Systems, which is a high-performance database platform that runs on OCI6.
NEW QUESTION # 61
Which Oracle Cloud Infrastructure storage platform is used by MySQL Database Service for all data storage?
- A. Object Storage
- B. File Storage
- C. Archive Storage
- D. Block Volume Storage
- E. Flash Local Storage
Answer: E
NEW QUESTION # 62
The Demand Side is data that is active and does something. What two data services are typi-cally part of the demand side? (Choose all correct answers)
- A. Inert algorithms
- B. Authorization
- C. Data Models
- D. Payloads
Answer: C,D
NEW QUESTION # 63
Oracle Cloud and Microsoft Azure have an interconnect for workloads across cloud. Which two are also benefits this partnership and interconnect provide? (Choose all correct answers)
- A. Unified identity and access management
- B. Upgrade compliance
- C. Connection to other multicloud environments
- D. Low Latency
Answer: A,D
Explanation:
These are two benefits that the partnership and interconnect between Oracle Cloud and Microsoft Azure provide. According to the Oracle website1, the partnership enables the following benefits:
A secure intercloud connection that bypasses the public internet
High availability and reliability through redundant 10-Gbps physical connections Predictable cross-cloud network performance One time setup without the need for any intermediate network provider Unified identity and access management platform that leads to cost savings The unified identity and access management platform allows customers to use a single identity provider to access resources in both clouds, simplifying the authentication and authorization process. The low latency is achieved by the direct interconnection between the two clouds, which provides less than two seconds of latency for superior multicloud network performance2.
NEW QUESTION # 64
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?
- A. File Storage
- B. Block Volume
- C. Object Storage (standard)
- D. Archive Storage
Answer: C
NEW QUESTION # 65
What are the two main features of APEX's low code platform? (Choose all correct answers)
- A. Limited productivity
Build scalable web apps for MongoDB - B. Use graphical user interfaces and configuration
- C. Use traditional computer programming paradigms
- D. Focus on business requirements
- E. Simplified core-based licensing
Answer: B,D
Explanation:
Use graphical user interfaces and configuration and focus on business requirements are two main features of APEX's low code platform. According to the Oracle website, "Oracle APEX is a low-code development platform that enables you to build scalable, secure enterprise apps with world-class features that can be deployed anywhere. With APEX, you can create modern web apps with minimal coding using intuitive graphical interfaces and declarative configuration." Additionally, according to the Oracle website, "Oracle APEX empowers developers to focus on solving business problems rather than building low-level code."
NEW QUESTION # 66
......
Free 1z0-1105-23 braindumps download: https://www.pdftorrent.com/1z0-1105-23-exam-prep-dumps.html