検証済み!1z0-931-23問題集と解答で1z0-931-23テストエンジン正確解答付き [Q109-Q125]

Share

検証済み!1z0-931-23問題集と解答で1z0-931-23テストエンジン正確解答付き

あなたを必ず合格させる1z0-931-23問題集PDF2024年最新のに更新された183問あります


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

トピック出題範囲
トピック 1
  • Describe the Different Autonomous Database offerings
  • Articulate the key features of Autonomous Database
トピック 2
  • Understand the Oracle Cloud Infrastructure
  • Manage Autonomous Database Shared Backups and Restores
トピック 3
  • Use services in ADB: auto-indexing, data safe, compartment quotas
  • Migrate to Autonomous Database using Data Pump
トピック 4
  • Managing and Maintaining Autonomous Database
  • Create Autonomous Database Shared Instances - provisioning, scaling OCPU and storage
トピック 5
  • Describe Autonomous Database Tools
  • Describe the options and considerations for migrating to Autonomous Database
トピック 6
  • Use Data Load and Data Transforms
  • Use Marketplace Developer image to connect to ADB, use ADW with third-party tools
トピック 7
  • Use Access Control Llist (ACL) and Private End Points
  • Configure Disaster Recovery (Data Guard) - both Shared and Dedicated

 

質問 # 109
How can an Autonomous Database resource be provisioned without logging into the Oracle Cloud Infrastructure console?

  • A. Using Database Configuration Assistant (DBCA) on the database server.
  • B. Using the Oracle Cloud Infrastructure Command Line interface tool or REST API calls.
  • C. Connecting to the Cloud Infrastructure Command console via SSH wallet.
  • D. It cannot be done.

正解:B

解説:
The CLI is a small footprint tool that you can use on its own or with the Console to complete Oracle Cloud Infrastructure tasks. The CLI provides the same core functionality as the Console, plus additional commands.
https://blogs.oracle.com/datawarehousing/managing-autonomous-data-warehouse-using-oci-curl Examples of using Autonomous Database managing by REST API
https://oracle.github.io/learning-library/workshops/autonomous-transaction-processing/LabGuide900ConfigureOCI-CLI.md


質問 # 110
Which three scaling options are available in Oracle Autonomous Database on Shared Infrastructure?

  • A. Manual online scaling of Storage
  • B. Automatic online scaling of OCPU
  • C. Manual online scaling of OCPU
  • D. Automatic online scaling of Storage
  • E. Manual offline scaling of Storage and OCPU

正解:B、D、E


質問 # 111
Which two license types does the customer need to benefit from BYOL when leveraging on-premise Enterprise Database licenses in Oracle Autonomous Database?

  • A. RAC, but only when scaling beyond 16 OCPUs
  • B. Transparent Data Encryption
  • C. Active Data Guard
  • D. Multitenant
  • E. Exadata

正解:A、D

解説:
Refer to https://www.oracle.com/autonomous-database/autonomous-data-warehouse/pricing/ If you run Oracle Database Enterprise Edition and the required options listed below, then your BYOL requirements are as follows:
For 1-16 OCPUs of a single Oracle Autonomous Data Warehouse instance:
For each supported Processor license of Oracle Database Enterprise Edition plus Options: Multitenant, you may activate up to 2 OCPUs of the BYOL Cloud Service.
For every 25 supported Named User Plus licenses of Oracle Database Enterprise Edition plus Options: Multitenant, you may activate 1 OCPU of the BYOL Cloud Service.
For 17 OCPUs or more of a single Oracle Autonomous Data Warehouse:
For each supported Processor license of Oracle Database Enterprise Edition plus Options: Multitenant and Real Application Clusters, you may activate up to 2 OCPUs of the BYOL Cloud Service.
For every 25 supported Named User Plus licenses of Oracle Database Enterprise Edition plus Options: Multitenant and Real Application Clusters, you may activate 1 OCPU of the BYOL Cloud Service.
https://www.oracle.com/database/technologies/datawarehouse-bigdata/adb-faqs.html "Do customers need Exadata licenses to benefit from BYOL?"


質問 # 112
Which statement is FALSE for Oracle Data Safe? (Choose the best answer.)

  • A. Oracle Data Safe helps you assess the security of your cloud database configurations by analyzing database configurations
  • B. Oracle Data Safe helps you find sensitive data in your database by inspecting the actual data in your database and its data dictionary
  • C. Oracle Data Safe only supports Autonomous Databases
  • D. Oracle Data Safe evaluates user types, how users are authenticated, and the password policies assigned to each user

正解:C

解説:


質問 # 113
Which Autonomous Database Service is NOT used to connect to an Autonomous Transaction Processing instance?

  • A. TPURGENT
  • B. HIGH
  • C. TPPERFORMANT
  • D. LOW
  • E. MEDIUM

正解:C

解説:
Predefined Database Service Names for Autonomous Transaction Processing The tnsnames.ora file provided with the credentials zip file contains five database service names identifiable as tpurgent, tp, high, medium, and low. The predefined service names provide different levels of performance and concurrency for Autonomous Transaction Processing.
* tpurgent: The highest priority application connection service for time critical transaction processing operations. This connection service supports manual parallelism.
* tp: A typical application connection service for transaction processing operations. This connection service does not run with parallelism.
* high: A high priority application connection service for reporting and batch operations. All operations run in parallel and are subject to queuing.
* medium: A typical application connection service for reporting and batch operations. All operations run in parallel and are subject to queuing. Using this service the degree of parallelism is limited to four (4).
* low: A lowest priority application connection service for reporting or batch processing operations. This connection service does not run with parallelism.
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/manage-priorities.html#GUID-80E464A7-8ED4-45BB-A7D6-E201DD4107B7


質問 # 114
You see a clock icon in the Status column on the SQL Monitoring tab of Performance Hub. What does it indicate?

  • A. The SQL statement completed its execution.
  • B. The SQL statement is executing.
  • C. The SQL statement is queued.
  • D. The SQL statement did not complete due to an error.

正解:C

解説:
The clock icon indicates that the SQL statement is waiting for resources to execute. This can happen when the database is busy or when the statement has a lower priority than other statements. Reference:
Monitor Databases with Autonomous Database Metrics - Oracle Help Center, section "View Autonomous Database Metrics for a Database", subsection "View SQL Monitoring Details".
Using Oracle Autonomous Database Serverless, section "Monitor Performance", subsection "SQL Monitoring".


質問 # 115
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 skip a scheduled maintenance run. For Autonomous Databases on Shared Infrastructure, you can skip maintenance runs for up to two consecutive quarters if needed
  • C. You can choose to use Release Update (RU) or Release Update Revision (RUR) updates for your Autonomous Databases on Shared Infrastructure
  • D. You cannot configure the scheduling for your Autonomous Databases on Shared Infrastructure

正解:D


質問 # 116
Which DBMS_WORKLOAD_REPOSITORY subprogram procedure can be used to modify the default eight day retention period for Autonomous Database performance data?

  • A. MODIFY_SNAPSHOT_SETTINGS
  • B. UPDATE_OBJECT_INFO
  • C. MODIFY_BACELINE_WINDOW_SIZE
  • D. CREATE_BASELINE_TEMPLATE

正解:A


質問 # 117
In Graph Studio which you can use to create a graph?

  • A. A graph license key
  • B. Graph created by a special tool downloaded from Oracle.com
  • C. NoSQL configuration
  • D. Tables in an Autonomous Database instance
  • E. Graph analytics algorithms

正解:D


質問 # 118
Which set of Oracle Cloud Infrastructure metrics is available only for Autonomous Database on Dedicated Infrastructure?

  • A. IOPS, Storage Space Used By Tablespace, Apply and Transport Lag
  • B. CPU Utilization, Storage Utilization
  • C. Transaction Count, Sessions, Running Statements
  • D. Query Latency, User Calls, Execute Count

正解:A


質問 # 119
When enabling auto-scaling, which three options do not change?

  • A. I/O resources
  • B. Number of OCPUs displayed in the console.
  • C. parallelism settings
  • D. Amount of storage
  • E. Level of concurrency

正解:C、D、E

解説:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/autonomous-auto-scale.html#GUID-27FAB1C1-B09F-4A7A-9FB9-5CB8110F7141


質問 # 120
Which option describes the connection type that third-party software can use to connect to an Autonomous Database (ADB)?

  • A. new ADB-specific protocols
  • B. any protocol supported by Oracle Net Services
  • C. SQL*Net only
  • D. JDBC only

正解:B


質問 # 121
When an administrator rotates the instance wallet for an Autonomous Database on Shared Infrastructure, what happens to the regional wallets used with that instance?

  • A. They revert to pending
  • B. They continue to work
  • C. They become invalid
  • D. They are also rotated

正解:B


質問 # 122
Which statement is true when you provision an Autonomous Database using the cloning method?

  • A. A clone database source can be from a point-in-time backup that is less than 2 hours old.
  • B. When cloning an Autonomous Database, Oracle Machine Learning workspaces, projects, and notebooks of the source database are cloned to the new database.
  • C. A clone database source can be a running database instance.
  • D. After an Autonomous database is created using a clone, the network access option can be changed.

正解:C

解説:


質問 # 123
Which two options are available to restore an Oracle Autonomous Database?

  • A. Use Recovery Manager (RMAN) to connect to Autonomous Database and back it up.
  • B. Select the snapshot of the backup.
  • C. Specify the archived custom image.
  • D. Select the backup from which restore needs to be done.
  • E. Specify the point in time (timestamp) to restore.

正解:D、E


質問 # 124
You are the admin user of an Autonomous Database (ADB) instance. A new business analyst has joined the team and would like to explore ADB tables using SQL Developer Web.
What steps do you need to take?

  • A. Create a database user with connect, resource, and object privileges.
  • B. Create a database user (with connect, resource, object privileges), enable the schema to use SQL Developer and provide the user with the user-specific modified URL.
  • C. Create an IDCS user. Create a database user with connect, resource, and object privileges.
  • D. Create a database user with the default privileges.

正解:B

解説:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/connect-database-actions.html#GUID-55BA432E-098A-48ED-B2EA-F2960A9EF586 To enable a user to access SQL Developer Web, you need to create a database user with the appropriate privileges, enable the schema for SQL Developer Web, and provide the user with the modified URL that includes the schema name. See Enabling Users to Access SQL Developer Web for more details.


質問 # 125
......

合格できるOracle 1z0-931-23試験情報フリー練習テスト:https://www.passtest.jp/Oracle/1z0-931-23-shiken.html

Oracle 1z0-931-23リアル試験問題と解答は無料で試せる:https://drive.google.com/open?id=1tPSZFEOAmyRJnNn55qi6cMxbeuniobbp