[2024年02月]更新の1z0-931-23試験資料Oracle学習ガイド [Q83-Q104]

[2024年02月]更新の1z0-931-23試験資料Oracle学習ガイド

有効な問題最新版を試そう1z0-931-23テスト解釈1z0-931-23有効な試験ガイド

Oracle 1z0-931-23 認定試験の出題範囲：

トピック	出題範囲
トピック 1	Autonomous Database共有インスタンスの監視 - イベントとアラーム Autonomous Databaseのアーキテクチャ、統合、およびライセンス・タイプについて説明します
トピック 2	データロードとデータ変換を使用する Marketplace Developer イメージを使用して ADB に接続し、サードパーティツールで ADW を使用する
トピック 3	Autonomous Databaseツールの説明 Autonomous Databaseへの移行のオプションと考慮事項について説明します
トピック 4	ADBのサービスの使用: 自動インデックス作成、データセーフ、コンパートメントクォータ Data Pumpを使用したAutonomous Databaseへの移行
トピック 5	ADB接続の使用: ウォレット、サービス・ハンドル Autonomous Databaseインスタンスの管理: REST API、OCI CLI、リソースの移動

質問 # 83
Which three are use cases for Graph Studio? (Choose three.)

A. Facial recognition
B. 3-D modelling
C. Clustering
D. Churn analysis
E. Pattern matching

正解：B、C、E

質問 # 84
Which statement is correct about managing and monitoring of Autonomous Database?

A. You can use Service console to create manual backups of Autonomous database.
B. You can use Service console to enable or disable auto scaling of Autonomous DB.
C. You can use Service console to move Autonomous DB between compartments.
D. You can use Service console to manage runaway SQL statements on Autonomous DB.

正解：D

解説：
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/manage-sql-statements.html#GUID-4861BA7F-F9FA-4909-8DC0-4F46AFF80706

質問 # 85
Which two optimizations are different between Autonomous Data Warehouse and Autonomous Transaction Processing?

A. Undo Management
B. Index Storage
C. Data Organization
D. Memory Usage
E. Backup Retention

正解：B、D

質問 # 86
You need to create a new database by using the Oracle Cloud Infrastructure (OCI) Command Line Interface (CLI) with the following requirements:
* Autonomous Transaction Processing
* Licence Tracluded
* Shared Infrastructure
Which parameter would you NOT use?

A. is-dedicaced
B. licence-model
C. db-workload
D. db-type

正解：D

質問 # 87
Which three event types are supported for Autonomous Database?

A. Terminate End
B. Change Compartment Begin
C. Change Autoscaling Configuration Compartment
D. Update IORM Begin
E. Maintenance Begin

正解：A、B、E

解説：
https://docs.oracle.com/en-us/iaas/Content/Events/Reference/eventsproducers.htm

質問 # 88
You need to set up a notification for a scheduled shutdown of an Autonomous Database instance. What should you do?

A. Create an Oracle Cloud Infrastructure Alarm for Shutdown metric
B. Create a rule for the Oracle Cloud Infrastructure Event for "Autonomous Database STOP END"
C. Add a "BEFORE SHUTDOWN ON DATABASE" trigger within the database
D. Create a notification alert using DBMS_SNMP package

正解：B

解説：

質問 # 89
Data Guard is enabled for your Autonomous Database and the Lifecycle State field for the primary database indicates that it is stopped.
Which statement is true?

A. The standby database is also stopped.
B. Failover is automatically initiated.
C. The standby database is terminated.
D. Switchover is automatically initiated.

正解：A

質問 # 90
Which two Oracle Cloud Infrastructure (OCI) resources do you need to create before initiating a manual backup of Oracle Autonomous Database?

A. Auth Token
B. Service Gateway
C. Backup Job
D. Storage Gateway
E. Object Storage Bucket

正解：A、E

質問 # 91
Which two statements are true about Oracle Cloud Infrastructure (OCI)?

A. Because availability domains do not share infrastructure, such as power or cooling, or the Internal availability domain network, a failure at one availability domain within a region is u likely to impact the availability of the there within the same region
B. Regions are dependent on other regions and must be located within five thousand kilometers of each other
C. An OCI region is a localized geographic area, and an availability domain is one or more data centers located within a region
D. A single fault domain can be associated with multiple regions and availability domains

正解：A、C

質問 # 92
Which four file formats are supported when loading data from Cloud Storage?

A. DDL
B. AVRO
C. JSON
D. Dcsv
E. DOC
F. Parquet

正解：B、C、D、F

質問 # 93
Which subset of services is offered via OCI-CLI (command line interface) for Autonomous Database (ADB) via calls made to the OCI APIs?

A. Create, Query, Update, List, Start
B. Create, Get, List, Stop, Restore
C. Create, Query, List, Stop, Restore
D. Start, Delete, Update, Query, Stop

正解：B

解説：
OCI-CLI is a command line interface tool that can be used to interact with Oracle Cloud Infrastructure services, including Autonomous Database. The OCI-CLI provides commands for creating, getting, listing, stopping, and restoring Autonomous Database instances. These commands are documented in the autonomous-database section of the OCI-CLI Command Reference1. Reference:
Command Line Interface (CLI) - Oracle Help Center, section "autonomous-database".
autonomous-database - OCI CLI Command Reference 3.34.0 documentation - Oracle.

質問 # 94
Which are the two restrictions for an Always Free Autonomous Database?

A. maximum of one OCPU per Database
B. supports only ATP as a workload type
C. Oracle Application Express (APEX) not included
D. maximum of two Always Free Databases per OCI tenancy

正解：A、D

質問 # 95
What is the number of concurrent statements that can be handled by the medium database service name?

A. 1-25 X OCPU
B. unlimited
C. OS
D. 20 X OCPU

正解：A

質問 # 96
Which three are Oracle-recommended best practices for Autonomous Database alarms?

A. Create multiple alarm metrics.
B. Select the correct alarm interval for your metric.
C. Use a single interval for all alarms.
D. Routinely tune your alarms.
E. Create a single alarm for each metric.
F. Suppress alarms during investigations.

正解：B、D、F

質問 # 97
Which can be Scaled Independently of the number of CPUs In an Autonomous Database?

A. Memory
B. Parallelism
C. Sessions
D. Storage
E. Concurency

正解：D

解説：
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/autonomous-key-features.html#GUID-7D0627D9-1B40-40B1-865A-84FF65A65846 Key Features Fully elastic scaling: Scale compute and storage independently to fit your database workload with no downtime:

質問 # 98
You have an Autonomous Transaction Processing Database with three OCPUs and auto scaling turned on and your application is using the TPURGENT service.
The load on the database increases from three OCPUs to nine OCPUs.
What is the total number of concurrent statements that the TPURGENT service can support?

A. 0
B. 1
C. 2
D. 3

正解：D

解説：
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/manage-priorities.html#GUID-6E4DCD27-CDAA-432D-A90B-485C19EF72B0 It's 300x the number of OCPUs for TPURGEN

質問 # 99
Which stage of the indexing pipeline divides text into tokens?

A. SECTIONER
B. FILTER
C. LEXER
D. Otokenizer

正解：C

質問 # 100
Which statement is correct about management operations on Autonomous Database on Shared. Infrastructure?

A. You can perform a "rolling restart" on all the Autonomous Databases. During a rolling restart, each node of an Autonomous Database is restarted separately while the remaining nodes continue to be available
B. You can choose to use Release Update (RU) or Release Update Revision (RUR) updates for your Autonomous Databases on Shared Infrastructure
C. You can skip a scheduled maintenance run. For Autonomous Databases on Shared Infrastructure, you can skip maintenance runs for up to two consecutive quarters if needed
D. You cannot configure the scheduling for your Autonomous Databases on Shared Infrastructure

正解：D

質問 # 101
Which two cloud services are supported to import Data Pump files to Autonomous Database on Dedicated Infrastructure?

A. Amazon S3
B. Google Cloud Storage
C. Azure Blob Storage
D. Oracle Cloud Infrastructure Object Storage
E. Oracle Cloud Infrastructure Object Storage Classic

正解：D、E

質問 # 102
Who, and in which order, provisions dedicated Exadata Infrastructure resources?

A. The database administrator provisions the Autonomous Container DB and the Autonomous DB Then, the feet administrator provisions the Autonomous Exadata Infrastructure
B. The database administrator provisions the Autonomous Exadata Infrastructure. Then, the fleet administrator provisions the Autonomous Container DB and then the Autonomous DB
C. The fleet administrator provisions the Autonomous Exadata Infrastructure. Then, the database administrator provisions the Autonomous Container DB and then the Autonomous DB
D. The fleet administrator provisions the Autonomous Exadata Infrastructure and then the Autonomous Container DB. Then, the database administrator provisions the Autonomous DB

正解：D

質問 # 103
Which option is not available to access data in an Autonomous JSON Database?