Vivid 1z0-931 Cram 2021

NEW QUESTION 1
Which open source orchestration tool can be used to provision autonomous database resources in Oracle Cloud Infrastructure?

• A. Terraform
• B. Enterprise Manager
• C. REST API
• D. Dlocker

Answer: A

Explanation:
https://blogs.oracle.com/cloud-infrastructure/getting-started-with-the-resource-manager-on-oracle-cloud-infrastr

NEW QUESTION 2
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 3
What are three methods to load data into the Autonomous Database?

• A. Transportable Tablespace
• B. Oracle Data Pump
• C. RMAN Restore
• D. Oracle GoldenGate
• E. SQL*Loader

Answer: BDE

NEW QUESTION 4
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 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
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 7
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 8
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 are terminated and rolled back.
• C. Active transactions are paused.
• D. Active transactions continue running unaffected.

Answer: A

NEW QUESTION 9
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 10
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 11
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 12
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 13
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 14
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 15
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 16
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 only load files into tables (insert-only), the customer has to write the additional code.
• B. Data Sync can not transform your data while loading it into the destination table.
• C. Data Sync can load a combination of data source, such as xsv, .xlsx and Oracle relational files.
• D. Data Sync can only load data from one source into one destination table.

Answer: C

NEW QUESTION 17
Which three tasks by default are taken care of by the Autonomous Database?

• A. Database Upgrades
• B. Application User Creation
• C. Backups
• D. Firmware Patching
• E. Data Loading

Answer: ADE

NEW QUESTION 18
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 19
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 20
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 21
Which two are correct actions to take in order to Download the Autonomous Database Credentials?

• A. Find the Service Console for your Autonomous Database, then pick Administration, then Download the Client Credentials (Wallet).
• B. Click the Compute section of the menu, then choose Instance Configurations, then Download Wallet.
• C. Click on the Autonomous Data Warehouse section, pick a database, then Choose Actions, then Download the Wallet.
• D. Click on the Autonomous Data Warehouse in the menu, click a database name, then Choose DB Connection button, then Download the Wallet.
• E. Click on the Object Storage and find your Autonomous Bucket and Download the Wallet Credentials.

Answer: CD

NEW QUESTION 22
Which of these database features is NOT part of the Autonomous Database?

• A. Flashback Database
• B. Java in the Database
• C. Real Application Clusters (RAC)
• D. Online Indexing

Answer: C

NEW QUESTION 23
Which three data dictionary views contain information about analytic view objects?

• A. ALL_ANALYTIC_VIEW_PATHS
• B. ALL_ANALYTIC_VIEW_DIM_CLASS
• C. ALL_ANALYTIC_VIEW_ID_ATTRS
• D. ALL_ANALYTIC_VIEW_LVLGRPS
• E. ALL_ANALYTIC_VIEW_KEYS

Answer: B

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