[Apr 01, 2022] Valid 1Z0-931-21 Test Answers & 1Z0-931-21 Exam PDF
Valid Oracle Autonomous Database 1Z0-931-21 Dumps Ensure Your Passing
Oracle 1Z0-931-21 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
| Topic 7 |
|
NEW QUESTION 11
You are requested to analyze a year's stock purchase data which is stored in Autonomous Data Warehouse instance.
Which tool would you use to automate data exploration and create pivot tables?
- A. SQL Developer Web
- B. APEX
- C. Business Models
- D. Data Load
Answer: C
Explanation:
NEW QUESTION 12
Which statement is NOT correct when using Automatic Indexing on Autonomous Data Warehouse?
- A. It is enabled by default.
- B. You can use the dbms_auto_index package to report on the automatic task and to set your preferences.
- C. You can control behavior at the statement level using the use_aoto_indexes or NO_USE_AUTO_INDEXES hints.
- D. The indexing feature is implemented as an automatic task that runs at a fixed interval.
- E. Process includes identify candidates, create invisible auto indexes , verify with implement if performance improved and delete unused.
Answer: D
NEW QUESTION 13
You need to set up a notification for a scheduled shutdown of an Autonomous Database instance. What should you do?
- A. Create a rule for the Oracle Cloud Infrastructure Event for "Autonomous Database STOP END"
- B. Create a notification alert using DBMS_SNMP package
- C. Add a "BEFORE SHUTDOWN ON DATABASE" trigger within the database
- D. Create an Oracle Cloud Infrastructure Alarm for Shutdown metric
Answer: A
Explanation:
NEW QUESTION 14
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. Find the Service Console for your Autonomous Database, then pick Administration, then Download the Client Credentials (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. Click on the Autonomous Data Warehouse section, pick a database, then Choose Actions, then Download the Wallet.
Answer: A,B
NEW QUESTION 15
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 Subnet and 1 Compartment are allowed, multiple Groups highly advised.
- C. Create at least 2 of each resource
- D. Only 1 of each is allowed to be allocated per environment.
Answer: C
Explanation:
Refer to Best Practices When Planning and Instituting Access Controls section in the https://docs.oracle.com/en/cloud/paas/autonomous-database/atpfg/plan-and-create-access-constraints1.html#GUID-ED48C3D3-FC0F-41D5-882A-FC2D916FD6AA
https://docs.oracle.com/en/cloud/paas/autonomous-database/atpfg/plan-and-create-accessconstraints1.Html
NEW QUESTION 16
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 a new developer account.
- B. Create a database user with the APEX role.
- C. Create an IDCS user with the APEX role.
- D. Access the APEX Administration Services and create the workspace for the developer.
Answer: D
Explanation:
https://docs.oracle.com/en/database/oracle/application-express/19.1/htmig/creating-workspace-and-adding-Oracle-AE-users.html#GUID-1040F145-452A-49D4-BCF6-A80851AFFA74 Create a New Instance Administrator Login to the INTERNAL workspace as the ADMIN user, or another existing admin user.
Click the "Create User" link on the right-hand menu.
For a new admin user enter mandatory items and the following.
Workspace : INTERNAL
Default Schema : APEX_180200 {or whatever the highest version is}
User is an administrator: Yes
Account Availability : Unlocked
Password and Confirmation Password.
Require Change of Password on First Use : Yes
Click the "Create User" button.
https://oracle-base.com/articles/misc/apex-tips-basic-apex-management
NEW QUESTION 17
Which data file format is NOT supported when using the package DBMS_CLOUD on Shared Exadata Infrastructure?
- A. Data Pump Export File
- B. Microsoft SQL Server (.mdf)
- C. JSON
- D. Text
- E. Parquet
- F. Avro
Answer: F
NEW QUESTION 18
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 an IDCS user. Create a database user with connect, resource, and object privileges.
- B. 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.
- C. Create a database user with the default privileges.
- D. Create a database user with connect, resource, and object privileges.
Answer: B
NEW QUESTION 19
What is the correct way to list all files in the default data pump directory?
- A. Log onto ADW server and issue is -al on the command line.
- B. By executing select * from DBMS_CLOUD.LIST_FILES('DATA_PUMP_DIR');
- C. You cannot list files in the default data pump directory from Autonomous Data Warehouse (ADW).
- D. By executing select * from utl_file . list ( 'DATA_PUMP_DIR ' ) ;
Answer: B
NEW QUESTION 20
Your customer wants to permanently disable scheduled maintenance on Autonomous Dedicated Infrastructure to keep their current database version(s).
How can they achieve this?
- A. Change the Automatic Maintenance Schedule to 'None'd.
- B. You cannot permanently disable scheduled Automatic Maintenance.
- C. Change the Automatic Maintenance Schedule to 'Specify a Schedule' but do not select any month, week or day.
- D. Change the Automatic Maintenance Schedule to 'No Preference'.
Answer: C
NEW QUESTION 21
Which statement is FALSE about Oracle Autonomous JSON Database?
- A. There is a 20 GB limit on JSON collection
- B. You can promote Autonomous JSON Database to Autonomous Transaction /Processing
- C. JSON data is stored natively in the database
- D. It supports NoSQL-style, document-centric application
Answer: A
Explanation:
NEW QUESTION 22
In the Autonomous Database (ADB) Dedicated service, what does the fleet administrator use to control OCPU utilization?
- A. Oracle Machine Learning notebook
- B. Compartment quotas
- C. Resource Manager settings
- D. SQL Developer Web Console
Answer: C
NEW QUESTION 23
When working with an Autonomous Exadata Infrastructure supporting Autonomous Databases, where do you go to view the maintenance history of the Exadata?
- A. Under Solutions and Platform then Platform Services then Autonomous Exadata
- B. Under Core Infrastructure then Autonomous Exadata
- C. Under Database then Autonomous Transaction Processing then Autonomous Exadata
- D. Under Core Infrastructure then Compute then Autonomous Exadata
Answer: C
Explanation:
https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/adbmanaginginfrastructure.htm#viewmaintenancehistory
https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/adbmanaginginfrastructure.htm#viewmaintenancehistory.
Even though the UI has changed recently, this documentation has the user go to Menu -> Database
NEW QUESTION 24
Which statement is not correct when the Autonomous Database is stopped?
- A. Tools are no longer able to connect to a stopped instance
- B. In-flight transactions queries are stopped
- C. CPU billing is halted
- D. User with DWROLE can still access the database
Answer: D
Explanation:
NEW QUESTION 25
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 a new developer account.
- B. Create a database user with the APEX role.
- C. Create an IDCS user with the APEX role.
- D. Access the APEX Administration Services and create the workspace for the developer.
Answer: D
NEW QUESTION 26
How can an Autonomous Database resource be provisioned without logging into the Oracle Cloud Infrastructure console?
- A. Using Database Configuration Assistant (DBCA) on the database server.
- B. Using the Oracle Cloud Infrastructure Command Line interface tool or REST API calls.
- C. It cannot be done.
- D. Connecting to the Cloud Infrastructure Command console via SSH wallet.
Answer: B
Explanation:
The CLI is a small footprint tool that you can use on its own or with the Console to complete Oracle Cloud Infrastructure tasks. The CLI provides the same core functionality as the Console, plus additional commands.
https://blogs.oracle.com/datawarehousing/managing-autonomous-data-warehouse-using-oci-curl Examples of using Autonomous Database managing by REST API
https://oracle.github.io/learning-library/workshops/autonomous-transaction-processing/LabGuide900ConfigureOCI-CLI.md
NEW QUESTION 27
While Autonomous Transaction Processing and Autonomous Data Warehouse use the same Oracle database, which statement is true about the workloads?
- A. Data that is bulk loaded, by default, uses the row format in Autonomous Transaction Processing where Autonomous Data Warehouse data format is columnar.
- B. Autonomous Transaction Processing workloads are optimized for data warehouse, data mart, and data lake.
- C. Autonomous Data Warehouse workloads are optimized for mixed workloads.
- D. Autonomous Transaction Processing memory usage optimizes workloads for parallel joins and aggregations.
Answer: A
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-4147-9606-0413D9CC1589
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/autonomous-intro-atp.html#GUID-B90147B2-EA04-4147-9606-0413D9CC1589
NEW QUESTION 28
What REST verb is used to create an Autonomous Database service using REST APIs?
- A. A "POST" REST call
- B. A "GET" REST call
- C. An "INSERT" REST call
- D. A "PUT" REST call
Answer: A
Explanation:
https://docs.oracle.com/en/cloud/paas/integration-cloud/rest-api/SendRequests.html
NEW QUESTION 29
Which three event types are supported for Autonomous Database?
- A. Change Compartment Begin
- B. Change Autoscaling Configuration Compartment
- C. Maintenance Begin
- D. Terminate End
- E. Update IORM Begin
Answer: A,C,D
Explanation:
https://docs.oracle.com/en-us/iaas/Content/Events/Reference/eventsproducers.htm
NEW QUESTION 30
How do you change the tablespace quota for a user on Autonomous Database on Shared Infrastructure?
- A. Execute alter tablespace DATA set quota = 10G;
- B. Execute alter database for user MTHEO tablespace DATA quota = 10G;
- C. Execute DBMS_CLOUD_ADMIN. GRANT_TABLESPACE_QOOTA (username => 'MTHEO' , tablespace__quota => "UNLIMITED*);
- D. Execute alter user MTHEO quota unlimited on tablespace DATA;
Answer: A
NEW QUESTION 31
Which statement is true when you provision an Autonomous Database using the cloning method?
- A. A clone database source can be a running database instance.
- B. When cloning an Autonomous Database, Oracle Machine Learning workspaces, projects, and notebooks of the source database are cloned to the new database.
- C. A clone database source can be from a point-in-time backup that is less than 2 hours old.
- D. After an Autonomous database is created using a clone, the network access option can be changed.
Answer: A
Explanation:
NEW QUESTION 32
Which three event types are supported for Autonomous Database?
- A. Change Compartment Begin
- B. Change Autoscaling Configuration Compartment
- C. Maintenance Begin
- D. Terminate End
- E. Update IORM Begin
Answer: A,C,D
Explanation:
https://docs.oracle.com/en-us/iaas/Content/Events/Reference/eventsproducers.htm
NEW QUESTION 33
You need to create a new database via the Oracle Cloud Infrastructure (OCI) CLI with the following requirements:
* Autonomous Transaction Processing
* License Included
* Shared Infrastructure
Which parameter would you NOT use?
- A. license-model
- B. db-workload
- C. is-dedicated
- D. db-type
Answer: C
NEW QUESTION 34
......
1Z0-931-21 Dumps Real Exam Questions Test Engine Dumps Training: https://www.prepawaypdf.com/Oracle/1Z0-931-21-practice-exam-dumps.html
1Z0-931-21 exam dumps and online Test Engine: https://drive.google.com/open?id=1bo485vjpB_QjOMuQN7gMUz97QM8H8faw