Update 1z0-931 Dump 2021

NEW QUESTION 1
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 2
Which statement is true regarding database client credentials file required to connect to your Autonomous Database?

• A. When you share the credential files with authorized users, mail the wallet password and the file in the same email.
• B. The Transparent Data Encryption (TDE) wallet can be used for your client credentials to connect to your database.
• C. Place the credential files on a share drive that all users can use to connect to the database.
• D. Store credential files in a secure location and share the files only with authorized users to prevent unauthorized access to the database.

Answer: B

NEW QUESTION 3
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 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
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
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 7
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 8
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 9
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 10
Which three statements are true about procedures in the DBMS_CLOUD package?

• A. The DBMS_CLOUD.DELETE_FILE procedure removes the credentials file from the Autonomous Data Warehouse database.
• B. The DBMS_CLOUD.CREATE_CREDENTIAL procedure stores Cloud Object Storage credentials in the Autonomous Data Warehouse database.
• C. The DBMS_CLOUD.PUT_OBJECT procedure copies a file from Cloud Object Storage to the Autonomous Data Warehouse.
• D. 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.
• E. The DBMS_CLOUD.CREATE_EXTERNAL_TABLE procedure creates an external table on files in the clou
• F. You can run queries on external data from the Autonomous Data Warehouse.

Answer: ACD

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
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 13
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 14
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 15
What two tasks can be executed from the service console for Autonomous Databases?

• A. Autonomous Databases monitoring for usage and query performance.
• B. Wizard to download connection wallet for connection from desktop tools.
• C. Creating and scaling of Autonomous Database service.
• D. Creating schemas.

Answer: CD

NEW QUESTION 16
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 17
Which two system privileges does a user need to create analytic views?

• A. CREATE ATTRIBUTE DIMENSION
• B. CREATE ANALYTIC VIEW
• C. CREATE ANALYTIC MEASURE
• D. CREATE ANALYTIC LEVEL
• E. CREATE ANALYTIC HIERARCHY

Answer: BD

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 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 20
Given the steps:
1. Create Oracle Machine Learning User
2. Create projects
3. Create workspaces
4. Create Notebooks
5. Run SQL Scripts
Which two steps are out of order when working with Oracle Machine learning?

• A. Run SQL Scripts
• B. Create Notebooks
• C. Create workspaces
• D. Create projects
• E. Create Oracle Machine Learning User

Answer: AD

NEW QUESTION 21
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 22
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 23
......