Get ready to pass the 1Z0-931-20 Exam right now using our Oracle Cloud Exam Package
A fully updated 2021 1Z0-931-20 Exam Dumps exam guide from training expert DumpsTorrent
NEW QUESTION 34
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 Compartment of the Dedicated infrastructure as each compartment only runs 1 Dedicated environment
- B. the Listener endpoint where the Autonomous Database should register on
- C. the name or OCID of the Exadata infrastructure which was assigned by the the Fleet Administrator
- D. the 'High Availability Container Database' in which the Autonomous instance should run
- E. the Client Credentials wallet which is used to connect to the Autonomous Database
Answer: E
NEW QUESTION 35
Which task is NOT automatically performed by the Oracle Autonomous Database?
- A. Patching the database.
- B. Automatically optimize the workload.
- C. Mask your sensitive data.
- D. Backing up the database.
Answer: C
Explanation:
- Oracle patch the full stack-including the firmware, the OS, clusterware, and the database.
- Oracle Autonomous Database is actually a family of cloud services, with each member of the family optimized by workload. Autonomous Data Warehouse (ADW), which has been optimized for analytic workloads and Autonomous Transaction Processing (ATP). ATP is optimized for transaction processing or mixed workload.
- it is possible to use Oracle Data Safe data masking capabilities with cloned instances of ADB. but by the customer
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/autonomous-key-features.html#GUID-7D0627D9-1B40-40B1-865A-84FF65A65846
NEW QUESTION 36
While creating an Autonomous Container Database on dedicated infrastructure through the Oracle Cloud Infrastructure (OCI) console, which patch type is offered to be applied during maintenance?
- A. Prior Release Update (PRU)
- B. Quarterly Bundle Patch (QBP)
- C. Release Update (RU)
- D. Prior Release Update Revision (PRUR)
Answer: C
NEW QUESTION 37
When working with an Autonomous Exadata Infrastructure supporting Autonomous Databases, where do you go to view the maintenance history of the Exadata?
- A. Under Core Infrastructure then Compute then Autonomous Exadata
- B. Under Core Infrastructure then Autonomous Exadata
- C. Under Database then Autonomous Transaction Processing then Autonomous Exadata
- D. Under Solutions and Platform then Platform Services then Autonomous Exadata
Answer: A
NEW QUESTION 38
When you choose to scale your Autonomous Database, which statement is true in regards to OCPUs and storage?
- A. Increasing OCPUs will automatically increase storage.
- B. Storage in TB cannot be larger than the number of OCPUs.
- C. OCPUs and storage must remain in sync.
- D. OCPUs and storage can be scaled independently.
Answer: D
Explanation:
You simply specify the number of OCPUs and the storage capacity in TB's for the database. At any time, you may scale, increase or decrease either the OCPUs or the storage capacity.
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/autonomous-add-resources.html#GUID-DA72422A-5A70-42FA-A363-AB269600D4B0
NEW QUESTION 39
What are three methods to load data into the Autonomous Database? (Choose three.)
- A. SQL*Loader
- B. Transportable Tablespace
- C. Oracle Data Pump
- D. RMAN Restore
- E. Oracle GoldenGate
Answer: A,C,E
Explanation:
https://www.oracle.com/database/technologies/datawarehouse-bigdata/adb-faqs.html#ATPD
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/load-data-intro.html#GUID-5D2F70D8-4FA1-482C-BFB0-43441FB897F3
NEW QUESTION 40
Which statement is true in regards to database links?
- A. Connect from Autonomous Database to remote database using a database link.
- B. You can call PL/SQL procedures and functions using a database link.
- C. Connect to Autonomous Database from remote database using a database link.
- D. Create a database link from one Autonomous Database to another Autonomous Database instance.
Answer: C
Explanation:
https://blogs.oracle.com/datawarehousing/how-to-create-a-database-link-from-an-autonomous-data-warehouse-to-a-database-cloud-service-instance-v2
https://blogs.oracle.com/datawarehousing/making-database-links-from-adw-to-other-databases
NEW QUESTION 41
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. Subnet
- C. Security List
- D. Route Table
- E. VCN
Answer: A,B,E
Explanation:
To provision an Autonomous Database with a private endpoint, you must have the following resources already 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 42
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. TPURGENT
- B. HIGH
- C. MEDIUM
- D. TP
Answer: A
Explanation:
https://github.com/oracle/cloudtestdrive/blob/master/ATP/LabGuideOSC200Connect.md
NEW QUESTION 43
How do you change the tablespace quota for a user on Autonomous Database on Shared Infrastructure?
- A. Execute alter user MTHEO quota unlimited on tablespace DATA;
- B. Execute alter tablespace DATA set quota = 10G;
- C. Execute DBMS_CLOUD_ADMIN. GRANT_TABLESPACE_QOOTA (username => 'MTHEO' , tablespace__quota => "UNLIMITED*);
- D. Execute alter database for user MTHEO tablespace DATA quota = 10G;
Answer: B
NEW QUESTION 44
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. HIGH
- B. TPURGENT
- C. TP
- D. MEDIUM
Answer: D
Explanation:
Medium is A typical application connection service for reporting and batch operations. All operations run in parallel and are subject to queuing. Using this service the degree of parallelism is limited to four (4) and concurrency is 1.25 X CPU_COUNT QUERIES
NEW QUESTION 45
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. Low provides highest concurrency, lowest resources, and DoP =1.
- B. High provides highest concurrency and lowest resources, and DoP is 1.
- C. Medium provides intermediate resource and concurrency, and queries run in a serial.
- D. High provides highest resources, lowest concurrency, and DoP is 1.
Answer: A
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/connect-predefined.html#GUID-9747539B-FD46-44F1-8FF8-F5AC650F15BE
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/manage-priorities.html#GUID-80E464A7-8ED4-45BB-A7D6-E201DD4107B7
NEW QUESTION 46
When exporting a notebook, what type of file is created?
- A. TXT
- B. JSON
- C. XML
- D. ASCII
- E. SQL
Answer: B
Explanation:
Export a Notebook
You can export a notebook as a .json (JavaScript Object Notation) file, and later import it in to the same or a different environment.
To export a notebook:
- In the Notebooks page, click the notebook that you want to export. The notebook opens in the notebook editor.
- In the top panel of the notebook editor, click export. The notebook is saved to your local folder as a .json file.
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/omlug/get-started-notebooks-data-analysis-and-data-visualization.html#GUID-009B9073-4B45-4505-8DAD-F1F04FD3E160
NEW QUESTION 47
What are the two methods that could be used during the migration of your existing Oracle database to Autonomous Database? (Choose two.)
- A. Golden Gate
- B. CSV files copied to Autonomous Database block storage
- C. Recovery Manager (RMAN)
- D. Data Pump
Answer: A,D
Explanation:
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, database clones, and transportable tablespaces to move your existing database to ADB.
https://www.oracle.com/database/technologies/datawarehouse-bigdata/adb-faqs.html#MIGRATION
NEW QUESTION 48
Which two statements are FALSE about creating a metadata-only clone with a private endpoint network access option?
- A. Clone can be in a different region.
- B. All underlying data for OML notebooks is cloned.
- C. Current settings for ACLs are cloned.
- D. All OML notebooks are cloned.
- E. All resource management rules are cloned.
Answer: D,E
NEW QUESTION 49
Which two optimizations are different between Autonomous Data Warehouse and Autonomous Transaction Processing?
- A. Data Organization
- B. Backup Retention
- C. Undo Management
- D. Memory Usage
- E. Index Storage
Answer: A,E
NEW QUESTION 50
When you connect Oracle Analytics Cloud to the Autonomous Data Warehouse, what file needs to be uploaded?
- A. TNSNAMES.ORA
- B. SQLNET.ORA
- C. CWALLET.SSO
- D. OJDBC.PROPERTIES
Answer: C
Explanation:
Create the Autonomous Data Warehouse Connection in Oracle Analytics Cloud.
- Sign in to Oracle Analytics Cloud.
- On the Home page, click Connect to Oracle Autonomous Data Warehouse.
- In Create Connection, enter a Connection Name, for example, MyADW_connection.
- In Description, enter a brief description.
- Click Select next to Client Credentials. In File Upload, select the wallet zip file from your download location. The Client Credentials field is populated with cwallet.sso, and the Service Name field contains a value.
- Enter your Oracle Autonomous Data Warehouse Username and Password.
- From the Service list, select the service for your data, and then click Save.
https://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/oac_ee_dv/create_adwc_connection/html/index.html
NEW QUESTION 51
Which statement is false about Autonomous Database Oracle Client Credentials (Wallets)?
- A. The Wallet for the Autonomous Database is the same as the Transparent Data Encryption (TDE) wallet.
- B. The Oracle Client Credential file is downloaded as a ZIP file.
- C. You MUST have an Oracle Client Credential Wallet in order to connect to the Autonomous Database.
- D. In addition to the Oracle Client Credential Wallet, a user must have a username and password in order to connect to the Autonomous Database.
Answer: A
Explanation:
When you download the client credentials from the Download Wallet dialog, you must enter a wallet password in the password field and confirm the password in the confirm password field. The password must be at least eight characters long and must include at least one letter and one numeric character or one special character. This password protects the download client credentials wallet. This wallet is not the same as the transparent data encryption wallet for the database. Therefore, a different password is used to protect the client credentials wallet.
NEW QUESTION 52
Where can a user's public ssh key be added on the Oracle Cloud Infrastructure Console in order to execute API calls?
- A. Navigate to Identity, select Users panel on the console and select "Add Public Key".
- B. On the Autonomous Database Console.
- C. SSH keys cannot be added from console. They have to be added using REST APIs only.
- D. SSH keys are not required in Oracle Cloud Infrastructure.
Answer: A
Explanation:
- In the Console, click Identity, and then click Users. Locate the user in the list, and then click the user's name to view the details.
-Click Add Public Key.
- Paste the key's value into the window and click Add.
NEW QUESTION 53
A Corporation is building a web application to allow its customers to schedule service requests online.
There is also a need to run operational reports at times during non-peak hours. The architecture team is debating whether such reports should be run on the OLTP database or in a separate data mart. The DBA Manager does not want to add anymore admin responsibility to the team and is looking for a database option that's low to zero maintenance, but meets their strict performance requirements as well.
Which Oracle Cloud Infrastructure database service is appropriate for this scenario?
- A. ATP. Using 'tpurgent' and 'high' TNS services to separate connection types.
- B. Since the application needs to be highly available, it should to be deployed on a Kubernetes Cluster.
- C. It is best to build a separate data warehouse, and move the OLTP data on a nightly basis.
- D. ADW since operational reporting is a higher priority in this scenario.
Answer: A
Explanation:
Autonomous Transaction Processing provides all of the performance of the market leading Oracle Database in an environment that is tuned and optimized to meet the demands of a variety of applications, including: mission-critical transaction processing, mixed transactions and analytics, loT, and JSON document store.
As a service Autonomous Transaction Processing does not require database administration. With Autonomous Transaction Processing you do not need to configure or manage any hardware, or install any software. Autonomous Transaction Processing handles creating the database, backing up the database, patching and upgrading the database, and growing or shrinking the database.
NEW QUESTION 54
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?
(Choose three.)
- A. SQL Developer can import .csv files into ADB which are located on the system where SQL Developer is running.
- B. SQL Developer can only export/move/import files using datapump from databases running on Linux systems.
- C. SQL Developer can be used to export/move/import of a database to ADB in 1 set of wizard steps.
- D. SQL Developer can import files (.dmp and .csv for example) into ADB which are located on Amazon S3 Object storage.
Answer: A,B,C
NEW QUESTION 55
Which statement is true in regards to database links?
- A. Connect from Autonomous Database to remote database using a database link.
- B. You can call PL/SQL procedures and functions using a database link.
- C. Connect to Autonomous Database from remote database using a database link.
- D. Create a database link from one Autonomous Database to another Autonomous Database instance.
Answer: D
Explanation:
https://blogs.oracle.com/datawarehousing/making-database-links-from-adw-to-other-databases
NEW QUESTION 56
......
Master 2021 Latest The Questions Oracle Cloud and Pass 1Z0-931-20 Real Exam!: https://www.dumpstorrent.com/1Z0-931-20-exam-dumps-torrent.html