1z0-1105-23問題集でリアル試験問題でテストエンジン問題集でトレーニング
Oracle 1z0-1105-23テスト問題集とオンライン試験エンジン
質問 # 28
Which component is NOT included as part of an Oracle NoSQL table Oracle Cloud Identifier (OCID)?
- A. Region
- B. Resource type
- C. Unique ID
- D. Compartment ID
正解：C
質問 # 29
Where should you store unstructured, high volume data sets of unknown value for best price/performance?
- A. OCI Object Storage
- B. OCI Data Catalog
- C. OCI Data Flow
- D. OCI GoldenGate
正解：B
質問 # 30
What are three platforms where Oracle's Autonomous Database service can be deployed? (Choose all correct answers)
- A. AWS Cloud at Customer
- B. Oracle Public Cloud at Customer
- C. Hybrid Cloud Configurations
- D. Dedicated Region Cloud at Customer
- E. Oracle Cloud Infrastructure
正解：B、C、D
質問 # 31
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?
- A. File Storage
- B. Block Volume
- C. Archive Storage
- D. Object Storage (standard)
正解：D
解説：
Object Storage (standard) is the OCI storage service that can be used to store application backups which can be stored for months, but retrieved immediately based on business needs. According to the Oracle documentation1, "Object Storage is a highly scalable, durable, and available cloud-based storage service that provides a cost-effective way to store and manage large amounts of unstructured data such as images, videos, and log files. Object Storage supports standard HTTP operations such as GET, PUT, and DELETE, as well as advanced features such as encryption, data replication, lifecycle policies, and pre-authenticated requests." Object Storage (standard) offers high performance and low latency for frequent data access.
質問 # 32
Which two are key characteristics of Oracle Autonomous Database? (Choose all correct an-swers)
- A. Oracle manages everything
- B. Higher cost
- C. Lower cost
- D. Customer manages everything
- E. Less automated
正解：A、C
解説：
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.
質問 # 33
Which tool allows users to execute SQL statements, create relational models, load data, and monitor SQL queries from your browser?
- A. SQL Developer
- B. Service Console
- C. Database Actions
- D. OCI Operational Insights
- E. Enterprise Manager
正解：A
質問 # 34
Which Oracle Cloud Infrastructure (OCI) service is NOT available as part of Oracle Cloud Free Tier?
- A. Compute
- B. Autonomous Data Warehouse
- C. Monitoring
- D. Exadata DB Systems
正解：D
解説：
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.
質問 # 35
What security control area determines if there is sensitive data in a system?
- A. Detect
- B. Assess
- C. Protect
- D. Users
正解：B
解説：
Assess is the security control area that determines if there is sensitive data in a system. According to the Oracle documentation2, "The Assess security control area includes activities that help you identify and classify sensitive data, assess your security posture, and monitor compliance with security standards and regulations."
質問 # 36
What is a main feature of APEX's low code platform?
- A. Build scalable web apps for MongoDB
- B. Limited productivity
- C. Simplified core-based licensing
- D. Use graphical interfaces and configuration for building web applications
- E. Use traditional computer programming paradigms
正解：D
解説：
Use graphical interfaces and configuration for building web applications is a main feature of APEX's low code platform. As mentioned earlier, 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."
質問 # 37
Which is NOT an option in Database Actions to load data into Autonomous Database?
- A. Load data from cloud storage (Oracle, S3, Azure, Google)
- B. Load data from a remote database
- C. Load data from a local file such as text or Excel
- D. Load data using Data Pump
- E. Load data using FTP
正解：E
解説：
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.
質問 # 38
Which two target database environments provide both high availability (HA) and disaster re-covery (DR) options in the cloud? (Choose all correct answers)
- A. Compute VM
- B. Exadata Cloud Service
- C. Streaming Service
- D. Autonomous Database
正解：B、D
解説：
Exadata Cloud Service and Autonomous Database are two target database environments that provide both high availability (HA) and disaster recovery (DR) options in the cloud. Exadata Cloud Service is a fully managed Oracle Database service that runs on Exadata infrastructure in the cloud. It offers high performance, scalability, availability, security, and reliability for all types of database workloads. It also supports various HA and DR options, such as Oracle Real Application Clusters (RAC), Oracle Data Guard, Oracle Active Data Guard, Oracle GoldenGate, and Oracle Zero Data Loss Recovery Appliance Cloud Service. Autonomous Database is a self-driving, self-securing, and self-repairing cloud database service that automates provisioning, configuring, securing, tuning, scaling, patching, backing up, and repairing of databases without human intervention. It also provides built-in HA and DR features based on Oracle Maximum Availability Architecture (MAA), such as transparent application continuity, automatic failover to standby databases or regions, automatic backups to object storage, point-in-time recovery using restore points or backups.
質問 # 39
When Customers are using the Exadata Cloud Service, what are they responsible fo managing?
- A. Hypervisor and Internal Fabric
- B. Databases and Customer VM
- C. Host VM and Storage
- D. Internal Fabric and Customer VMs
正解：B
解説：
Customers are responsible for managing databases and customer VMs when they are using the Exadata Cloud Service. According to the Oracle documentation7, "Customers have full control over their databases running on Exadata Cloud Service, including root access for database servers." Additionally, according to the Oracle documentation8, "Customers can create customer VMs on Exadata Cloud Service database servers for their own use."
質問 # 40
Which statement is true about moving virtual machine (VM) database (DB) systems fro one compartment to another?
- A. You have to move dependent resources like Database Homes and databases to the des-tination compartment before moving the VM DB system.
- B. You can move VM DB systems from one compartment to another by only using Oracle Cloud Infrastructure REST APIs.
- C. You do not need access permissions to the compartment that the resource is being moved to when moving VM DB systems to a different compartment.
- D. 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 cur-rent compartment.
正解：D
解説：
This statement is true about moving VM DB systems from one compartment to another. According to the Oracle documentation3, "To move resources between compartments, resource users must have sufficient access permissions on the compartment that the resource is being moved to, as well as the current compartment." The documentation also provides a step-by-step guide on how to move a DB system to another compartment using the Oracle Cloud Infrastructure Console.
質問 # 41
Which two locations can be used to store your DB system database backups? (Choose all cor-rect answers)
- A. You can store your DB system database backups locally in the Fast Recovery Area of the DB system.
- B. You can store your DB system database backups in Oracle Cloud Infrastructure Object Storage.
- C. You can store your DB system database backups in on-premises local storage.
- D. You can store your DB system database backups on locally attached block storage vol-umes.
正解：B、C
質問 # 42
Which are two characteristics of Autonomous Transaction Processing (ATP)? (Choose all correct answers)
- A. Focuses on creation of indexes
- B. Creates autonomous data summaries
- C. Statistics are gathered as part of bulk load operations
- D. Optimized for response time
- E. Stores data in columnar format
正解：A、D
解説：
Focuses on creation of indexes and optimized for response time are two characteristics of Autonomous Transaction Processing (ATP). According to the Oracle documentation, "Autonomous Transaction Processing is a database service that is optimized for transaction processing or mixed workloads. It delivers the best experience for mission-critical applications that require high performance, high concurrency, and low latency. Autonomous Transaction Processing automatically creates indexes, materialized views, and partitions based on the workload." Additionally, according to the Oracle documentation, "Autonomous Transaction Processing is optimized for response time. It uses a combination of caching, in-memory columnar format, and result set caching to deliver fast response times."
質問 # 43
Which two are key features of MySQL Database Service?
- A. inter active Documents: Uses a built-in web-based notebook tool for designing and sharing SQL-based data-driven scripts
- B. Regulatory Compliance: Uses advanced security to help clients meet industry and regulatory compliance requirements. including GDPR, PCI, and HIPPA
- C. in Memory Lookups: Avoids unnecessary I/O operations by replacing storage indexes with a few m memory lookups
- D. Integration with Oracle Technologies: Uses a diem s existing Oracle investments and easily integrates MySQL Database Service with Oracle technologies
正解：B、D
質問 # 44
How does the Converged Database help to access data using an API?
- A. The database provides only one universal RES interface which makes integration of applications extremely agile.
- B. Each database comes with a REST-enabled compute instance to provide access to data.
- C. A REST API is automatically generated on top of SQL or stored procedures.
- D. Developer can point their application to the location of ADB Wallet which integration all REST API calls.
正解：C
解説：
This statement is true about how the Converged Database helps to access data using an API. According to the Oracle documentation5, "Oracle REST Data Services (ORDS) makes it easy to develop modern REST interfaces for relational data in the Oracle Database and the Oracle Database 18c JSON Document Store. A mid-tier Java application, ORDS maps HTTP(S) verbs (GET, POST, PUT, DELETE, etc.) to database transactions and returns any results formatted using JSON." ORDS can automatically generate RESTful services for tables and views in the database or expose custom REST APIs using SQL or PL/SQL.
質問 # 45
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. Payloads
- B. Authorization
- C. Data Models
- D. Inert algorithms
正解：A、C
質問 # 46
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. Allow network connections in the Oracle public cloud.
- C. Secure access configured to the customer network.
- D. Operator Access Control can terminate Oracle operator connections.
正解：A、C
質問 # 47
Which ability is NOT provided out of the box with the Autonomous Database Tools set?
- A. Cataloging
- B. Data Loading
- C. Data Labeling
- D. Data Insight
正解：C
解説：
Data Labeling is not a built-in tool provided by Autonomous Database. According to the Oracle documentation4, "Autonomous Database includes built-in tools that you can enable and disable when you provision or clone a database, or at any time for an existing database." The list of built-in tools includes Oracle APEX, Database Actions, Graph Studio, Oracle ML User Interface, Data Transforms, Web Access (ORDS), MongoDB API, and SODA Drivers. Data Labeling is not among these tools.
質問 # 48
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. Archive Storage
- D. Object Storage (standard)
正解：D
質問 # 49
What three typical data types/models are covered by Oracle's Converged Database? (Choose all correct answers)
- A. Terraform
- B. Images
- C. Events
- D. Relational
- E. Spatial
- F. Graph
正解：D、E、F
解説：
Graph, relational, and spatial are three typical data types/models that are covered by Oracle's Converged Database. A converged database is a multi-model, multitenant, multi-workload database that supports the data model and access method each development team wants, without unneeded functionality getting in the way. A graph data model represents data as nodes and edges, and enables complex queries based on relationships and patterns. A relational data model organizes data into tables with rows and columns, and supports SQL queries and transactions. A spatial data model stores and manipulates geometric and geographic data, such as points, lines, polygons, and raster images.
質問 # 50
New hardware innovations of the Exadata X8M allow customers to take advantage of Remote Direct Memory Access (RDMA). What resource does RDMA access?
- A. Storage Disks
- B. Database Servers
- C. Persistent Memory
- D. Compute Instances
正解：C
解説：
Persistent memory is the resource that RDMA accesses in Exadata X8M. According to the Oracle website1, "Exadata X8M uses RDMA over Converged Ethernet (RoCE) to directly access the persistent memory in storage servers, bypassing the OS, IO, and network software stacks. This reduces IO latency by up to 10X compared to the previous generation of Exadata."
質問 # 51
Which is NOT a prerequisite for patching Grid Infrastructure or database homes when using the console?
- A. Oracle Clusterware is down on the VM cluster.
- 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. All database compute nodes of the VM cluster are up and running.
- D. The required patch is available on the Control Plane server.
正解：A
解説：
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.
質問 # 52
What information is required to connect to the NoSQL Database Cloud Service?
- A. signing key fingerprint, API signing key, tenancy OCID
- B. user ID, tenancy ID, component ID
- C. API signing key, admin ID, user ID
- D. tenancy ID, passphrase, handshake key
正解：A
解説：
Signing key fingerprint, API signing key, and tenancy OCID are the information required to connect to the NoSQL Database Cloud Service. According to the Oracle documentation, "To connect your application to Oracle NoSQL Database Cloud Service , obtain your credentials such as the client ID, client secret, and the entitlement ID from the Identity Cloud Service console. After obtaining the credentials, pass the credentials to your application and create tables in Oracle NoSQL Database Cloud Service." The client ID is also known as the signing key fingerprint, and the client secret is also known as the API signing key. The tenancy OCID is a unique identifier for your Oracle Cloud account.
質問 # 53
......
Oracle 1z0-1105-23問題を提供していますOracle Cloud問題集と完璧な解答付き：https://www.passtest.jp/Oracle/1z0-1105-23-shiken.html
信頼され続ける1z0-1105-23試験のコツとPDF試験材料：https://drive.google.com/open?id=1FxldhrBw-MwXvuSMFZ9Fz3NTDvaCAa0d