1z0-931-23トレーニング最新認定問題をゲットOracle Cloud合格目指せ2023年11月18日
認定トレーニング1z0-931-23試験問題集テストエンジン
質問 # 20
Which of the following two statements regarding Data Transforms are correct?
- A. Data Transforms allows you to design data transformations in the form of data loads, data flows, and workflows
- B. All capabilities to transform data in ODI Classic are available with ODI Web Edition
- C. Workflows for data transforms is only available on the ODI Web Edition
- D. Data Transforms provides access to Oracle Data Integrator (ODI) Web Edition
正解：A、D
質問 # 21
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. db-workload
- C. licence-model
- D. db-type
正解：D
質問 # 22
Which statement is FALSE about Autonomous Database maintenance on Dedicated Infrastructure?
- A. If a scheduled container database maintenance run cannot take place, Oracle will automatically reschedules the container database maintenance for the following quarter
- B. You can change your container database maintenance window or reschedule a single container database maintenance run to ensure that your container database maintenance runs follow infrastructure maintenance within the same quarter
- C. Autonomous Exadata infrastructure maintenance runs are for infrastructure patching (including patching of the Exadata grid infrastructure code and operating systems updates) and includes container database patching
- D. Autonomous Exadata infrastructure maintenance takes place at least once each quarter
正解：C
質問 # 23
What infrastructure does the Autonomous Database run on?
- A. VM on Oracle Cloud Infrastructure
- B. Any Oracle Engineered system
- C. Bare-metal on Oracle Cloud Infrastructure
- D. Exadata on Oracle Cloud Infrastructure
正解：D
質問 # 24
What command should you issue to enable application continuity on Autonomous Database Shared Infrastructure?
- A. alter database set application_continuity=true
- B. alter session set application_continuity=true
- C. exec dbms_cloucl_admin. enable_app_cont ( ' <service_name> ' ) ;
- D. alter system set application_continuity=true
正解：C
解説：
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/dbms-cloud-admin.html#GUID-42B9DDB0-12A7-4EE3-9860-30EFA41061E9 If it was asking for Autonomous Database Dedicated Infrastructure, then answer would be execute DBMS_APP_CONT_ADMIN.ENABLE_AC( 'databaseid_tpurgent.adb.oraclecloud.com', 'LEVEL1', 600);
質問 # 25
How do you change the tablespace quota for user MTHEO on Autonomous Database on Shared Infrastructure?
- A. Execute alter tablespace DATA det quota = 10G;
- B. Execute DBMS_CLOUD_ADMIN.GRANT_TABLESPACE_QUOTA (username = MTHEO', V U tablespace_quota -> UNLIMITED');
- C. Execute alter database for user MTHEO tableapace DATA quota = 10G;
- D. Execute alter user MTHEO quota unlimited on tablespace DATA;
正解：B
質問 # 26
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 Transaction Processing memory usage optimizes workloads for parallel joins and aggregations.
- 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 Data Warehouse workloads are optimized for mixed workloads.
正解：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
質問 # 27
Oracle Autonomous Database on Dedicated Infrastructure is composed of which Oracle Cloud resources?
- A. Autonomous Exadata infrastructure, Autonomous Backup, Autonomous Container Database, and Autonomous Database
- B. Fleet Administrator, Database Administrator, Database User, and Autonomous Exadata infrastructure
- C. Oracle Machine Learning Zeppelin Notebook, Autonomous Exadata infrastructure, Fleet Administrator, and Database Administrator
- D. Virtual Cloud Network, Compartments, Policies, and Autonomous Exadata infrastructure
正解：A
質問 # 28
Which statement is FALSE about Oracle Autonomous JSON Database?
- A. JSON data is stored natively in the database
- B. You can promote Autonomous JSON Database to Autonomous Transaction /Processing
- C. There is a 20 GB limit on JSON collection
- D. It supports NoSQL-style, document-centric application
正解：C
質問 # 29
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. is-dedicated
- C. db-type
- D. license-model
正解：B
解説：
https://docs.oracle.com/en-us/iaas/tools/oci-cli/2.9.9/oci_cli_docs/cmdref/db/autonomousdatabase/ create.html
質問 # 30
You are the admin user of an Autonomous Database instance. A new business analyst has joined the team and could like to explore the Autonomous Database tables using Autonomous Database's Data Tools.
Which step should you to perform to enable the new team member?
- A. Create a REST-enabled database user (with connect and object privileges) and grant the U DWROLE role
- B. Create a database user with connect, resource, and object privileges
- C. Create a database user with the default privileges
- D. Create an IDCS user Create a database user with connect, resource, and object privileges
正解：C
質問 # 31
Which statement is correct with respect to required action to move Autonomous Database resources to a different compartment?
- A. Moving an Autonomous Database instance does not include its automatic backups.
- B. Moving the compartment of the Autonomous Database will also move the Autonomous Container Database and Autonomous Exadata Infrastructure.
- C. Autonomous Exadata Infrastructure instances and Autonomous Container Databases have no dependent resources that move with them. Associated (non-dependent) resources remain in their current compartments.
- D. You do not need to have sufficient access permissions on the compartment that the resource is being moved to.
正解：C
解説：
https://docs.oracle.com/en-us/iaas/Content/Database/Concepts/databaseoverview.htm#moveRes
質問 # 32
Which three event types are supported for Autonomous Database?
- A. Update IORM Begin
- B. Terminate End
- C. Change Compartment Begin
- D. Change Autoscaling Configuration Compartment
- E. Maintenance Begin
正解：B、C、E
解説：
https://docs.oracle.com/en-us/iaas/Content/Events/Reference/eventsproducers.htm
質問 # 33
When integrating object storage with autonomous database how effectively oracle uses the files in the object storage?
- A. scan hybrid partition tables
- B. prun column in parquet files
- C. Scan partition tables
- D. prun columns in csv files
正解：C
質問 # 34
Which DBMS_WORKLOAD_REPOSITORY subprogram procedure can be used to modify the default eight day retention period for Autonomous Database performance data?
- A. CREATE_BASELINE_TEMPLATE
- B. MODIFY_BACELINE_WINDOW_SIZE
- C. UPDATE_OBJECT_INFO
- D. MODIFY_SNAPSHOT_SETTINGS
正解：D
質問 # 35
A Corporation is building a web application to allow its customers to schedule service requests online. There is also a need to run operational reports at times during nonpeak hours. The architecture team is debating whether such reports should be run on the online transaction processing (OLTP) database or in a separate data mart. The DBA Manager does not want to add anymore admin responsibility to the team and is looking for a database option that's low to zero maintenance, but meets their strict performance requirements as well
- A. Use Autonomous Data Warehouse (ADW) because operational reporting is a higher priority in this scenario
- B. It is best to build a separate data warehouse, and move the OLTP data on a nightly basis
- C. Use Autonomous Transaction Processing (ATP) with "tpurgent" and "high" TNS services to separate connection types
- D. The application should be deployed on a Kubernetes Cluster because it needs to be highly available
正解：A
質問 # 36
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
正解：B
解説：
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
質問 # 37
Which statement is FALSE regarding database links?
- A. You can call PL/SQL procedures and functions by using a database link
- B. You can connect to a remote database from an Autonomous Database by using a database line
- C. You can connect to an Autonomous Database from a remote database using a database link
- D. You can create a database link from one Autonomous Database to another Autonomous Database instance
正解：A
質問 # 38
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. Data Load
- B. SQL Developer Web
- C. Business Models
- D. APEX
正解：A
質問 # 39
Which four file formats are supported when loading data from Cloud Storage?
- A. CSV
- B. JSON
- C. AVRO
- D. DOC
- E. DDL
- F. Parquet
正解：A、B、C、F
質問 # 40
Your customer has upgraded their on premise 11.2 database to 12.2. During this migration the database was migrated to a pluggable database and is now in production.
How should the customer unplug their database to migrate to Autonomous Database (ADB)?
- A. Unplug into a pdb archive which can be uploaded to object storage.
- B. Pluggable databases cannot be migrated to ADB using plug, unplug or clone.
- C. Create a database link from source database to the ADB environment and clone the PDB.
- D. Unplug to an xml file so database files and xml file can be uploaded to object storage.
正解：B
解説：
Since an ADB database has some restrictions on the object types and Oracle Database Options you need to use a logical migration method rather than a physical one.
The main migration tool for migrating to ADB is Data Pump. You can export your schemas and import them into ADB using Data Pump. To sync up the additional/incremental changes on the source database during the export/import process you can use GoldenGate or GoldenGate Cloud Service to replicate those changes to ADB.
In the current release you cannot use physical migration methods like backup/restore, Data Guard, Pluggable/Unplug , database clones, and transportable tablespaces to move your existing database to ADB.
質問 # 41
What is the number of concurrent statements that can be handled by the medium database service name?
- A. OS
- B. 20 X OCPU
- C. unlimited
- D. 1-25 X OCPU
正解：D
質問 # 42
Which vaults are used for storing customer-managed encryption keys for Autonomous Database on Dedicated Infrastructure?
- A. Oracle Cloud Infrastructure Vault, Oracle Database Vault
- B. Oracle Key Vault, Oracle Cloud Infrastructure Vault
- C. Oracle Database Vault, Oracle Key Vault
- D. Oracle Audit Vault, Oracle Key Vault
正解：A
質問 # 43
According to Oracle documentation, it is a best practice when planning and instituting Access Controls for your Autonomous Dedicated environment regarding Subnets, Compartments and User Groups.
Which statement is true?
- A. Only 1 of each is allowed to be allocated per environment.
- B. Only 1 Subnet and 1 Compartment are allowed, multiple Groups highly advised.
- C. Create at least 2 of each resource
- D. Create a separate VCN that contains only public subnets
正解：C
解説：
Refer to Best Practices When Planning and Instituting Access Controls section in the https://docs.oracle.com/en/cloud/paas/autonomous-database/atpfg/plan-and-create-access-constraints1.html#GUID-ED48C3D3-FC0F-41D5-882A-FC2D916FD6AA
https://docs.oracle.com/en/cloud/paas/autonomous-database/atpfg/plan-and-create-accessconstraints1.Html
質問 # 44
......
合格確定、ガイドで準備1z0-931-23試験：https://www.passtest.jp/Oracle/1z0-931-23-shiken.html
Oracle Cloud 1z0-931-23無料最新のリアル試験問題と回答：https://drive.google.com/open?id=1RQzVvVik8fpOgqvFtm_kBpeJ4TL3qQJq