1z0-931 Exam - Oracle Autonomous Database Cloud 2019 Specialist

NEW QUESTION 1
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 2
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 3
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 4
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 5
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 6
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 7
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 8
Which is correct about security features that are available in Oracle Autonomous Database?

• A. Neither Data Redaction nor TDE are supported .
• B. Data Redaction but not TDE
• C. TDE but not Data Redaction
• D. Data Redaction and TDE are both supported

Answer: A

NEW QUESTION 9
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 10
Which operating system can Data Visualization Desktop be run on?

• A. Linux
• B. Solaris
• C. Windows
• D. AIX

Answer: C

Explanation:
https://www.oracle.com/middleware/technologies/oracle-data-visualization-desktop.html

NEW QUESTION 11
Which is NOT required to connect to Autonomous Database from SQL developer?

• A. Service name
• B. Wallet file
• C. Database name
• D. Username and password

Answer: C

NEW QUESTION 12
Autonomous Data Warehouse configures and optimizes your database for you, therefore you do not need to perform some of the administration operations for configuring the database.
Which statement is true regarding the default configuration of the Autonomous Data Warehouse?

• A. Adding, removing, or modifying tablespaces is allowed.
• B. Degree of parallelism for SQL statements is set based on the number of OCPUs in the system and the database service the user is connecting to.
• C. In Autonomous Data Warehouse direct access to the database node and the local file system is allowed.
• D. Compression is not enabled by default and you must specify the compression method for your tables with the compression clause in your CREATE TABLE and ALTER TABLE commands.

Answer: A

NEW QUESTION 13
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 14
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 15
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 16
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 17
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 18
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 19
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 20
Which method can be used to migrate on-premises databases to Autonomous Databases in cloud?

• A. RMAN backup & restore
• B. Physical migration method like database cloning
• C. Data Pump
• D. Original Import/Export tools

Answer: C

NEW QUESTION 21
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 22
When running lots of high concurrent queries in Autonomous Database, you should use which predefined service connection?

• A. DBNAME_MEDIUM
• B. DBNAME_HIGH
• C. DBNAME_CONCURRENT
• D. DBNAME_LOW

Answer: B

NEW QUESTION 23
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 24
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 25
What is the default retention period for both Automatic and Manual Autonomous Database Backups?

• A. One Year
• B. 90 days
• C. 7 days
• D. 30 days
• E. 60 days

Answer: D

NEW QUESTION 26
......