更新された2022年10月公式問題1z0-931-22認定には1z0-931-22問題集PDF [Q27-Q46]

更新された2022年10月公式問題1z0-931-22認定には1z0-931-22問題集PDF

2022年最新のに更新された最新1z0-931-22問題集を掴み取れ！

Oracle 1z0-931-22 認定試験の出題範囲：

トピック	出題範囲
トピック 1	Autonomous Database共有インスタンスの作成 - OCPUおよびストレージのプロビジョニング、スケーリングアクセス制御リスト(ACL)およびプライベート・エンドポイントの使用
トピック 2	ADB Dedicated および ADB Cloud@Customer のリソース、ワークフロー、および機能について説明する Data Pump を使用した Autonomous Database への移行
トピック 3	Autonomous Databaseインスタンスの管理: REST API、OCI CLI、リソースの移動 Oracle Cloud Infrastructureの理解
トピック 4	Autonomous DatabaseをOracle Machine Learning、APEX、およびSQL Developer Webで使用する(データベース・アクション) Autonomous Databaseの主な機能を明確にする
トピック 5	ADB のサービスを使用する: 自動インデックス作成、データセーフ、コンパートメントクォータ Autonomous Database の管理とメンテナンス
トピック 6	自律型データベースへの移行自律型データベースの共有バックアップと復元の管理に関するオプションと考慮事項について説明します
トピック 7	ADB 接続の使用: ウォレット、サービスハンドルデータロードとデータ変換の使用
トピック 8	Autonomous Database共有インスタンスの監視 - イベントとアラーム Autonomous Database Dedicated & Autonomous Database Cloud @ Customer

質問 27
Which three are Oracle-recommended best practices for Autonomous Database alarms?

A. Create a single alarm for each metric.
B. Routinely tune your alarms.
C. Suppress alarms during investigations.
D. Select the correct alarm interval for your metric.
E. Create multiple alarm metrics.
F. Use a single interval for all alarms.

正解: B,C,D

質問 28
Which three security features are available in Oracle Autonomous Database Shared Infrastructure?

A. Customer Managed Keys
B. Database Vault
C. Data Redaction
D. Transparent Data Encryption
E. Audit Vault

正解: A,B,D

解説:
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpfg/security-features-adb1.html#GUID-89E3C22E-D4EB-472B-8287-41682C2B61B3

質問 29
When in the SQL Monitoring tab of the Performance Hub you see a clock icon in the status column. What does this mean?

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

正解: D

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

質問 30
What command should you issue to enable application continuity on Autonomous Database Shared Infrastructure?

A. exec dbms_cloucl_admin. enable_app_cont ( ' <service_name> ' ) ;
B. alter database set application_continuity=true
C. alter session set application_continuity=true
D. alter system set application_continuity=true

正解: A

解説:
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);

質問 31
What is the role of a Fleet Administrator in Autonomous Database (ADB) on Dedicated Infrastructure deployments?

A. Fleet Administrators are responsible for patching and backups of all container databases.
B. Fleet Administrators create, monitor and manage Autonomous Databases.
C. Fleet Administrator defines and gains access to the ADMIN administrative user account for the database.
D. Fleet administrators create, monitor and manage Autonomous Exadata Infrastructure and Autonomous Container Database resources.

正解: D

解説:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbah/index.html#articletitle
https://docs.oracle.com/en/cloud/paas/autonomous-database/atpfg/index.html

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

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

正解: D

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

質問 33
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 'Specify a Schedule' but do not select any month, week or day.
B. You cannot permanently disable scheduled Automatic Maintenance.
C. Change the Automatic Maintenance Schedule to 'None'd.
D. Change the Automatic Maintenance Schedule to 'No Preference'.

正解: 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

質問 34
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. Specify the archived custom image.
C. Select the snapshot of the backup.
D. Select the backup from which restore needs to be done.
E. Specify the point in time (timestamp) to restore.

正解: D,E

質問 35
Which two optimizations are different between Autonomous Data Warehouse and Autonomous Transaction Processing?

A. Backup Retention
B. Index Storage
C. Memory Usage
D. Data Organization
E. Undo Management

正解: B,C

質問 36
Where are customer-managed encryption keys stored for Autonomous Database on Dedicated Infrastructure?

A. inside the backups of the container database
B. In a separate key vault external to the Exadata Infrastructure
C. inside the Autonomous Database wallet
D. on the Exadata Infrastructure where Autonomous Database Dedicated is hosted

正解: B

質問 37
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 helps you find sensitive data in your database by inspecting the actual data in your database and its data dictionary.
B. Oracle Data Safe helps you assess the security of your cloud database configurations by analyzing database configurations.
C. Oracle Data Safe evaluates user types, how users are authenticated, and the password policies assigned to each user.
D. Oracle Data Safe only supports Autonomous Databases.

正解: D

解説:
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

質問 38
Which workload type does the Autonomous Database on dedicated infrastructure service currently support?

A. ATP and ADW
B. Autonomous Transaction Processing only
C. Hybrid Columnar compression
D. Autonomous Data Warehouse only

正解: A

解説:

質問 39
While creating a business model what advanced options you can enable or disable? (Choose three)

A. Analytic View Base Table Query Transformation
B. Business Object Security Feature
C. Autonomous Aggregate Cache
D. Analytic View Transparency View
E. Display private tables

正解: A,C,D

解説:

質問 40
Which two statements are FALSE about creating a metadata-only clone with a private endpoint network access option?

A. All underlying data for OML notebooks is cloned.
B. Clone can be in a different region.
C. All resource management rules are cloned.
D. All OML notebooks are cloned.
E. Current settings for ACLs are cloned.

正解: A,B

解説:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/autonomous-clone-notes.html#GUID-F943E7FF-8DEB-47F4-84C0-FFA5BAF9D5A9

質問 41
Which four file formats are supported when loading data from Cloud Storage?

A. Dcsv
B. DDL
C. Parquet
D. DOC
E. AVRO
F. JSON

正解: A,C,E,F

質問 42
Which statement is correct with respect to required action to move Autonomous Database resources to a different compartment?

A. 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.
B. Moving an Autonomous Database instance does not include its automatic backups.
C. Moving the compartment of the Autonomous Database will also move the Autonomous Container Database and Autonomous Exadata Infrastructure.
D. You do not need to have sufficient access permissions on the compartment that the resource is being moved to.

正解: A

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

質問 43
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. Delete the user.
B. Shutdown and restart the instance.
C. Trust the user who left to not access the database.
D. Rotate the instance wallet and share the new wallet with the remaining users.

正解: D

解説:

質問 44
Which two are correct actions to take in order to Download the Autonomous Database Credentials?

A. Click on the Autonomous Data Warehouse in the menu, click a database name, then Choose DB Connection button, then Download the Wallet.
B. Click on the Autonomous Data Warehouse section, pick a database, then Choose Actions, then Download the Wallet.
C. Click on the Object Storage and find your Autonomous Bucket and Download the Wallet Credentials.
D. Click the Compute section of the menu, then choose Instance Configurations, then Download Wallet.
E. Find the Service Console for your Autonomous Database, then pick Administration, then Download the Client Credentials (Wallet).

正解: A,E

解説:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/connect-download-wallet.html#GUID-B06202D2-0597-41AA-9481-3B174F75D4B1

質問 45
Which statement is correct about the Service console in an 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

解説: