Download 1z0-931 Training Materials 2021

NEW QUESTION 1
Your customer has upgraded their on premise 11.2 database to 12.2. During this migration the database was migrated to a pluggable database and is now in production.
How should the customer unplug their database to migrate to Autonomous Database (ADB)?

• A. Unplug into a pdb archive which can be uploaded to object storage.B Create a database link from source database to the ADB environment and clone the PDB.
• B. Pluggable databases cannot be migrated to ADB using plug, unplug or clone.
• C. Unplug to an xml file so database files and xml file can be uploaded to object storage.

Answer: B

NEW QUESTION 2
What two methods can you use to define Machine Learning Users?

• A. Use DBMS_CLOUD_ADMIN package
• B. SQL/Developer
• C. Oracle Cloud Infrastructure Console
• D. Client tools

Answer: AC

NEW QUESTION 3
As a database architect you are tasked with configuring a high concurrency, production OLTP application to connect to an Autonomous Transaction Processing database with a requirement to have some reporting queries run in parallel mode.
Which connection service is appropriate for such a workload?

• A. MEDIUM
• B. TP
• C. HIGH
• D. TPURGENT

Answer: C

NEW QUESTION 4
The 3rd party application that your customer wants to migrate to Autonomous Database (ADB) has some specific demands like tablespace names, usernames 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 tablespace names will result in a blocking error during datapump import because of ADB limitations.
• B. The migration can be technically a success but the 3-rd party vendor needs to support the result.
• C. The migration can be a success, both technically and functional due to datapump enhancements.
• D. The suggested datapump version will create an alias for non-standard tablespace names so the migration is successful.

Answer: D

NEW QUESTION 5
If you need to connect to Autonomous Data Warehouse (ADW) using Java Database Connectivity (JDBC) via an HTTP proxy, where do you set the proxy details?

• A. cwallet.sso
• B. keystore.jks
• C. ojdbc.properties
• D. sqlnet.ora
• E. tnsnames.ora

Answer: E

NEW QUESTION 6
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. AT
• B. Using 'tpurgenf and 'high' TNS services to separate connection types
• C. ADW since operational reporting is a higher priority in this scenario.
• D. Since the application needs to be highly available, It should to be deployed on a Kubernetes Cluster.
• E. It is best to build a separate data warehouse, and move the OLTP data on a nightly basis.

Answer: D

NEW QUESTION 7
Migrating an on-premise database to Autonomous Database (ADB) for large amounts of data involves multiple steps like creating a credential object, creating (access to) a storage object/location, running datapump export and running a datapump import.
Which three statements are true for SQL Developer (18.3 and up) in combination with ADB Data Loading?

• A. SQL Developer can only export/move/import files using datapump from databases running on Linux systems.
• B. SQL Developer can import .csv files into ADB which are located on the system where SQL Developer is running.
• C. SQL Developer can be used to export/move/import of a database to ADB in l set of wizard steps.
• D. SQL Developer can be started from the ADB Cloud console but only for data loading scenarios.
• E. SQL Developer can import files (.dmp and .csv for example) into ADB which are located on Amazon S3 Object storage.

Answer: ABD

NEW QUESTION 8
Which Autonomous Database Service is NOT used to connect to an Autonomous Transaction Processing instance?

• A. TPPERFORMANT
• B. TPURGENT
• C. LOW
• D. MEDIUM
• E. HIGH

Answer: A

Explanation:
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/connect-predefined.html#GUID-9747539B-FD46-44F1-8

NEW QUESTION 9
Which Autonomous Database Cloud service ignores hints in SQL Statements by default?

• A. Autonomous Data Warehouse
• B. Neither service ignores hints by default
• C. Autonomous Transaction Processing
• D. Both services ignore hints by default

Answer: C

NEW QUESTION 10
What are two security features enabled by default by the Autonomous Database?

• A. Encrypted Database Links
• B. SQL Net Encryption
• C. One SYSDBA account
• D. Read Only access to OS Audit logs
• E. Transparent Data Encryption

Answer: AE

NEW QUESTION 11
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. Fiv
• B. They are called tpurgent, tp, high, medium and low.
• C. Thre
• D. They are called high, medium and low.
• E. Non
• F. There are no pre-defined service names in tnsnames.ora.
• G. Tw
• H. They are called ATP and ADW.

Answer: A

NEW QUESTION 12
Which Autonomous Database Cloud service ignores hints in SQL Statements by default?

• A. Autonomous Data Warehouse
• B. Neither service ignores hints by default
• C. Autonomous Transaction Processing
• D. Both services ignore hints by default

Answer: C

NEW QUESTION 13
What are two advantages of using Data Pump to migrate your Oracle Databases to Autonomous Database?

• A. Data Pump creates the tablespaces used by your Autonomous Database.
• B. Data Pump can exclude migration of objects like indexes and materialized views that are not needed by Autonomous Database.
• C. Data Pump is faster to migrate database than using RMAN.
• D. Data Pump is platform independent - it can migrate Oracle Databases running on any platform.

Answer: AD

NEW QUESTION 14
Which two methods can you use to create users and grant roles in Autonomous Database services?

• A. through SQLPIus
• B. through the Oracle Cloud Infrastructure service console
• C. using DBMS_CLOUD_ADMIN package
• D. through SQL/Developer

Answer: B

NEW QUESTION 15
Which statement is true in regards to database links?

• A. Connect from Autonomous Database to remote database using a database link.
• B. Connect to Autonomous Database from remote database using a database link.
• C. You can call PL/SQL procedures and functions using a database link.
• D. Create a database link from one Autonomous Database to another Autonomous Database instance.

Answer: A

NEW QUESTION 16
Which two options are available to restore an Autonomous Data Warehouse?

• A. Select the snapshot of the backup.
• B. Specify the point in time (timestamp) to restore
• C. Select the archived redo logs.
• D. Backup and recovery must be done using Recovery Manager(RMAN).
• E. Select the backup from which restore needs to be done.

Answer: AD

NEW QUESTION 17
Which is the correct subset of services offered via OCI-CLI (command line interface) for Autonomous Database (ABD) via calls made to the OCI API's?

• A. Create, Query, Update, List, Start
• B. Create, Query, List, Stop, Restore
• C. Create, Get, List, Stop, Restore
• D. Start, Delete, Update, Query, Stop

Answer: B

NEW QUESTION 18
Which statement about the Export Wizard used to export database objects and data is NOT correct?

• A. If "Dependents" is checked as a DDL Option, for non-privileged users, only dependent objects in their schema are exported.
• B. Export DDL includes features such as "Show schema," "Storage," and "Terminator."
• C. If "Grants" Is checked as a DDL Option, GRANT statements are Included for any grant objects on the exported objects, including those owned by the SYS schema.
• D. If "Clipboard" is selected as the "Output," the output will be placed on the system clipboard, so that it can be pasted into a file, a command line, or other location appropriate for the format.

Answer: C

NEW QUESTION 19
What are the two methods that could be used during the migration of your existing Oracle database to Autonomous Database?

• A. CSV files copied to Autonomous Database block storage
• B. Data Pump
• C. Golden Gate
• D. Recovery Manager (RMAN)

Answer: AC

NEW QUESTION 20
When you choose to scale your Autonomous Database, which statement is true in regards to OCPUs and storage?

• A. OCPUs and storage can be scaled independently.
• B. OCPUs and storage must remain in sync.
• C. Increasing OCPUs will automatically increase storage.
• D. Storage in TB cannot be larger than the number of OCPUs.

Answer: C

NEW QUESTION 21
Which two statements are true about the The Oracle Cloud Infrastructure (OCI)?

• 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. Regions are dependent on other regions and must be located with 5 thousand kilometers of each other.
• C. A single fault domain can be associated with multiple regions and availability domains.
• D. An OCI region is a localized geographic area, and an availability domain is one or more data centers located within a region.

Answer: AC

NEW QUESTION 22
Which Java Database Connectivity (JDBC) thin client version supports the use of HTTP proxy settings that does NOT support TCP to connect to Autonomous Data Warehouse?

• A. 17.4 onwards
• B. Any version
• C. 12c Release 2 onwards
• D. 18.1 onwards

Answer: D

NEW QUESTION 23
Once you have a connection to the Autonomous Data Warehouse, how do you import tables into the Oracle Analytics Cloud (OAC)?

• A. Import Table
• B. Create a Data Set
• C. Replicate the table using Golden Gate
• D. Load data using Data Pump

Answer: D

NEW QUESTION 24
......