[2024年01月06日]1z0-931-23試験ブレーン問題集で学習注釈と理論 [Q90-Q109]

[2024年01月06日]1z0-931-23試験ブレーン問題集で学習注釈と理論

合格させるOracle 1z0-931-23テスト練習テスト問題試験問題集

質問 # 90
Which two methods can you use to define Oracle Machine Learning users?

A. the DBMS_CLOUD_ADMIN package
B. SQL Developer
C. Oracle Cloud Infrastructure Console
D. Service Console

正解：C

質問 # 91
Which two statements are true when running DBMS_CLOUD.COPY_DATA? (Choose two.)

A. The source files can reside in Oracle Object Storage, Amazon S3 Object storage, or Azure Blob storage.
B. The source file can be in either Oracle Standard Storage or Oracle Archive Storage bucket in the Object Store.
C. The target table will be created in Autonomous Database if it does not already exist.
D. The source file will be automatically removed after the DBMS_CLOUD.COPY_DATA procedure finishes successfully.
E. A valid credential must be created prior to running the DBMS_CLOUD.COPY_DATA procedure.

正解：A、E

解説：
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/file-uri-formats.html#GUID-5D3E1614-ADF2-4DB5-B2B2-D5613F10E4FA
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/dbms-cloud.html#GUID-9428EA51-5DDD-43C2-B1F5-CD348C156122

質問 # 92
Which two cloud services are supported to import data pump files from using Dedicated Exadata Infrastructure? (Choose two.)

A. Azure Blob Storage
B. Oracle Cloud Infrastructure Object Storage Classic
C. Google Cloud 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

質問 # 93
Which statement is true about connecting a marketplace Oracle Cloud Infrastructure (OCI) image to an Autonomous Database on Shared Infrastructure?

A. A Private Endpoint is required to connect to the Autonomous Database on shared Exadata infrastructure.
B. The marketplace OCI image does not support connecting to an Autonomous Database on Shared Infrastructure.
C. The Autonomous Database must belong to a Network Security Group (NSG).
D. The marketplace OCI image can be used with an Always Free Autonomous Database account.
E. The Autonomous Database can only be in the same virtual cloud network (VCN) and subnet as the marketplace OCI image.

正解：E

質問 # 94
Which vaults are used for storing customer-managed encryption keys for Autonomous Database on Dedicated Infrastructure?

A. Oracle Database Vault, Oracle Key Vault
B. Oracle Audit Vault, Oracle Key Vault
C. Oracle Key Vault, Oracle Cloud Infrastructure Vault
D. Oracle Cloud Infrastructure Vault, Oracle Database Vault

正解：D

質問 # 95
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 an IDCS user. Create a database user with connect, resource, and object privileges.
B. Create a database user with connect, resource, and object privileges.
C. Create a database user with the default privileges.
D. 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.

正解：D

解説：
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.

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

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

正解：A

解説：

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

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

正解：C

質問 # 98
Which statement is FALSE about Autonomous Database Maintenance on dedicated Exadata infrastructure?

A. Autonomous Exadata Infrastructure maintenance takes place at least once each quarter and is mandatory.
B. Autonomous Exadata Infrastructure maintenance runs are for infrastructure patching (including patching of the Exadata grid infrastructure code and operating systems updates), and include database patching.
C. If a scheduled container database maintenance run cannot take place, Oracle will automatically reschedule the container database maintenance for the following quarter.
D. 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.

正解：B

解説：
Exadata infrastructure maintenance takes place at least once each quarter and is mandatory.
If a scheduled container database maintenance run cannot take place (because of changes made to infrastructure maintenance scheduling or other reasons) , Oracle will automatically reschedule the container database maintenance for the following quarter.
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.
Exadata infrastructure maintenance patches the Exadata infrastructure (including patching of the Exadata grid infrastructure code and operating systems updates), and DO NOT include database patching.

質問 # 99
For Fleet admins to access dedicated Exadata infrastructure, which policy should be assigned?

A. Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType = 'DW'
B. Allow group ADB-Admins to manage autonomous-database-family in tenancy.
C. Allow group ADB-Admins to manage autonomous-database in tenancy.
D. Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType = 'OLTP'

正解：B

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

質問 # 100
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. 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. Regions are dependent on other regions and must be located within five thousand kilometers of each other

正解：A、B

質問 # 101
On which two infrastructure classes can the Autonomous Database service be deployed?

A. Shared Exadata Infrastructure
B. Oracle Cloud Infrastructure Virtual Machines
C. Dedicated Exadata Infrastructure
D. Exadata Cloud Service

正解：A、C

質問 # 102
To who, and in which order, are dedicated Exadata Infrastructure resources provisioned?

A. Database Administrator, Autonomous Container DB -> Autonomous DB -> Fleet Administrator -> Autonomous Exadata Infrastructure
B. Database Administrator, Autonomous Exadata Infrastructure -> Fleet Administrator -> Autonomous Container DB -> Autonomous DB
C. Fleet Administrator, Autonomous Exadata Infrastructure -> Autonomous Container DB -> Database Administrator -> Autonomous DB
D. Fleet Administrator, Autonomous Exadata Infrastructure -> Database Administrator -> Autonomous Container DB -> Autonomous DB

正解：D

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

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

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

正解：A

質問 # 104
Which two are ways Oracle Database can optimally access data in Object Storage?

A. Optimized data archive using partitioned external tables
B. Optimized data archive using hybrid partitioned tables
C. Scan avoidance using partitioned external tables
D. Scan avoidance using columnar pruning for .csv files

正解：B、C

質問 # 105
Where can a user's public ssh key be added on the Oracle Cloud Infrastructure Console in order to execute API calls?

A. On the Autonomous Database Console.
B. Navigate to Identity, select Users panel on the console and select "Add Public Key".
C. SSH keys cannot be added from console. They have to be added using REST APIs only.
D. SSH keys are not required in Oracle Cloud Infrastructure.

正解：B

解説：
- In the Console, click Identity, and then click Users. Locate the user in the list, and then click the user's name to view the details.
-Click Add Public Key.
- Paste the key's value into the window and click Add.

質問 # 106
Which two of the following statements are correct?

A. The Data Transforms Card provides access to Oracle Data Integrator (ODI) Web Edition.
B. ODI Web Edition can be installed from Oracle Cloud Infrastructure (OCI) Marketplace.
C. ODI Web Edition is available only on Oracle Linux.
D. All of the capabilities of ODI Classic are available with ODI Web Edition,

正解：B、C

質問 # 107
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 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

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

A. Execute alter tablespace DATA set quota = 10G;
B. Execute alter database for user MTHEO tablespace DATA quota = 10G;
C. Execute DBMS_CLOUD_ADMIN. GRANT_TABLESPACE_QOOTA (username => 'MTHEO' , tablespace__quota => "UNLIMITED*);
D. Execute alter user MTHEO quota unlimited on tablespace DATA;

正解：C

解説：
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/dbms-cloud-admin.html#GUID-4DC6A536-DC78-43FE-B173-CED1F9FB45A0

質問 # 109
......

厳密検証された1z0-931-23問題集と解答で1z0-931-23問題集と正解付き：https://jp.fast2test.com/1z0-931-23-premium-file.html