1Z0-931-20 PDF Dumps Oct 24, 2021 Exam Questions – Valid 1Z0-931-20 Dumps
Ultimate 1Z0-931-20 Guide to Prepare Free Latest Oracle Practice Tests Dumps
Who should take the Oracle 1Z0-931-20: PeopleSoft 9.2 Database cloud Essentials exam
The 1Z0-931-20 exam test is ideal for those technical professionals who want to accelerate their knowledge of database cloud management and implementation. There is no such prerequisite for the 1Z0-931-20 exam. Anyone who has some skillset in database cloud, or has an interest in learning database cloud can prepare for the 1Z0-931-20 exam.
What is the duration, language, and format of Oracle 1Z0-931-20: Oracle Autonomous Database Cloud 2020 Specialist Exam
- Language: English (U.S)
- Passing score: 60%
- Number of Questions: 70
- Length of Examination: 120 minutes
- Format: Multiple choices
NEW QUESTION 15
Users are required to select a service when connecting to Autonomous Data Warehouse and these services match to one of three different consumer groups: High, Medium, and Low.
Which statement about these consumer groups is correct?
- A. High provides highest concurrency and lowest resources, and DoP is 1.
- B. Low provides highest concurrency, lowest resources, and DoP =1.
- C. Medium provides intermediate resource and concurrency, and queries run in a serial.
- D. High provides highest resources, lowest concurrency, and DoP is 1.
Answer: B
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/connect-predefined.html#GUID-9747539B-FD46-44F1-8FF8-F5AC650F15BE
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/manage-priorities.html#GUID-80E464A7-8ED4-45BB-A7D6-E201DD4107B7
NEW QUESTION 16
You are the admin of an Autonomous Database (ADB) instance, and a new developer has requested a new workspace in APEX.
What statement describes the step to provide the developer a new workspace in APEX?
- A. Access the APEX Administration Services and create the workspace for the developer.
- B. Create a new developer account.
- C. Create an IDCS user with the APEX role.
- D. Create a database user with the APEX role.
Answer: A
NEW QUESTION 17
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 18
Which method can be used to migrate on-premises databases to Autonomous Databases in cloud?
- A. Data Pump
- B. Original Import/Export tools
- C. Physical migration method like database cloning
- D. RMAN backup & restore
Answer: A
Explanation:
The main migration tool for migrating to ADB is Data Pump. You can export your schemas and import them into ADB using Data Pump. To sync up the additional/incremental changes on the source database during the export/import process you can use GoldenGate or GoldenGate Cloud Service to replicate those changes to ADB.
In the current release you cannot use physical migration methods like backup/restore, Data Guard, database clones, and transportable tablespaces to move your existing database to ADB.
https://www.oracle.com/database/technologies/datawarehouse-bigdata/adb-faqs.html#MIGRATION
NEW QUESTION 19
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. Multitenant
- D. Exadata
- E. Transparent Data Encryption
Answer: A,B
NEW QUESTION 20
Which two statements are true with regards to Oracle Data Sync? (Choose two.)
- A. Data Sync has default drivers available that supported loading data from DB2, Microsoft SQL Server, MySQL and Teradata.
- B. Data Sync can use a normal OCI (thick) client connection to connect to an Oracle database.
- C. Data Sync can load your data in parallel in order to speed up the loading process.
- D. Data Sync can connect to any jdbc compatible source like MongoDB, RedShift and Sybase.
Answer: C,D
Explanation:
https://www.oracle.com/technetwork/middleware/bicloud/downloads/bicsdatasync2-3-readme-3715844.pdf (4)
NEW QUESTION 21
Which three statements are true regarding how Autonomous Database provides data security? (Choose three.)
- A. Users are given OS logons or SYSDBA privileges to prevent phishing attacking.
- B. Network connections from clients to Autonomous Database are encrypted using the client credentials wallet.
- C. Data is encrypted at rest using transparent data encryption.
- D. Oracle automatically applies security updates to ensure data is not vulnerable to known attack vectors.
Answer: B,C,D
Explanation:
https://www.oracle.com/database/technologies/datawarehouse-bigdata/adb-faqs.html
NEW QUESTION 22
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 23
Which operating system can Data Visualization Desktop be run on?
- A. AIX
- B. Solaris
- C. Linux
- D. Windows
Answer: D
Explanation:
https://www.oracle.com/middleware/technologies/oracle-data-visualization-desktop.html
NEW QUESTION 24
What is the correct way to list all files in the default data pump directory?
- A. Log onto ADW server and issue is -al on the command line.
- B. You cannot list files in the default data pump directory from Autonomous Data Warehouse (ADW).
- C. By executing select * from utl_file . list ( 'DATA_PUMP_DIR ' ) ;
- D. By executing select * from DBMS_CLOUD.LIST_FILES('DATA_PUMP_DIR');
Answer: D
NEW QUESTION 25
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 paused.
- D. Active transactions are terminated and rolled back.
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 26
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. MEDIUM
- B. TP
- C. TPURGENT
- D. LOW
Answer: C
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 27
You have provisioned an Autonomous Data Warehouse (ADW) database with 16 enabled OCPUs and need to configure the consumer group for your application.
Which two are true when deciding the number of sessions for each application? (Choose two.)
- A. The MEDIUM and LOW consumer group can run up to 16 concurrent SQL statements if HIGH consumer group has 0 SQL statements
- B. The HIGH consumer group can run up to 16 concurrent SQL statements in addition to 32 concurrent SQL statements in MEDIUM and LOW consumer group each
- C. The HIGH consumer group can run up to 16 concurrent SQL statements as long as MEDIUM and LOW consumer groups have 0 SQL statements
- D. The MEDIUM consumer group can run 20 concurrent SQL statements when HIGH consumer group has 0 SQL statements
- E. The HIGH consumer group can run 3 concurrent SQL statements when MEDIUM consumer group has
0 SQL statements
Answer: D,E
NEW QUESTION 28
Which file Is NOT a component of the client credentials wallet used to connect to an ATP Database?
- A. sqlnet.ora
- B. keystore.jks
- C. protocol.ora
- D. ewallet.p12
- E. truststore.jks
- F. cwallet.sso
Answer: C
NEW QUESTION 29
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. using DBMS_CLOUD_ADMIN package
- D. through SQLPIus
Answer: B,D
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 30
When enabling auto-scaling, which three options do not change?
- A. Amount of storage
- B. Level of concurrency
- C. parallelism settings
- D. I/O resources
- E. Number of OCPUs displayed in the console.
Answer: B,C
NEW QUESTION 31
Which three statements are true about procedures in the DBMS_CLOUD package? (Choose three.)
- A. 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.
- B. 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.
- C. The DBMS_CLOUD.PUT_OBJECT procedure copies a file from Cloud Object Storage to the 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.DELETE_FILE procedure removes the credentials file from the Autonomous Data Warehouse database.
Answer: A,B,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 32
The Oracle Autonomous Database dedicated Exadata infrastructure feature is based upon which Oracle Cloud resources?
- A. Oracle Machine Learning Zeppelin Notebook, Autonomous Exadata Infrastructure, Fleet Administrator, Database Administrator,
- B. Autonomous Exadata Infrastructure, Autonomous Backup, Autonomous Container Database, Autonomous Database
- C. Fleet Administrator, Database Administrator, Database User, Autonomous Exadata Infrastructure
- D. Virtual Cloud Network, Compartments, Policies, Autonomous Exadata Infrastructure
Answer: A
NEW QUESTION 33
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 34
Autonomous Database's auto scaling feature allows your database to use up to three times the current base number of CPU cores at any time. As demand increases, auto scaling automatically increases the number of cores in use. Likewise, as demand drops, auto scaling automatically decreases the number of cores in use.
Which statement is FALSE regarding the auto scaling feature?
- A. Auto scaling is enabled by default and can be enabled or disabled at any time.
- B. For databases on dedicated Exadata infrastructure, the maximum number of cores is limited by the number of free cores that aren't being used by other auto scaling databases to meet high-load demands.
- C. The base number of OCPU cores allocated to a database is not guaranteed.
- D. For databases on dedicated Exadata infrastructure, the maximum number of cores available to a database depends on the total number of cores available in the Exadata infrastructure instance.
Answer: B
NEW QUESTION 35
Which three data dictionary views contain information about analytic view objects?
- A. ALL_ANALYTIC_VIEW_PATH
- B. ALL_ANALYTIC_VIEW_LVLGRPS
- C. ALL_ANALYTIC_VIEW_DIM_CLASS
- D. ALL_ANALYTIC_VIEW_KEYS
- E. ALL_ANALYTIC VIEW_ID _ATTRS
https://docs.oracle.com/en/database/oracle/oracle-database/19/dwhsg/overview-analytic-views.html#GUID-FC745EA1-721D-48E3-96D1-B4DE1758AFF8
Answer: B,C,D
NEW QUESTION 36
What predefined user is created when an Autonomous Database (ADB) instance is created that you connect to in order to create other users and grant roles?
- A. DWDEV
- B. SYS
- C. SCOTT
- D. ADMIN
Answer: D
Explanation:
Administrator account in Autonomous Database is ADMIN
ADMIN is the only user which is created when an Autonomous Database (ADB) instance is created and which has all other privileges to manage the Autonomous Database
NEW QUESTION 37
What are two security features enabled by default by the Autonomous Database? (Choose two.)
- A. One SYSDBA account
- B. Encrypted Database Links
- C. Read Only access to OS Audit logs
- D. SQL Net Encryption
- E. Transparent Data Encryption
Answer: D,E
Explanation:
In Autonomous Database, Oracle encrypt your data everywhere-whether in motion in SQL'Net traffic, and at rest in tablespaces and backups by default, each Autonomous Database service is automatically configured to use industry-standard TLS 1.2 to encrypt data in transit between the database service and clients or applications. Required client certificates and networking information are automatically packaged for the service consumer when the service is provisioned Oracle encrypt data at rest, by default the Autonomous Database is automatically encrypted using Oracle Transparent Data Encryption in tablespaces and backups
https://www.oracle.com/database/technologies/datawarehouse-bigdata/adb-faqs.html#SECURITY-BOOKMARK
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/database-links.html#GUID-28F06977-300F-4599-AD97-2DEF67EF5FEA
NEW QUESTION 38
Which Autonomous Database Service is NOT used to conned to an Autonomous Transaction Processing instance?
- A. MEDIUM
- B. HIGH
- C. TPPERFORMANT
- D. TPURGENT
- E. LOW
Answer: C
Explanation:
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/connect-predefined.html#GUID-9747539B-FD46-
44F1-8FF8-F5AC650F15BE
NEW QUESTION 39
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 40
......
Passing Key To Getting 1Z0-931-20 Certified Exam Engine PDF: https://www.pass4surecert.com/Oracle/1Z0-931-20-practice-exam-dumps.html