[Nov 27, 2021] 1Z0-931-20 Exam Dumps - Oracle Practice Test Questions
New Real 1Z0-931-20 Exam Dumps Questions
NEW QUESTION 25
Which two statements are true about the Oracle Cloud Infrastructure (OCI)? (Choose two.)
- 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 unlikely to impact the availability of the others within the same region.
- B. A single fault domain can be associated with multiple regions and availability domains.
- C. Regions are dependent on other regions and must be located with 5 thousand kilometers of each other.
- D. An OCI region is a localized geographic area, and an availability domain is one or more data centers located within a region.
Answer: A,D
Explanation:
A region is a localized geographic area, and an availability domain is one or more data centers located within a region.
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 unlikely to impact the availability of the others within the same region.
https://docs.cloud.oracle.com/iaas/Content/General/Concepts/regions.htm
NEW QUESTION 26
Which statement is correct with respect to required action to move Autonomous Database resources to a different compartment?
- A. Moving the compartment of the Autonomous Database will also move the Autonomous Container Database and Autonomous Exadata Infrastructure.
- B. You do not need to have sufficient access permissions on the compartment that the resource is being moved to.
- C. Moving an Autonomous Database instance does not include its automatic backups.
- D. 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.
Answer: D
NEW QUESTION 27
Which workload type does the Autonomous Database on dedicated infrastructure service currently support?
- A. Autonomous Transaction Processing only
- B. Autonomous Data Warehouse only
- C. ATP and ADW
- D. Hybrid Columnar compression
Answer: B
NEW QUESTION 28
Which data file format is NOT supported when using the package DBMS_CLOUD on Shared Exadata Infrastructure?
- A. Text
- B. Avro
- C. JSON
- D. Microsoft SQL Server (.mdf)
- E. Parquet
- F. Data Pump Export File
Answer: B
NEW QUESTION 29
Given the steps:
1. Create Oracle Machine Learning User
2. Create projects
3. Create workspaces
4. Create Notebooks
5. Run SQL Scripts
Which two steps are out of order when working with Oracle Machine learning? (Choose two.)
- A. Run SQL Scripts
- B. Create Oracle Machine Learning User
- C. Create projects
- D. Create workspaces
- E. Create Notebooks
Answer: B,D
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/omlug/get-started-oracle-machine-learning.html#GUID-13452045-6AF6-402B-83CC-C9AFBCEC30CA
NEW QUESTION 30
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'
Answer: D
NEW QUESTION 31
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. Rotate the instance wallet and share the new wallet with the remaining users.
- D. Trust the user who left to not access the database.
Answer: B
NEW QUESTION 32
Which procedure within the DBMS_CLOUD package is used to load data?
- A. LIST_FILES
- B. CREATE_EXTERNAL_TABLE
- C. LOAD_DATA
- D. COPY_DATA
- E. PUT_OBJECT
Answer: D
NEW QUESTION 33
Which three Oracle Cloud Infrastructure (OCI) resources do you need to configure before provisioning your Autonomous Database with Private Endpoint?
- A. Security List
- B. Route Table
- C. Subnet
- D. VCN
- E. Network Security Group
Answer: C,D,E
Explanation:
To provision an Autonomous Database with a private endpoint, you must have the following resources already created:
A VCN within the region that will contain your Autonomous Database with shared Exadata infrastructure.
Cannot be changed after provisioning. A private subnet within your VCN configured with default DHCP options. Cannot be changed after provisioning.
At least 1 network security group (NSG) within your VCN for the Autonomous Database. Can be changed or edited after provisioning.
https://docs.oracle.com/en-us/iaas/Content/Database/Concepts/adbsprivateaccess.htm
NEW QUESTION 34
How many pre-defined service names are configured in tnsnames.ora for a single Autonomous Transaction Processing database instance, and what are they called?
- A. Two. They are called ATP and ADW.
- B. Five. They are called tpurgent, tp, high, medium and low.
- C. Three. They are called high, medium and low.
- D. None. There are no pre-defined service names in tnsnames.ora.
Answer: B
Explanation:
The tnsnames.ora file provided with the credentials zip file contains five database service names identifiable as tpurgent, tp, high, medium, and low. The predefined service names provide different levels of performance and concurrency for Autonomous Transaction Processing.
tpurgent: The highest priority application connection service for time critical transaction processing operations. This connection service supports manual parallelism.
tp: A typical application connection service for transaction processing operations. This connection service does not run with parallelism.
high: A high priority application connection service for reporting and batch operations. All operations run in parallel and are subject to queuing.
medium: A typical application connection service for reporting and batch operations. All operations run in parallel and are subject to queuing. Using this service the degree of parallelism is limited to four (4).
low: A lowest priority application connection service for reporting or batch processing operations. This connection service does not run with parallelism.
https://www.oracle.com/database/technologies/datawarehouse-bigdata/adb-faqs.html#ATP
NEW QUESTION 35
What REST verb is used to create an Autonomous Database service using REST APIs?
- A. A "PUT" REST call
- B. A "GET" REST call
- C. An "INSERT" REST call
- D. A "POST" REST call
Answer: D
Explanation:
https://docs.oracle.com/en/cloud/paas/integration-cloud/rest-api/SendRequests.html
NEW QUESTION 36
The 3rd party application that your customer wants to migrate to Autonomous Database (ADB) has some specific demands like tablespace names, usemames and init.ora parameters. The decision was made to adhere to the suggested migration method using an instant client and the datapump version that was suggested (and came with it).
Which statement is true about the migration of the application's database success?
- A. The migration can be a success, both technically and functional due to datapump enhancements.
- B. The tablespace names will result in a blocking error during datapump import because of ADB limitations.
- C. The suggested datapump version will create an alias for non-standard tablespace names so the migration is successful.
- D. The migration can be technically a success but the 3-rd party vendor needs to support the result.
Answer: A
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/load-data-data-pump.html#GUID-9F6B551A-9DB7-44BE-A8ED-08E300C56DB1
NEW QUESTION 37
Your customer receives information in various formats like .csv files from their suppliers. The business user would like to collect all of this information and store it in a ATP environment. The Oracle adviser recommends to use Oracle Data Sync for this.
Which statement is true regarding Oracle Data Sync?
- A. Data Sync can not transform your data while loading it into the destination table.
- B. Data Sync can only load files into tables (insert-only), the customer has to write the additional code.
- C. Data Sync can load a combination of data source, such as .csv, .xlsx and Oracle relational files.
- D. Data Sync can only load data from one source into one destination table.
Answer: C
Explanation:
You can load data from files (CSV and XLSX), various relational sources (tables, views, SQL statements), OTBI, JDBC data sources, and Oracle Service Cloud
NEW QUESTION 38
Which two Oracle Cloud Infrastructure database services allow you to dynamically scale both CPU and storage? (Choose two.)
- A. Autonomous Transaction Processing (ATP)
- B. virtual machine DB system
- C. bare metal DB system
- D. Autonomous Data Warehouse (ADW)
Answer: B,C
NEW QUESTION 39
Which two statements are true about the Oracle Cloud Infrastructure (OCI)? (Choose two.)
- 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 unlikely to impact the availability of the others within the same region.
- B. A single fault domain can be associated with multiple regions and availability domains.
- C. Regions are dependent on other regions and must be located with 5 thousand kilometers of each other.
- D. An OCI region is a localized geographic area, and an availability domain is one or more data centers located within a region.
Answer: A,D
Explanation:
A region is a localized geographic area, and an availability domain is one or more data centers located within a region.
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 unlikely to impact the availability of the others within the same region.
Oracle Cloud Infrastructure is hosted in regions and availability domains. A region is a localized geographic area. And an availability domain is one or more data centers located within a region. Our region is composed of one or more available domains. Most cloud infrastructure resources are either region-specific, such as virtual cloud networks, or availability-domain-specific, such as compute instance.
Traffic between availability domains and between regions is encrypted. Availability domains are isolated from each other, fault tolerant, and very unlikely to fail simultaneously. Because availability domains do not share infrastructure such as power or cooling, or the internal availability domain network, a failure at one domain within a region is unlikely to impact the availability of the others within the same region.
https://docs.cloud.oracle.com/iaas/Content/General/Concepts/regions.htm
NEW QUESTION 40
In the Autonomous Database (ADB) Dedicated service, what does the fleet administrator use to control OCPU utilization?
- A. Oracle Machine Learning notebook
- B. Compartment quotas
- C. SQL Developer Web Console
- D. Resource Manager settings
Answer: D
NEW QUESTION 41
What is the default port number for accessing a newly created Autonomous Database?
- A. 0
- B. 1
- C. 2
- D. 3
- E. 4
Answer: C
Explanation:
https://www.oracle.com/a/ocom/docs/cloud/autonomous-database-100.pdf
NEW QUESTION 42
The default eight-day retention period for Autonomous Database performance data can be modified using which DBMS_WORKLOAD_REPOSITORY subprogram procedure?
- A. MODIFY_SNAPSHOT_SETTINGS
- B. CREATE_BASELINE_TEMPLATE
- C. UPDATE_OBJECT_INFO
- D. MODIFY_BASELINE_WINDOW_SIZE
Answer: A
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/monitor-performance-intro.html#GUID-4A1E8FCA-FAF1-43F5-93E0-559C0145D6C3 The retention time can be changed by modifying the Automatic Workload Repository retention setting with the PL/SQL procedure DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS. Be aware that increasing the retention time will result in more storage usage for performance data
NEW QUESTION 43
Which two PL/SQL functions can be used to validate an analytic view? (Choose two.)
- A. VALIDATE_HIERARCHY
- B. VALIDATE_LEVELS
- C. VALIDATE_DIMENSION
- D. VALIDATE_MEASURES
- E. VALIDATE_ANALYTIC_VIEW
Answer: A,E
Explanation:
https://docs.oracle.com/en/database/oracle/oracle-database/18/dwhsg/overview-analytic-views.html#GUID-6F948948-6AE6-4A89-8AAC-5B8952CEF41D
NEW QUESTION 44
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.
Answer: A
Explanation:
Optimizer Hints Ignored by default in ADW, where honored by default in ATP When migrating data to Autonomous Database, table statistics are gathered automatically during direct path load operations. If direct path load operations are not used, such as with SQL Developer loads, the user can gather statistics manually as needed. When migrating an existing database that uses optimizer in parallel hints, ADB will ignore those by default. Because ADB runs in a highly tuned exadata environment, most database operations should run faster or at least as well as database tune with lots of hints to perform faster. Should hints be required for some reason, they can be explicitly re-enabled.
Autonomous Data Warehouse ignores optimizer hints and PARALLEL hints in SQL statements by default
NEW QUESTION 45
Which can be Scaled independently of the number of CPUs in an Autonomous Database?
- A. Parallelism
- B. Sessions
- C. Storage
you can independently scale the number of CPUs in Autonomous Database
https://www.oracle.com/database/technologies/datawarehouse-bigdata/adb-faqs.html#GENERAL - D. Memory
- E. Concurrency
Answer: C
NEW QUESTION 46
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
Answer: C
NEW QUESTION 47
Which task is NOT automatically performed by the Oracle Autonomous Database?
- A. Backing up the database.
- B. Mask your sensitive data.
- C. Automatically optimize the workload.
- D. Patching the database.
Answer: B
Explanation:
- Oracle patch the full stack-including the firmware, the OS, clusterware, and the database.
- Oracle Autonomous Database is actually a family of cloud services, with each member of the family optimized by workload. Autonomous Data Warehouse (ADW), which has been optimized for analytic workloads and Autonomous Transaction Processing (ATP). ATP is optimized for transaction processing or mixed workload.
- it is possible to use Oracle Data Safe data masking capabilities with cloned instances of ADB. but by the customer
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/autonomous-key-features.html#GUID-7D0627D9-1B40-40B1-865A-84FF65A65846
NEW QUESTION 48
......
Oracle 1Z0-931-20: PeopleSoft 9.2 Database cloud Essentials Certified Professional salary
1Z0-931-20 exam test certified professional is in great demand nowadays. The average salary of a 1Z0-931-20 Certified Expert in:
- Europe - 60,800 EURO
- England - 61,000 POUND
- United State - 70,500 USD
- India - 15,42,500 INR
Pass Your 1Z0-931-20 Exam Easily with Accurate PDF Questions: https://www.testvalid.com/1Z0-931-20-exam-collection.html