[2024年08月11日] 無料Oracle Cloud 1z0-931-23公式認定ガイドPDFダウンロード
Oracle 1z0-931-23公式認定ガイドPDF
質問 # 109
Which two cloud services are supported to import data pump files from using Dedicated Exadata Infrastructure? (Choose two.)
- A. Google Cloud Storage
- B. Oracle Cloud Infrastructure Object Storage Classic
- C. Azure Blob Storage
- D. Oracle Cloud Infrastructure Object Storage
- E. Amazon S3
正解:B、D
解説:
Reference:
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpud/load-data-using-oracle-data-pump.html#GUID-
025C4566-1BDB-4EF2-BFB7-0CBA8C47EA5D
Data Pump Import lets you import data from Data Pump files residing on the Oracle Cloud Infrastructure Object Storage and Oracle Cloud Infrastructure Object Storage Classic.
You can save your data to your Cloud Object Store and use Oracle Data Pump to load data to Autonomous Database.
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbbk/#articletitle
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbbk/index.html#ADBBK-GUID-37922C56-0412-45CD-B10C-2088A000113F
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbdu/use-oracle-data-pump.html#GUID-F8897403-2DE2-447E-94DC-768C9ABB05AF
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbdu/use-oracle-data-pump.html#GUID-F8897403-2DE2-447E-94DC-768C9ABB05AF
質問 # 110
Which statement is FALSE regarding provisioning an Autonomous Database and configuring private endpoints with security rules to allow incoming and outgoing traffic to and from the Autonomous Database Instance?
- A. A stateless ingress rule is created to allow connections from the source to the Autonomous Database instance
- B. The destination port range is set to 1522
- C. The IP Protocol is set to TCP
- D. The source is set to the address range you want to allow to connect to your database
正解:A
質問 # 111
Which are the two restrictions for an Always Free Autonomous Database?
- A. supports only ATP as a workload type
- B. Oracle Application Express (APEX) not included
- C. maximum of one OCPU per Database
- D. maximum of two Always Free Databases per OCI tenancy
正解:C、D
質問 # 112
You need to set up a notification for a scheduled shutdown of an Autonomous Database instance. What should you do?
- A. Create a notification alert using DBMS_SNMP package
- B. Create an Oracle Cloud Infrastructure Alarm for Shutdown metric
- C. Create a rule for the Oracle Cloud Infrastructure Event for "Autonomous Database STOP END"
- D. Add a "BEFORE SHUTDOWN ON DATABASE" trigger within the database
正解:C
解説:
質問 # 113
You need to create a new database via the Oracle Cloud Infrastructure (OCI) CLI with the following requirements:
* Autonomous Transaction Processing
* License Included
* Shared Infrastructure
Which parameter would you NOT use?
- A. db-workload
- B. license-model
- C. is-dedicated
- D. db-type
正解:C
解説:
https://docs.oracle.com/en-us/iaas/tools/oci-cli/2.9.9/oci_cli_docs/cmdref/db/autonomousdatabase/ create.html
質問 # 114
Which statement is not correct when the Autonomous Database is stopped?
- A. User with DWROLE can still access the database
- B. Tools are no longer able to connect to a stopped instance
- C. In-flight transactions queries are stopped
- D. CPU billing is halted
正解:A
質問 # 115
When enabling auto-scaling, which three options do not change?
- A. I/O resources
- B. Level of concurrency
- C. Amount of storage
- D. Number of OCPUs displayed in the console.
- E. parallelism settings
正解:B、C、E
解説:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/autonomous-auto-scale.html#GUID-27FAB1C1-B09F-4A7A-9FB9-5CB8110F7141
質問 # 116
Which three security features are available in Oracle Autonomous Database Shared Infrastructure?
- A. Database Vault
- B. Data Redaction
- C. Customer Managed Keys
- D. Transparent Data Encryption
- E. Audit Vault
正解:A、C、D
解説:
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpfg/security-features-adb1.html#GUID-89E3C22E-D4EB-472B-8287-41682C2B61B3
質問 # 117
Which two statements are true about using an Oracle Autonomous Database with private endpoints?
- A. You can configure private endpoints for an Always Free Autonomous Database
- B. Private endpoints can be configured when you clone an Autonomous Database on Shared Infrastructure that was initially created with public endpoints
- C. A Network Security Group (NSG) is required within your virtual cloud network before you can provision a Shared Autonomous Database to use private endpoints
- D. An Autonomous Database with private endpoints can be accessed from the public Internet by adding your IP address to an Access Control List (ACL)
正解:B、C
質問 # 118
Which statement is correct about management operations on Autonomous Database on Shared. Infrastructure?
- A. You can choose to use Release Update (RU) or Release Update Revision (RUR) updates for your Autonomous Databases on Shared Infrastructure
- B. You cannot configure the scheduling 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 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
質問 # 119
Which two optimizations are different between Autonomous Data Warehouse and Autonomous Transaction Processing?
- A. Memory Usage
- B. Data Organization
- C. Undo Management
- D. Index Storage
- E. Backup Retention
正解:A、D
質問 # 120
Which two statements apply to the Autonomous Database service on Dedicated Infrastructure?
- A. You can set a maintenance window for each individual Autonomous Container Database
- B. You can set a maintenance window for an Autonomous Exadata Infrastructure
- C. Patching occurs on the first Sunday of each quarter
- D. You, as the customer, are responsible for all patching operations
正解:A、B
質問 # 121
Which statement is true when the Autonomous Database has auto scaling enabled?
- A. Increases the number of sessions available to the database.
- B. Enables the database to use up to 3x CPU/IO resources immediately when needed by the workload.
- C. Database concurrency is scaled up when needed by the workload.
- D. Scales the PGA and SGA size when needed for the workload.
正解:B
質問 # 122
Which two statements are true about Recovery Time Objective (RTO) and Recovery Point Objective (RPO) for Autonomous Data Guard?
- A. RPO is adjustable, but RTO I always 5 minutes
- B. RTO and RPO are adjustable through the OCI console
- C. RPO is 0 minutes for an automatic failover
- D. RTO and RPO are 0 minutes for manual failovers
- E. RTO is 2 minutes for an automatic failover
正解:C、E
質問 # 123
You created an Autonomous Database without auto scaling. Which two ways can you enable auto scaling?
- A. Use a REST call to enable Auto Scaling
- B. Click Scale Up/Down and select the Auto Scaling checkbox
- C. Use a REST call to shut down the instance, then a second REST call to enable Auto Scaling, and a REST all to restart the instance
- D. Shut down the instance, click Scale Up/Down and select the Auto Scaling checkbox, then restart the instance
正解:A、B
質問 # 124
Oracle Data Safe is a unified control center for your Oracle databases which helps you understand the sensitivity of your data, evaluate risks to data, mask sensitive data, implement and monitor security controls, assess user security, monitor user activity, and address data security compliance requirements.
Which statement is FALSE?
- A. Oracle Data Safe evaluates user types, how users are authenticated, and the password policies assigned to each user.
- B. Oracle Data Safe only supports Autonomous Databases.
- C. Oracle Data Safe helps you assess the security of your cloud database configurations by analyzing database configurations.
- D. Oracle Data Safe helps you find sensitive data in your database by inspecting the actual data in your database and its data dictionary.
正解:B
解説:
https://www.oracle.com/database/technologies/security/data-safe.html
https://www.oracle.com/a/tech/docs/dbsec/data-safe/faq-security-data-safe.pdf Data Safe works with the following Oracle Databases Oracle on-Premises Databases Oracle Cloud Databases
− Autonomous Database on Shared Exadata Infrastructure
− Autonomous Database on Dedicated Exadata Infrastructure
− Exadata DB systems
− Database Cloud Service on Virtual Machine
− Database Cloud Service on Bare Metal
− Oracle Database on Compute
質問 # 125
Which two actions are available to perform when an Autonomous Database is stopped?
- A. Update Network Access
- B. Change administrator password
- C. Update License Type
- D. Start
正解:C、D
質問 # 126
While Autonomous Transaction Processing and Autonomous Data Warehouse use the same Oracle database, which statement is true about the workloads?
- A. Autonomous Transaction Processing workloads are optimized for data warehouse, data mart, and data lake.
- B. Autonomous Data Warehouse workloads are optimized for mixed workloads.
- C. Data that is bulk loaded, by default, uses the row format in Autonomous Transaction Processing where Autonomous Data Warehouse data format is columnar.
- D. Autonomous Transaction Processing memory usage optimizes workloads for parallel joins and aggregations.
正解:C
解説:
- Both ADW and ATP share the Autonomous Database platform of Oracle Database on Exadata Cloud infrastructure.
The difference is how the services have been optimized within the database. When you start loading data into the autonomous database, we store the data in the appropriate format for the workload.
* If it is ADW, then we store data in columnar format because that's the best format for analytics processing.
* If it is ATP, then we store the data in row format because that's the best format for fast single row lookups.
- Oracle Autonomous Database is offered in two workload-optimized flavors
* Autonomous Data Warehouse (ADW), which has been optimized for analytic workloads
* Autonomous Transaction Processing (ATP). ATP is optimized for transaction processing or mixed workload
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/autonomous-intro-atp.html#GUID-B90147B2-EA04-4147-9606-0413D9CC1589
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/autonomous-intro-atp.html#GUID-B90147B2-EA04-4147-9606-0413D9CC1589
質問 # 127
Which three methods can be used to migrate your existing Oracle database to Autonomous Database? (Choose three.)
- A. Use Oracle Zero Downtime Migration (ZDM)
- B. Use Recovery Manager (RMAN)
- C. Use SFTP to copy CSV files into Autonomous Database
- D. Use Data Pump
- E. Use GoldenGate
正解:A、D、E
解説:
https://www.oracle.com/sa/database/technologies/cloud-migration.html
質問 # 128
Which three options are supported when migrating to Autonomous Database (ADB)? (Choose three.)
- A. Golden Gate Cloud service
- B. Golden Gate on-premise installation
- C. PDB unplug / plug operation
- D. RMAN Cross-Platform backup and restore
- E. Dataguard Physical Standby
- F. Datapump export / import
正解:A、B、F
解説:
Reference:
https://k21academy.com/1z0-931/migrate-database-to-oracle-autonomous-database-cloud-optionsdata-pump-sql-loader-dbms_cloud-goldengate/
質問 # 129
Who, and in which order, provisions dedicated Exadata Infrastructure resources?
- A. The fleet administrator provisions the Autonomous Exadata Infrastructure and then the Autonomous Container DB. Then, the database administrator provisions the Autonomous DB
- 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 database administrator provisions the Autonomous Container DB and the Autonomous DB Then, the feet administrator provisions the Autonomous Exadata Infrastructure
- D. The database administrator provisions the Autonomous Exadata Infrastructure. Then, the fleet administrator provisions the Autonomous Container DB and then the Autonomous DB
正解:A
質問 # 130
......
無料1z0-931-23試験問題集試験点数を伸ばそう:https://jp.fast2test.com/1z0-931-23-premium-file.html