1z0-931-23試験問題集合格できるには更新された2024年08月テスト問題集 [Q50-Q71]

Share

1z0-931-23試験問題集合格できるには更新された2024年08月テスト問題集

1z0-931-23テスト問題練習は2024年最新のに更新された183問あります


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

トピック出題範囲
トピック 1
  • Use services in ADB: auto-indexing, data safe, compartment quotas
  • Migrate to Autonomous Database using Data Pump
トピック 2
  • Describe Autonomous Database Tools
  • Describe the options and considerations for migrating to Autonomous Database
トピック 3
  • Managing and Maintaining Autonomous Database
  • Create Autonomous Database Shared Instances - provisioning, scaling OCPU and storage
トピック 4
  • Use Access Control Llist (ACL) and Private End Points
  • Configure Disaster Recovery (Data Guard) - both Shared and Dedicated
トピック 5
  • Monitor Autonomous Database Shared instances - events and alarms
  • Describe Autonomous Database architecture, integrations, and license types
トピック 6
  • Describe the Different Autonomous Database offerings
  • Articulate the key features of Autonomous Database
トピック 7
  • Monitor ADB performance and set up service notifications
  • Describe ADB Dedicated and ADB Cloud@Customer resources, workflows, and functionality
トピック 8
  • Use ADB connectivity: Wallets, service handles
  • Manage Autonomous Database instances: REST APIs, OCI CLI, moving resources

 

質問 # 50
An Autonomous Database (ADB) user with an instance wallet has left the company and they shared a database user id with other users when accessing ADB.
Other than changing the shared user password, what can the admin do to protect the instance?

  • A. Shutdown and restart the instance.
  • B. Delete the user.
  • C. Rotate the instance wallet and share the new wallet with the remaining users.
  • D. Trust the user who left to not access the database.

正解:C


質問 # 51
Which two statements are true about Recovery Time Objective (RTO) and Recovery Point Objective (RPO) for Autonomous Data Guard?

  • A. RTO and RPO are 0 minutes for manual failovers
  • B. RTO is 2 minutes for an automatic failover
  • C. RPO is 0 minutes for an automatic failover
  • D. RTO and RPO are adjustable through the OCI console
  • E. RPO is adjustable, but RTO I always 5 minutes

正解:B、C


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

  • A. Regions are dependent on other regions and must be located within five thousand kilometers of each other
  • B. An OCI region is a localized geographic area, and an availability domain is one or more data centers located within a region
  • C. A single fault domain can be associated with multiple regions and availability domains
  • D. 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、D


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

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

正解:B、C、E


質問 # 54
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 fleet administrator provisions the Autonomous Exadata Infrastructure. Then, the database administrator provisions the Autonomous Container DB and then the Autonomous DB
  • C. The fleet administrator provisions the Autonomous Exadata Infrastructure and then the Autonomous Container DB. Then, the database administrator provisions the Autonomous DB
  • D. The database administrator provisions the Autonomous Exadata Infrastructure. Then, the fleet administrator provisions the Autonomous Container DB and then the Autonomous DB

正解:C


質問 # 55
When using Data Pump to migrate your Oracle database to Autonomous Database, which two objects are imported?

  • A. Schemas
  • B. Data
  • C. Tablespaces
  • D. Reports

正解:A、B

解説:
When using Data Pump to migrate your Oracle database to Autonomous Database, you can import data and schemas from Data Pump files. You cannot import tablespaces or reports. See Export Your Existing Oracle Database to Import into Autonomous Database for more details.


質問 # 56
You are requested to analyze a year's stock purchase data which is stored in Autonomous Data Warehouse instance.
Which tool would you use to automate data exploration and create pivot tables?

  • A. Business Models
  • B. SQL Developer Web
  • C. Data Load
  • D. APEX

正解:C


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

  • A. Oracle Data Safe evaluates user types, how users are authenticated, and the password policies assigned to each user
  • 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 helps you assess the security of your cloud database configurations by analyzing database configurations
  • D. Oracle Data Safe only supports Autonomous Databases

正解:D


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

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

正解:B


質問 # 59
Which three Oracle Cloud Infrastructure (OCI) resources do you need to configure before provisioning your Autonomous Database with Private Endpoint?

  • A. Subnet
  • B. Network Security Group
  • C. VCN
  • D. Security List
  • E. Route Table

正解:A、B、C

解説:
To provision an Autonomous Database with a private endpoint, you must have the following resources already created:
A VCN within the region that will contain your Autonomous Database with shared Exadata infrastructure. Cannot be changed after provisioning.
A private subnet within your VCN configured with default DHCP options. Cannot be changed after provisioning.
At least 1 network security group (NSG) within your VCN for the Autonomous Database. Can be changed or edited after provisioning.
https://docs.oracle.com/en-us/iaas/Content/Database/Concepts/adbsprivateaccess.htm


質問 # 60
In the Autonomous Database (ADB) Dedicated service, what does the fleet administrator use to control OCPU utilization?

  • A. SQL Developer Web Console
  • B. Compartment quotas
  • C. Oracle Machine Learning notebook
  • D. Resource Manager settings

正解:B

解説:
https://docs.oracle.com/en-us/iaas/Content/Database/Concepts/adboverview.htm


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

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

正解:B、D、E

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


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

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

正解:B、C


質問 # 63
Which two statements are correct about Autonomous Data Warehouse on Shared Exadata Infrastructure?

  • A. Parallelism is not enabled by default.
  • B. You have direct access to the database node.
  • C. Oracle Database Result Cache is enabled by default for all SQL statements.
  • D. Compression is enabled by default. Autonomous Data Warehouse uses Hybrid Columnar Compression for all tables by default.

正解:C、D

解説:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/appendix-autonomous-database-data-warehouse-workload.html#GUID-604A08F8-8021-43CE-AA95-823045E14BD8


質問 # 64
You are requested to analyze a year's stock purchase data which is stored in Autonomous Data Warehouse instance.
Which tool would you use to automate data exploration and create pivot tables?

  • A. Business Models
  • B. SQL Developer Web
  • C. Data Load
  • D. APEX

正解:C

解説:


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

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

正解:B


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

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

正解:C

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


質問 # 67
How do you change the tablespace quota for user MTHEO on Autonomous Database on Shared Infrastructure?

  • A. Execute alter database for user MTHEO tableapace DATA quota = 10G;
  • B. Execute alter user MTHEO quota unlimited on tablespace DATA;
  • C. Execute DBMS_CLOUD_ADMIN.GRANT_TABLESPACE_QUOTA (username = MTHEO', V U tablespace_quota -> UNLIMITED');
  • D. Execute alter tablespace DATA det quota = 10G;

正解:C


質問 # 68
Your customer wants to permanently disable scheduled maintenance on Autonomous Dedicated Infrastructure to keep their current database version(s).
How can they achieve this?

  • A. Change the Automatic Maintenance Schedule to 'No Preference'.
  • B. You cannot permanently disable scheduled Automatic Maintenance.
  • C. Change the Automatic Maintenance Schedule to 'None'd.
  • D. Change the Automatic Maintenance Schedule to 'Specify a Schedule' but do not select any month, week or day.

正解:B

解説:
"If the Autonomous Exadata Infrastructure resource doesn't have a customized schedule, its maintenance schedule will be automatically modified so that it precedes the Autonomous Container Database schedule you define."
https://docs.oracle.com/en/cloud/paas/autonomous-database/atpfg/change-maintenance-scheduleacd.html#GUID-CA028A37-5510-473E-B4D0-A5D454B8DA6E


質問 # 69
Which API is NOT available for developing with spatial on ADB?

  • A. Python
  • B. Java
  • C. REST
  • D. PL/SQL Gremlin

正解:D

解説:
PL/SQL Gremlin is not an API for developing with spatial on ADB, but rather an API for developing with property graphs on ADB5. Spatial is a feature of ADB that allows developers and analysts to use spatial analysis in every application from basic spatial search and analysis to advanced geospatial applications and Geographic Information Systems (GIS)6. The APIs available for developing with spatial on ADB are REST, Python, Java, and PL/SQL7. Reference:
Oracle Autonomous Database - Oracle Autonomous Database, section "Graph Analytics", subsection "Property Graphs".
Oracle Autonomous Database - Oracle Autonomous Database, section "Spatial".
Oracle Autonomous Database - Oracle Autonomous Database, section "Spatial", subsection "Spatial APIs".


質問 # 70
Which Autonomous Database Cloud service ignores hints in SQL Statements by default?

  • A. Neither service ignores hints by default
  • B. Autonomous Data Warehouse
  • C. Autonomous Transaction Processing
  • D. Both services ignore hints by default

正解:B

解説:


質問 # 71
......

正真正銘の1z0-931-23問題集には100%合格率練習テスト問題集:https://www.passtest.jp/Oracle/1z0-931-23-shiken.html

更新されたプレミアム1z0-931-23試験エンジンPDF:https://drive.google.com/open?id=1RQzVvVik8fpOgqvFtm_kBpeJ4TL3qQJq