Oracle Cloud 1z0-931-23最新問題集で2024年08月01日
2024年最新の問題をマスター！Oracle Cloud合格目指そう！1z0-931-23リアル試験問題集！
Oracle 1z0-931-23 認定試験の出題範囲：
| トピック | 出題範囲 |
|---|---|
| トピック 1 |
|
| トピック 2 |
|
| トピック 3 |
|
| トピック 4 |
|
| トピック 5 |
|
| トピック 6 |
|
| トピック 7 |
|
| トピック 8 |
|
| トピック 9 |
|
質問 # 44
In which four ways can Oracle Database optimally access data in Object Storage?
- A. scan avoidance using partitioned external tables
- B. scan avoidance using block skipping when reading parquet and ore files
- C. optimized data archive using hybrid partitioned tables
- D. optimized data archive using partitioned external tables
- E. scan avoidance using columnar pruning for .csv files
- F. scan avoidance using columnar pruning for columnar stores like parquet and orc
正解：A、C、D、F
質問 # 45
Which three scaling options are available in Oracle Autonomous Database on Shared Infrastructure?
- A. Manual online scaling of Storage
- B. Automatic online scaling of OCPU
- C. Manual offline scaling of Storage and OCPU
- D. Manual online scaling of OCPU
- E. Automatic online scaling of Storage
正解：B、C、E
質問 # 46
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. Trust the user who left to not access the database.
- C. Shutdown and restart the instance.
- D. Rotate the instance wallet and share the new wallet with the remaining users.
正解：D
解説：
質問 # 47
What is the maximum number of days that an Autonomous Database Refreshable Clone can be trailing its source instance?
- A. 7 days
- B. 30 days
- C. 15 days
- D. 1 day
正解：A
質問 # 48
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 non-peak hours. The architecture team is debating whether such reports should be run on the 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.
Which Oracle Cloud Infrastructure database service is appropriate for this scenario?
- A. Since the application needs to be highly available, it should to be deployed on a Kubernetes Cluster.
- B. It is best to build a separate data warehouse, and move the OLTP data on a nightly basis.
- C. ATP. Using 'tpurgent' and 'high' TNS services to separate connection types.
- D. ADW since operational reporting is a higher priority in this scenario.
正解：C
解説：
Autonomous Transaction Processing provides all of the performance of the market leading Oracle Database in an environment that is tuned and optimized to meet the demands of a variety of applications, including: mission-critical transaction processing, mixed transactions and analytics, loT, and JSON document store.
As a service Autonomous Transaction Processing does not require database administration. With Autonomous Transaction Processing you do not need to configure or manage any hardware, or install any software. Autonomous Transaction Processing handles creating the database, backing up the database, patching and upgrading the database, and growing or shrinking the database.
質問 # 49
Which two statements are correct about Autonomous Data Warehouse on Shared Exadata Infrastructure?
- A. Compression is enabled by default. Autonomous Data Warehouse uses Hybrid Columnar Compression for all tables by default.
- B. Oracle Database Result Cache is enabled by default for all SQL statements.
- C. You have direct access to the database node.
- D. Parallelism is not enabled by default.
正解：A、B
解説：
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/appendix-autonomous-database-data-warehouse-workload.html#GUID-604A08F8-8021-43CE-AA95-823045E14BD8
質問 # 50
In Graph Studio which you can use to create a graph?
- A. NoSQL configuration
- B. Graph created by a special tool downloaded from Oracle.com
- C. Tables in an Autonomous Database instance
- D. Graph analytics algorithms
- E. A graph license key
正解：C
解説：
質問 # 51
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 system set application_continuity=true
- C. alter session set application_continuity=true
- D. alter database 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);
質問 # 52
Which Database Actions tool is used to get information about the entities in your Oracle Autonomous Database and to also see how changing an object affects other objects?
- A. Catalog
- B. JSON
- C. Data Insights
- D. Data Load
正解：A
質問 # 53
When running lots of high concurrent queries in Autonomous Database, you should use which predefined service connection? (Choose the best answer.)
- A. DBNAME_CONCURRENT
- B. DBNAME_MEDIUM
- C. DBNAME_LOW
- D. DBNAME_HIGH
正解：C
解説：
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/manage-priorities.html#GUID-80E464A7-8ED4-45BB-A7D6-E201DD4107B7
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/manage-priorities.html#GUID-80E464A7-8ED4-45BB-A7D6-E201DD4107B7
質問 # 54
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. 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
- C. Click Scale Up/Down and select the Auto Scaling checkbox
- D. Shut down the instance, click Scale Up/Down and select the Auto Scaling checkbox, then restart the instance
正解：A、C
質問 # 55
Which cloud service is NOT supported to import data pump files from using Dedicated Exadata Infrastructure?
- A. Google Cloud Storage
- B. Oracle Cloud Infrastructure Object Storage Classic
- C. Amazon S3
- D. Oracle Cloud Infrastructure Object Storage
正解：A
解説：
質問 # 56
While creating a business model what advanced options you can enable or disable? (Choose three)
- A. Business Object Security Feature
- B. Autonomous Aggregate Cache
- C. Display private tables
- D. Analytic View Base Table Query Transformation
- E. Analytic View Transparency View
正解：B、D、E
解説：
質問 # 57
Which three are Oracle-recommended best practices for Autonomous Database alarms?
- A. Routinely tune your alarms.
- B. Suppress alarms during investigations.
- C. Create a single alarm for each metric.
- D. Use a single interval for all alarms.
- E. Select the correct alarm interval for your metric.
- F. Create multiple alarm metrics.
正解：A、B、E
質問 # 58
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 completed its execution.
- B. The SQL statement did not complete either due to an error.
- 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
質問 # 59
Which statement is NOT correct when setting up compartment quotas?
- A. Compartment quotas are set by Oracle.
- B. Compartment quotas use policies that allow allocation of resources with a high level of flexibility.
- C. Along with compartment budgets, compartment quotas create a powerful toolset to manage your spending.
- D. There are three types of quota policy statements which are set, unset and zero.
正解：A
解説：
https://docs.oracle.com/en-us/iaas/Content/General/Concepts/resourcequotas.htm
質問 # 60
Which three operations are available for a quarterly maintenance update on Autonomous Container Database?
- A. Apply a partial patch
- B. Patch immediately
- C. Reschedule patching
- D. Skip patching
- E. Reschedule and patch immediately
正解：B、C、D
質問 # 61
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. Trust the user who left to not access the database.
- C. Shutdown and restart the instance.
- D. Rotate the instance wallet and share the new wallet with the remaining users.
正解：D
質問 # 62
Which native data type is used to store spatial information?
- A. SDO_LOCATION
- B. GEO_JSON
- C. SDO_GEOMETRY
- D. SDO_RELATE
正解：C
質問 # 63
Which two actions are available to perform when an Autonomous Database is stopped?
- A. Start
- B. Update Network Access
- C. Change administrator password
- D. Update License Type
正解：A、D
質問 # 64
Which two methods can you use to define Oracle Machine Learning users?
- A. SQL Developer
- B. the DBMS_CLOUD_ADMIN package
- C. Service Console
- D. Oracle Cloud Infrastructure Console
正解：D
質問 # 65
Your customer wants to permanently disable scheduled maintenance on the Autonomous Database on 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. Change the Automatic Maintenance Schedule to "No Preference"
- C. Change the Automatic Maintenance Schedule to "None"
- D. You cannot permanently disable scheduled automatic maintenance
正解：D
質問 # 66
Which set of Oracle Cloud Infrastructure metrics is available only for Autonomous Database on Dedicated Infrastructure?
- A. Transaction Count, Sessions, Running Statements
- B. CPU Utilization, Storage Utilization
- C. IOPS, Storage Space Used By Tablespace, Apply and Transport Lag
- D. Query Latency, User Calls, Execute Count
正解：C
質問 # 67
......
完全版は2024年最新の1z0-931-23試験問題集テストガイドはトレーニング専門Fast2test：https://jp.fast2test.com/1z0-931-23-premium-file.html