Updated Mar 25, 2022 1Z0-931-20 Exam Dumps - PDF Questions and Testing Engine
New (2022) Oracle 1Z0-931-20 Exam Dumps
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
- India - 15,42,500 INR
- England - 61,000 POUND
- United State - 70,500 USD
NEW QUESTION 26
Which three statements are true about procedures in the DBMS_CLOUD package? (Choose three.)
- A. The DBMS_CLOUD.DELETE_FILE procedure removes the credentials file from the Autonomous Data Warehouse database.
- B. The DBMS_CLOUD.CREATE_EXTERNAL_TABLE procedure creates an external table on files in the cloud. You can run queries on external data from the Autonomous Data Warehouse.
- C. The DBMS_CLOUD.VALIDATE_EXTERNAL_TABLE procedure validates the source files for an external table, generates log information, and stores the rows that do not match the format options specified for the external table in a badfile table on Autonomous Data Warehouse.
- D. The DBMS_CLOUD.CREATE_CREDENTIAL procedure stores Cloud Object Storage credentials in the Autonomous Data Warehouse database.
- E. The DBMS_CLOUD.PUT_OBJECT procedure copies a file from Cloud Object Storage to the Autonomous Data Warehouse.
Answer: B,C,D
Explanation:
DELETE_FILE Procedure
This procedure removes the specified file from the specified directory on Autonomous Data Warehouse.
CREATE_CREDENTIAL Procedure
This procedure stores Cloud Object Storage credentials in the Autonomous Data Warehouse database.
Use stored credentials for data loading or for querying external data residing in the Cloud.
PUTJDBJECT Procedure
This procedure copies a file from Autonomous Data Warehouse to the Cloud Object Storage. The maximum file size allowed in this procedure is 5 gigabytes (GB).
VALIDATE EXTERNAL TABLE Procedure
This procedure validates the source files for an external table, generates log information, and stores the rows that do not match the format options specified for the external table in a badfile table on Autonomous Data Warehouse.
CREATE_EXTERNAL_TABLE Procedure
This procedure creates an external table on files in the Cloud. This allows you to run queries on external data from Autonomous Data Warehouse.
To use Data Pump from ADB, a credential identifying the Object Storage bucket to use must be defined with a DBMS_CLOUD.CREATE_CREDENTIAL function. This will allow ADB to access objects that are stored in the object store , including dump files. To export an existing database to prepare for import into ADB, use the XTP command and add the ex elude option for database functionality that is not recommended or supported in ADB. This will prevent errors during the imp oil process.
This process is not automatic. And if the logs are not moved, you will receive a warning when running the MDB that the logs are not there. In this example, we're moving the log import.log to object store with a DBMS_CLOUD.PUT_OBJECT command.
VALIDATE_EXTERNAL_TABLE Procedure
This procedure validates the source files for an external table, generates log information, and stores the rows that do not match the format options specified for the external table in a badfile table on Autonomous Database. The overloaded form enables you to use the operation_id parameter.
PUT_OBJECT Procedure
This procedure copies a file from Autonomous Database to the Cloud Object Storage. The maximum file size allowed in this procedure is 5 gigabytes (GB) DELETE FILE Procedure This procedure removes the specified file from the specified directory on Autonomous Database.
CREATE_EXTERNAL_TABLE Procedure
This procedure creates an external table on files in the Cloud. This allows you to run queries on external data from Autonomous Database.
NEW QUESTION 27
Which three statements are correct when the Autonomous Database is stopped? (Choose three.)
- A. In-flight transactions and queries are stopped.
- B. CPU billing is halted based on full-hour cycles of usage.
- C. User with DWROLE can still access the database.
- D. Tools are no longer able to connect to a stopped instance.
Answer: A,B,D
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/autonomous-stop.html#GUID-9AF677F3-027A-43FD-B018-9F4A42D5CDE9
NEW QUESTION 28
A customer wants to migrate to Autonomous Database (ADB) but only allows for a very small window of downtime. Golden Gate was advised to be used during the migration. For maximum reassurance of their end-users, the customer also would like to use Golden Gate as a fall-back scenario for the first 6 months after the migration. If customers complain, the on-premise data can be synchronised with the ADB Instance for a switch back.
Which statement about the migration using Golden Gate is correct?
- A. Only the migration to ADB is possible from an on-premise installation of Golden Gate.
- B. Migration to ADB is not possible using Golden Gate because the apply-process cannot be installed on ADB.
- C. The described scenario is correct, can be used for migration and fallback scenarios.
- D. Golden Gate on premise is not certified with ADB because Golden Gate Cloud Service exists for this.
- E. The fallback scenario is not possible using Golden Gate because the capture-process cannot be installed on ADB.
Answer: E
Explanation:
You can replicate data to Oracle Autonomous Data Warehouse Cloud and Autonomous Transaction Processing using Oracle GoldenGate On Premises and Oracle GoldenGate Cloud Service.
- You can configure the Autonomous Database instance as a target database for Oracle GoldenGate On Premises.
- You can't set up Oracle Autonomous Database Cloud database as a source database for Oracle GoldenGate On Premises.
https://www.oracle.com/database/technologies/datawarehouse-bigdata/adb-faqs.html#MIGRATION-BOOKMARK
NEW QUESTION 29
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:
https://docs.oracle.com/en/cloud/paas/bi-cloud/bilpd/data-sync.html
NEW QUESTION 30
Once you have a connection to the Autonomous Data Warehouse, how do you import tables into the Oracle Analytics Cloud (OAC)?
- A. Replicate the table using Golden Gate
- B. Load data using Data Pump
- C. Create a Data Set
- D. Import Table
Answer: C
Explanation:
To import objects from the Autonomous Data Warehouse into Oracle Analytics Cloud, click on Create Data Set. Then select the connection you created earlier. If you skipped the step on creating a connection, click on the Create Connection button and follow the screens to create it. Then continue.
https://blogs.perficient.com/2019/07/22/loading-data-into-oracle-autonomous-data-warehouse-using-oac/
NEW QUESTION 31
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. All OML notebooks are cloned.
- C. Clone can be in a different region.
- D. All resource management rules are cloned.
- E. Current settings for ACLs are cloned.
Answer: B,D
NEW QUESTION 32
What are three methods to load data into the Autonomous Database?
- A. Oracle GoldenGate
- B. Transportable Tablespace
- C. Oracle Data Pump
- D. RMAN Restore
- E. SQL*Loader
Answer: A,C,E
Explanation:
https://www.oracle.com/database/technologies/datawarehouse-bigdata/adb-faqs.html#ATPD
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/load-data-intro.html#GUID-5D2F70D8-4FA1-482C-BFB0-43441FB897F3
NEW QUESTION 33
When working with an Autonomous Exadata Infrastructure supporting Autonomous Databases, where do you go to view the maintenance history of the Exadata?
- A. Under Database then Autonomous Transaction Processing then Autonomous Exadata
- B. Under Solutions and Platform then Platform Services then Autonomous Exadata
- C. Under Core Infrastructure then Compute then Autonomous Exadata
- D. Under Core Infrastructure then Autonomous Exadata
Answer: C
NEW QUESTION 34
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.
Answer: D
NEW QUESTION 35
Which can be Scaled independently of the number of CPUs in an Autonomous Database?
- A. Storage
you can independently scale the number of CPUs in Autonomous Database
https://www.oracle.com/database/technologies/datawarehouse-bigdata/adb-faqs.html#GENERAL - B. Parallelism
- C. Memory
- D. Concurrency
- E. Sessions
Answer: A
NEW QUESTION 36
Which two license types does the customer need to benefit from BYOL when leveraging on-premise Enterprise Database licenses in Oracle Autonomous Database?
- A. Active Data Guard
- B. RAC, but only when scaling beyond 16 OCPUs
- C. Exadata
- D. Transparent Data Encryption
- E. Multitenant
Answer: A,B
NEW QUESTION 37
You have a requirement to create an Autonomous Transaction Processing database that can support at least 200 concurrent statements per OCPU as well as parallelism.
Which service will you need to connect to?
- A. TPURGENT
- B. MEDIUM
- C. TP
- D. LOW
Answer: A
Explanation:
tpurgent: The highest priority application connection service for time critical transaction processing operations. This connection service supports manual parallelism.
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/connect-predefined.html#GUID-9747539B-FD46-
44F1-8FF8-F5AC650F15BE
NEW QUESTION 38
Which two methods can you use to create users and grant roles in Autonomous Database services?
(Choose two.)
- A. through the Oracle Cloud Infrastructure service console
- B. through SQL/Developer s
- C. through SQLPIus
- D. using DBMS_CLOUD_ADMIN package
Answer: B,C
Explanation:
https://oracle-base.com/articles/vm/oracle-cloud-autonomous-data-warehouse-adw-create-service
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/connect-sqlplus.html#GUID-A3005A6E-9ECF-40CB-8EFC-D1CFF664EC5A
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/connect-sql-dev.html#GUID-FB611317-2999-4C8C-8A3B-B3B3D3C5B417
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/dbms-cloud-admin.html#GUID-D76B229E-781E-45C0-9F14-CAF30F9E6E3B
NEW QUESTION 39
Which statement is correct about the version of Java that is recommended for use with tools that use Java Database Connectivity (JDBC) connections?
- A. Java Development Kit Version 7
- B. JDBC drivers do NOT support multiple Java Developer Kit versions.
- C. Java Development Kit Version 8 or higher
- D. It doesn't matter, but you must Install the JCE Unlimited Strength Policy Files.
- E. JDBC .Jar files are specific to each platform.
Answer: E
NEW QUESTION 40
Which two system privileges does a user need to create analytic views? (Choose two.)
- A. CREATE ATTRIBUTE DIMENSION
- B. CREATE ANALYTIC HIERARCHY
- C. CREATE ANALYTIC VIEW
- D. CREATE ANALYTIC MEASURE
- E. CREATE ANALYTIC LEVEL
Answer: A,C
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/manage-users-privileges.html
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/dwhsg/overview-analytic-views.html#GUID-6F948948-6AE6-4A89-8AAC-5B8952CEF41D
NEW QUESTION 41
When scaling OCPUs in Autonomous Database, which statement is true in regards to active transactions?
- A. Scaling cannot happen while there are active transactions in the database.
- B. Active transactions continue running unaffected.
- C. Active transactions are terminated and rolled back.
- D. Active transactions are paused.
Answer: B
Explanation:
Oracle allows you to scale compute and storage independently, no need to do it together, these scaling activities fully online (no downtime required)
NEW QUESTION 42
Which three Oracle Cloud Infrastructure (OCI) resources do you need to configure before provisioning your Autonomous Database with Private Endpoint?
- A. Network Security Group
- B. Route Table
- C. Subnet
- D. VCN
- E. Security List
Answer: A,C,D
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 43
Which is correct about security features that are available in Oracle Autonomous Database?
- A. Neither Data Redaction nor TDE are supported.
- B. Data Redaction and TDE are both supported.
- C. TDE but not Data Redaction.
- D. Data Redaction but not TDE.
Answer: B
Explanation:
https://www.oracle.com/database/technologies/datawarehouse-bigdata/adb-faqs.html
NEW QUESTION 44
......
Updated Verified Pass 1Z0-931-20 Exam - Real Questions and Answers: https://braindumps2go.dumpsmaterials.com/1Z0-931-20-real-torrent.html
