Oracle Oracle Certifications 1Z0-1072-22 Questions & Answers

• Question 71:

  Your on-premises hosted application uses Oracle database server. Your database administrator must have access to the database server for managing the application. Your database server is sized for seasonal peak workloads, which results in high licensing costs. You want to move your application to Oracle Cloud Infrastructure (OCI) to take advantage of CPU scaling options. Which database offering on OCI would you select?

  A. bare metal DB systems

  B. VM DB systems

  C. Autonomous Transactions Processing (ATP)

  D. Autonomous Data Warehouse (ADW)

  Correct Answer: A

  -In, Oracle Autonomous Database, Customers are not given OS logons or SYSDBA privileges to prevent phishing attacking.

  -If a bare metal DB system requires more compute node processing power, you can scale up (increase) the number of enabled CPU cores in the system without impacting the availability of that system. You cannot change the number of CPU cores for a virtual machine DB system in the same way as metal DB system. Instead, you must change the shape to one with a different number of OCPUs Changing the shape does not impact the amount of storage available to the DB system. However, the new shape can have different memory and network bandwidth characteristics, and you might need to reapply any customizations to these aspects after the change.

• Question 72:

  Which service would you use if your big data workload required shared access and NFS-based connectivity?

  A. block volume

  B. archive storage

  C. object storage

  D. file storage

  Correct Answer: D

• Question 73:

  Your company is developing a new database application in Oracle Cloud Infrastructure. You need to test application functionality including a hardware failure scenario. Since the application is still in the development phase, you want to minimize infrastructure costs. Which database service deployment option meets this requirement?

  A. two node real application cluster (RAC) system

  B. Autonomous Data Warehouse (ADW) system as it provides auto fail over functionality

  C. two node bare metal system with data guard enabled

  D. single node bare metal system

  Correct Answer: A

• Question 74:

  A customer has established an Oracle Cloud Infrastructure (OCI) FastConnect connection to OCI. The virtual circuit is up and routes are being advertised from the customer's end, however the customer is unable to ping from compute instances inside the virtual cloud network (VCN) to servers residing in its on-premises data center. Which two options on OCI would remedy this situation? (Choose two.)

  A. Modify the route table associated with the VCN subnet in which the instance resides. Add a route to the customer's on-premises network via the Dynamic Routing Gateway (DRG).

  B. Modify the security list associated with the VCN subnet in which the instance resides. Add a stateful egress rule to allow ICMP traffic to the customer's on-premises network.

  C. Modify the security list associated with the VCN subnet in which the instance resides. Add a stateful ingress rule to allow ICMP traffic from anywhere.

  D. Modify the default VCN route table to add a route back to the customer's on-premises network via the DRG.

  Correct Answer: AB

• Question 75:

  Where do you find the tnsnames.ora for your Autonomous Data Warehouse (ADW) database?

  A. You can download tnsnames.ora from Oracle Cloud Infrastructure web console under ADW details page

  B. The tnsnames.ora file is included in credentials.zip file that you download from service console of ADW

  C. The ADW database will place the tnsnames.ora file in an object storage bucket

  D. You are automatically prompted to download the tnsnames.ora file upon creation of the ADW database

  Correct Answer: B

  https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/connectintorduction.html#GUID-CD4C10A6-1C1E-4969-8F67-1433B6CE626A To download client credentials from the Autonomous Transaction Processing Service Console:

  -From the Service Console click the Administration link.

  -Click Download Client Credentials (Wallet).

  -On the Download Client Credentials (Wallet) page, enter a wallet password in the Password field and

  confirm the password in the Confirm Password field. The password must be at least 8 characters long and

  must include at least 1 letter and either 1 numeric character or 1 special character. This password protects

  the downloaded Client Credentials wallet.

  -Click Download to save the client security credentials zip file. By default the filename is:

  Wallet_databasename.zip. You can save this file as any filename you want. You must protect this file to

  prevent unauthorized database access.

  The zip file includes the following:

  tnsnames.ora and sqlnet.ora: Network configuration files storing connect descriptors and SQL*Net client

  side configuration.

  cwallet.sso and ewallet.p12: Auto-open SSO wallet and PKCS12 file. PKCS12 file is protected by the

  wallet password provided in the UI.

  keystore.jks and truststore.jks: Java keystore and truststore files. They are protected by the wallet

  password provided while downloading the wallet.

  ojdbc.properties: Contains the wallet related connection property required for JDBC connection. This

  should be in the same path as tnsnames.ora.

• Question 76:

  You are planning to deploy a multi-region web application in Oracle Cloud Infrastructure (OCI). You have customers in North America, Asia and Europe who will access the application. What service is available in OCI to help you choose the regions the lowest latency to these markets?

  A. Internet Intelligence

  B. FastConnect

  C. IPsec VPN

  D. DNS Zone Management

  Correct Answer: A

• Question 77:

  Which two options are valid for loading data directly into Autonomous Data Warehouse (ADW)? (Choose two.)

  A. Data Integrator

  B. Data Pump

  C. Data Transfer Service

  D. SQL *Loader

  Correct Answer: BD

• Question 78:

  You have just created an Autonomous Data Warehouse (ADW) and you want to connect to the ADW using

  SQL Developer.

  What three items are needed to connect to the ADW using SQL Developer? (Choose three.)

  A. the keystore password

  B. a security list with an ingress rule for TCP port 1521

  C. the client credentials file

  D. the public IP address of the ADW server

  E. the admin password

  Correct Answer: ACE

  https://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/adwc/OBE_Provisioning_Auto nomous_Data_Warehouse_Cloud_bak/provisioning_autonomous_data_warehouse_cloud.html

• Question 79:

  You are deploying a highly available web application in Oracle Cloud Infrastructure and have decided to

  use a public load balancer. The back-end web servers will be distributed across all three availability

  domains (ADs).

  How many subnets should you create to deliver a secure highly available application?

  A. three subnets in total; one subnet in each AD

  B. five subnets in total; two subnets each in the first and second AD with a single subnet in the third AD

  C. six subnets in total; two subnets in each AD; one for the load balancer and one for the web servers

  D. four subnets in total; one subnet in each AD for the web servers and a single subnet in any one AD for the load balancer

  Correct Answer: C

• Question 80:

  You are about to deploy an e-business application on Oracle Cloud Infrastructure and one of the

  requirements is to use a shared file system that supports the NFS protocol.

  Which storage service would meet this requirement?

  A. object storage

  B. block volume

  C. data transfer appliance

  D. file storage

  Correct Answer: D

  Use the File Storage service when your application or workload includes big data and analytics, media processing, or content management, and you require Portable Operating System Interface (POSIX)compliant file system access semantics and concurrently accessible storage. The File Storage service is designed to meet the needs of applications and users that need an enterprise file system across a wide range of use cases, including the following: General Purpose File Storage: Access to an unlimited pool of file systems to manage growth of structured and unstructured data. Big Data and Analytics: Run analytic workloads and use shared file systems to store persistent data. Lift and Shift of Enterprise Applications: Migrate existing Oracle applications that need NFS storage, such as Oracle E-Business Suite and PeopleSoft. Databases and Transactional Applications: Run test and development workloads with Oracle, MySQL, or other databases. Backups, Business Continuity, and Disaster Recovery: Host a secondary copy of relevant file systems from on premises to the cloud for backup and disaster recovery purposes. MicroServices and Docker: Deliver stateful persistence for containers. Easily scale as your container- based environments grow.