How Many Questions Of 1z0-931-20 Training

NEW QUESTION 1
You are the admin user of an Autonomous Database (ADB) instance. A new business analyst has joined the team and would like to explore ADB tables using SQL Developer Web.
What steps do you need to take?

• A. Create a database user (with connect, resource, object privileges), enable the schema to use SQL Developer and provide the user with the user-specific modified URL.
• B. Create a database user with the default privileges.
• C. Create a database user with connect, resource, and object privileges.
• D. Create an IDCS use
• E. Create a database user with connect, resource, and object privileges.

Answer: A

NEW QUESTION 2
During the provisioning of an Autonomous Database on Dedicated hardware, what does the Database Administrator need to select to determine where the Autonomous Database is created on the Dedicated infrastructure?

• A. the name or OCID of the Exadata infrastructure which was assigned by the the Fleet Administrator
• B. the Client Credentials wallet which is used to connect to the Autonomous Database
• C. the 'High Availability Container Database' in which the Autonomous instance should run
• D. the Compartment of the Dedicated infrastructure as each compartment only runs 1 Dedicated environment
• E. the Listener endpoint where the Autonomous Database should register on

Answer: B

NEW QUESTION 3
Which method will NOT permit you to change the database Admin Password of a Autonomous Database on Shared Infrastructure?

• A. Admin page of the Cloud Service Console
• B. OCI CLI
• C. OS command line from the database server.
• D. SQLDeveloper

Answer: B

NEW QUESTION 4
According to Oracle documentation, it is a best practice when planning and instituting Access Controls for your Autonomous Dedicated environment regarding Subnets, Compartments and User Groups.
Which statement is true?

• A. Create a separate VCN that contains only public subnets
• B. Only 1 of each is allowed to be allocated per environment.
• C. Only 1 Subnet and 1 Compartment are allowed, multiple Groups highly advised.
• D. Create at least 2 of each resource

Answer: C

NEW QUESTION 5
You are the admin of an Autonomous Database (ADB) instance, and a new developer has requested a new workspace in APEX.
What statement describes the step to provide the developer a new workspace in APEX?

• A. Create an IDCS user with the APEX role.
• B. Access the APEX Administration Services and create the workspace for the developer.
• C. Create a new developer account.
• D. Create a database user with the APEX role.

Answer: B

NEW QUESTION 6
Which three event types are supported for Autonomous Database?

• A. Terminate End
• B. Maintenance Begin
• C. Change Compartment Begin
• D. Change Autoscaling Configuration Compartment
• E. Update IORM Begin

Answer: ABC

Explanation:
https://docs.oracle.com/en-us/iaas/Content/Events/Reference/eventsproducers.htm

NEW QUESTION 7
How do you change the tablespace quota for a user on Autonomous Database on Shared Infrastructure?

• A. Execute alter database for user MTHEO tablespace DATA quota = 10G;
• B. Execute alter user MTHEO quota unlimited on tablespace DATA;
• C. Execute DBMS_CLOUD_ADMI
• D. GRANT_TABLESPACE_QOOTA (username => 'MTHEO' ,Tablespace___quota => "UNLIMITED*);
• E. Execute alter tablespace DATA set quota = 10G;

Answer: D

NEW QUESTION 8
When using Data Pump to migrate your Oracle database to Autonomous Database, which two objects are imported?

• A. Data
• B. Schemas
• C. Tablespaces
• D. Reports

Answer: AB

NEW QUESTION 9
What is the role of a Fleet Administrator in Autonomous Database (ADB) on Dedicated Infrastructure deployments?

• A. Fleet Administrator defines and gains access to the ADMIN administrative user account for the database.
• B. Fleet administrators create, monitor and manage Autonomous Exadata Infrastructure and Autonomous Container Database resources.
• C. Fleet Administrators are responsible for patching and backups of all container databases.
• D. Fleet Administrators create, monitor and manage Autonomous Databases.

Answer: B

NEW QUESTION 10
Which three Oracle Cloud Infrastructure (OCI) resources do you need to configure before provisioning your Autonomous Database with Private Endpoint?

• A. Network Security Group
• B. Security List
• C. VCN
• D. Route Table
• E. Subnet

Answer: ACE

Explanation:
To provision an Autonomous Database with a private endpoint, you must have the following resources alrea created:
A VCN within the region that will contain your Autonomous Database with shared Exadata infrastructure. Cannot be changed after provisioning.
A private subnet within your VCN configured with default DHCP options. Cannot be changed after provisioning.
At least 1 network security group (NSG) within your VCN for the Autonomous Database. Can be changed or edited after provisioning.
https://docs.oracle.com/en-us/iaas/Content/Database/Concepts/adbsprivateaccess.htm

NEW QUESTION 11
Which statement is NOT correct when setting up compartment quotas?

• A. There are three types of quota policy statements which are set, unset and zero.
• B. Compartment quotas use policies that allow allocation of resources with a high level of flexibility.
• C. Along with compartment budgets, compartment quotas create a powerful toolset to manage your spending.
• D. Compartment quotas are set by Oracle.

Answer: C

NEW QUESTION 12
What is the correct way to list all files in the default data pump directory?

• A. By executing select * from DBMS_CLOUD.LIST_FILES('DATA_PUMP_DIR');
• B. You cannot list files in the default data pump directory from Autonomous Data Warehouse (ADW).
• C. Log onto ADW server and issue is -al on the command line.
• D. By executing select * from utl_file . list ( ‘DATA_PUMP_DIR ' ) ;

Answer: A

NEW QUESTION 13
Which two statements are true when running DBMS_CLOUD.COPY_DATA? (Choose two.)

• A. The source file can be in either Oracle Standard Storage or Oracle Archive Storage bucket in the Object Store.
• B. The source files can reside in Oracle Object Storage, Amazon S3 Object storage, or Azure Blob storage.
• C. A valid credential must be created prior to running the DBMS_CLOUD.COPY_DATA procedure.
• D. The source file will be automatically removed after the DBMS_CLOUD.COPY_DATA procedure finishes successfully.
• E. The target table will be created in Autonomous Database if it does not already exist.

Answer: BC

Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/file-uri-formats.html#GUID-5D3 https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/dbms-cloud.html#GUID-9428EA

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

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

Answer: D

Explanation:
- Both ADW and ATP share the Autonomous Database platform of Oracle Database on Exadata Cloud infrastructure.
The difference is how the services have been optimized within the database. When you start loading data into the autonomous database, we store the data in the appropriate format for the workload.
* If it is ADW, then we store data in columnar format because that's the best format for analytics processing.
• If it is ATP, then we store the data in row format because that's the best format for fast single row lookups.
- Oracle Autonomous Database is offered in two workload-optimized flavors
* Autonomous Data Warehouse (ADW), which has been optimized for analytic workloads
• Autonomous Transaction Processing (ATP). ATP is optimized for transaction processing or mixed workload https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/autonomous-intro-atp.html#GUID-B90147B2-EA04-414 https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/autonomous-intro-atp.html#GUID-B90147B2-EA04-414

NEW QUESTION 15
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. Pluggable databases cannot be migrated to ADB using plug, unplug or clone.
• B. Create a database link from source database to the ADB environment and clone the PDB.
• C. Unplug to an xml file so database files and xml file can be uploaded to object storage.
• D. Unplug into a pdb archive which can be uploaded to object storage.

Answer: A

Explanation:
Since an ADB database has some restrictions on the object types and Oracle Database Options you need to use a logical migration method rather than a physical one.
The main migration tool for migrating to ADB is Data Pump. You can export your schemas and import them into ADB using Data Pump. To sync up the additional/incremental changes on the source database during the export/import process you can use GoldenGate or GoldenGate Cloud Service to replicate those changes to ADB.
In the current release you cannot use physical migration methods like backup/restore, Data Guard, Pluggable/Unplug , database clones, and transportable tablespaces to move your existing database to ADB.

NEW QUESTION 16
Which data file format is NOT supported when using the package DBMS_CLOUD on Shared Exadata Infrastructure?

• A. Data Pump Export File
• B. Avro
• C. Parquet
• D. Text
• E. JSON
• F. Microsoft SQL Server (.mdf)

Answer: B

NEW QUESTION 17
Which two are correct actions to take in order to Download the Autonomous Database Credentials?

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

Answer: AE

NEW QUESTION 18
Oracle Data Safe is a unified control center for your Oracle databases which helps you understand the sensitivity of your data, evaluate risks to data, mask sensitive data, implement and monitor security controls, assess user security, monitor user activity, and address data security compliance requirements.
Which statement is FALSE?

• A. Oracle Data Safe only supports Autonomous Databases.
• B. Oracle Data Safe helps you assess the security of your cloud database configurations by analyzing database configurations.
• C. Oracle Data Safe helps you find sensitive data in your database by inspecting the actual data in your database and its data dictionary.
• D. Oracle Data Safe evaluates user types, how users are authenticated, and the password policies assigned to each user.

Answer: A

NEW QUESTION 19
Which two options are available to restore an Autonomous Data Warehouse? (Choose two.)

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

Answer: DE

Explanation:
In the Restore prompt, select Specify Timestamp or Select Backup to restore to a point in time or to restore
from a specified backup.
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/backkup-recover.html#GUID-78

NEW QUESTION 20
You have a requirement to create an Autonomous Transaction Processing database that can support at least 200 concurrent statements per OCPU as well as parallelism.
Which service will you need to connect to?

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

Answer: A

Explanation:
tpurgent: The highest priority application connection service for time critical transaction processing operations. This connection service supports manual parallelism.
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/connect-predefined.html#GUID-9747539B-FD46-44F1-8

NEW QUESTION 21
An Autonomous Database (ADB) user with an instance wallet has left the company and they shared a database user id with other users when accessing ADB.
Other than changing the shared user password, what can the admin do to protect the instance?

• A. Trust the user who left to not access the database.
• B. Shutdown and restart the instance.
• C. Rotate the instance wallet and share the new wallet with the remaining users.
• D. Delete the user.

Answer: B

NEW QUESTION 22
What are two differentiators of Oracle Autonomous Database Dedicated Infrastructure?

• A. Users have OS access to the database machine.
• B. Users can customize the maintenance schedule.
• C. It offers greater control and isolation starting at the Exadata cloud infrastructure level.
• D. Users have SYS privileges in the database.
• E. Users can customize the OS stack and add additional packages

Answer: CD

NEW QUESTION 23
......