Refined 1z0-931 Guidance 2021

NEW QUESTION 1
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 2
How can an Autonomous Database resource be provisioned without logging into the Oracle Cloud Infrastructure console?

• A. Connecting to the Cloud Infrastructure Command console via SSH wallet.
• B. It cannot be done.
• C. Using Database Configuration Assistant (DBCA) on the database server.
• D. Using the Oracle Cloud Infrastructure Command Line interface tool or REST API calls.

Answer: A

NEW QUESTION 3
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: D

NEW QUESTION 4
While Autonomous Transaction Processing and Autonomous Data Warehouse use the same Oracle database, which statement is true about the workloads?

• A. Autonomous Data Warehouse workloads are optimized for mixed workloads.
• B. Autonomous Transaction Processing workloads are optimized for data warehouse, data mart, and data lake.
• C. Data that Is bulk loaded, by default, uses the row format in Autonomous Transaction Processing where Autonomous Data Warehouse data format Is columnar.
• D. Autonomous Transaction Processing memory usage optimizes workloads for parallel joins and aggregations.

Answer: A

NEW QUESTION 5
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 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
The default eight day retention period for Autonomous Database performance data can be modifiedusing whichDBMS_WORKLOAD_REPOSITORY subprogram procedure?

• A. MODIFY_SNAPSHOT_SETTINGS
• B. UPDATE_OBJECT_INFO
• C. CREATE_BASELINE_TEMPLATE
• D. UPDATE_OBJECT_INFO

Answer: A

Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/monitor-performance-intro.html#

NEW QUESTION 8
Which two statements are true with regards to Oracle Data Sync?

• A. Data Sync can use a normal OCI (thick) client connection to connect to an Oracle database.
• B. Data Sync has default drivers available that supported loading data from DB2, Microsoft SQL Server, MySQL and Teradata.
• C. Data Sync can connect to any jdbc compatible source like MongoDB, RedShift and Sybase.
• D. Data Sync can load your data in parallel in order to speed up the loading process.

Answer: D

NEW QUESTION 9
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. SCOTT
• B. ADMIN
• C. SYS
• D. DWDEV

Answer: A

NEW QUESTION 10
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 11
In which way can a SQL Developer help you test your data loading scenario to Autonomous Database (ADB)?

• A. In the TEST phase, a temporary table will be populated with the records before inserting them in the destination table.
• B. In the Column Definition Phase, the system cross-references with the file-contents and shows the conflicts with the definition.
• C. In the TEST phase of the wizard, a subset of accepted records are displayed based on your definition.
• D. In the TEST phase of the wizard a list is generated containing the records that would be rejected during import.

Answer: C

NEW QUESTION 12
Which three statements are true regarding how Autonomous Database provides data security?

• A. Network connections from clients to Autonomous Database are encrypted using the client credentials wallet.
• B. Data is encrypted at rest using transparent data encryption.
• C. Oracle automatically applies security updates to ensure data is not vulnerable to known attack vectors.
• D. Users are given OS logons or SYSDBA privileges to prevent phishing attacking.

Answer: ACD

NEW QUESTION 13
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 14
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 15
Which two PL/SQL functions can be used to validate an analytic view?

• A. VALIDATE_ANALYTIC_VIEW
• B. VALIDATE_LEVELS
• C. VALIDATE_MEASURES
• D. VALIDATE_DIMENSION
• E. VALIDATE_HIERARCHY

Answer: AE

Explanation:
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/dwhsg/overview-analytic-views.html#GUID-6F

NEW QUESTION 16
Which can be Scaled independently of the number of CPUs in an Autonomous Database?

• A. Concurency
• B. Memory
• C. Parallelism
• D. Storage
• E. Sessions

Answer: B

NEW QUESTION 17
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 18
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 19
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 20
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 21
When exporting a notebook, what type of file is created?

• A. SQL
• B. JSON
• C. ASCII
• D. XML
• E. TXT

Answer: B

NEW QUESTION 22
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 i.
• B. Medium provides intermediate resource and concurrency, and queries run in a serial.
• C. High provides highest resources, lowest concurrency, and DoP is 1.
• D. Low provides highest concurrency, lowest resources, and DoP =1.

Answer: D

NEW QUESTION 23
When you connect Oracle Analytics Cloud to the Autonomous Data Warehouse, what file needs to be uploaded?

• A. OJDBC.PROPERTIES
• B. CWALLET.SSO
• C. SQLNET.ORA
• D. TNSNAMES.ORA

Answer: B

NEW QUESTION 24
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 25
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 26
......