Oracle 1Z0-1072 Online Practice Questions and Exam Preparation

Oracle 1Z0-1072 Online Questions & Answers

• Question 101:

  Which two tools would you use to manage Database Cloud Service (DBCS)? (Choose two.)

  A. psql
  B. Oracle Swingbench
  C. SQL Developer
  D. Oracle Enterprise Manager
  C. SQL Developer
  D. Oracle Enterprise Manager

• Question 102:

  You are an administrator with an application running in Oracle Cloud Infrastructure (OCI). The company has a fleet of OCI compute virtual instances behind an load balancer. The load balancer backend set health check API is providing a 'Critical' level warning. You have confirmed that your application Is running healthy on the backend servers. What Is the possible reason for this 'Critical' warning?

  A. The load balancer listener is not configured correctly.
  B. The security list associated with the subnet In which the backend server is provisioned does not include the IP range for the source of the health check requests.
  C. A user does not have correct Identity and Access Management (IAM) credentials on the backend servers.
  D. The route table associated with the subnet in which the backend server is provisioned does not include the route for the OCI load balancer.
  B. The security list associated with the subnet In which the backend server is provisioned does not include the IP range for the source of the health check requests.

• Question 103:

  You have two NFS clients running in two different subnets within the same Oracle Cloud Infrastructure (OCI) Virtual Cloud Network (VCN). You have created a shared file system for the two NFS clients who want to connect to the same file system, but you want to restrict one of the clients to have READ access while the other has READ/Write access. Which OCr feature would you leverage to meet this requirement?

  A. Use VCN security rules to control access for the NFS clients
  B. B. Use OCI Identity Access Management to control access for the NFS clients
  C. C. Use File Storage NFS Export Options to control access for the NFS clients
  D. Use NFS security to control access for the NES clients
  C. C. Use File Storage NFS Export Options to control access for the NFS clients

  ---

  Oracle Cloud Infrastructure File Storage service provides a durable, scalable, secure, enterprise-grade network file system. You can connect to a File Storage service file system from any bare metal, virtual machine, or container instance in your Virtual Cloud Network (VCN). You can also access a file system from outside the VCN using Oracle Cloud Infrastructure FastConnect and Internet Protocol security (IPSec) virtual private network (VPN).

  EXPORT

  Exports control how NFS clients access file systems when they connect to a mount target. File systems are exported (made available) through mount targets. Each mount target maintains an export set which contains one or many exports. A

  file system must have at least one export in one mount target in order for instances to mount the file system. The information used by an export includes the file system OCID, mount target OCID, export set OCID, export path, and client export

  options. For more information, see Managing Mount Targets.

  EXPORT SET

  Collection of one or more exports that control what file systems the mount target exports using NFSv3 protocol and how those file systems are found using the NFS mount protocol. Each mount target has an export set. Each file system

  associated with the mount target has at least one export in the export set.

  EXPORT PATH

  A path that is specified when an export is created. It uniquely identifies the file system within the mount target, letting you associate up to 100 file systems to a single mount target. This path is unrelated to any path within the file system itself,

  or the client mount point path.

  EXPORT OPTIONS

  NFS export options are a set of parameters within the export that specify the level of access granted to NFS clients when they connect to a mount target. An NFS export options entry within an export defines access for a single IP address or

  CIDR block range. For more information, see Working with NFS Export Options.

• Question 104:

  You have a shared file system between two web servers using File Storage Service (FSS) and you were tasked to create a backup plan for this environment to protect the data placed into the shared file system. What is the recommended approach to create this backup using FSS features?

  A. Implement a backup policy to execute a snapshot of the shared volume.
  B. Implement a backup policy to copy data from the shared volume to object storage.
  C. Compress the data that is in the shared volume and copy it into a different folder on the boot volume disk.
  D. Use the rsync tool to send data from the shared volume to a boot volume disk.
  E. Use the rsync tool to send data from the shared volume to a block volume.
  A. Implement a backup policy to execute a snapshot of the shared volume.

• Question 105:

  Where is the tenancy Oracle Cloud Identifier (OCID) located?

  A. given by support on account creation
  B. at the bottom of every console page
  C. on the Identity ?Users page
  D. contained within the compartment OCID
  D. contained within the compartment OCID

  ---

  Identity > Compartments >(The root Compartment of the tenancy)

• Question 106:

  You are running your warehouse using Autonomous Data Warehouse (ADW) service and you noticed that a newly configured batch job is always running in serial even through nothing else is running in the database. All your jobs are configured to run with parallelism enabled.

  What could be the reason for this batch job to run in serial?

  A. The batch job depends on only one table and parallelism cannot be enabled on single-table queries.
  B. The parallelism of batch job depends on the number of ADW databases involved in the query.
  C. The new batch job is connected to LOW consumer group.
  D. The new batch job runs on database tables that are not enable for parallel execution.
  E. Parallelism on the database is controlled by the application, not the database.
  C. The new batch job is connected to LOW consumer group.

• Question 107:

  Which two are required to create an IPSec VPN connection? (Choose two.)

  A. security list
  B. static route CIDR
  C. name
  D. compute instance
  A. security list
  B. static route CIDR

• Question 108:

  Which two options are available within the service console of Autonomous Transaction Processing?

  A. Monitor the health of the database server including CPU, memory and query performance
  B. Configure resource management rules and reset the admin password
  C. Perform a manual backup of the ATP database
  D. D. Fine tune a long running query using optimizer hints
  A. Monitor the health of the database server including CPU, memory and query performance
  B. Configure resource management rules and reset the admin password

• Question 109:

  Which two statements define the types of DNS resolvers that exist? (Choose two.)

  A. A custom resolver allows instances to use the host names of the hosts in your on-prem network that are connected to your VCN by an IPSec VPN connection.
  B. A VCN resolver allows instances to use the host names of the hosts in your on-prem network that are connected to your VCN by an IPSec VPN connection.
  C. A VCN resolver allows instances to use host names to communicate with instances on other VCNs in your tenancy.
  D. An Internet resolver allows instances to use the host names that are published on the Internet.
  A. A custom resolver allows instances to use the host names of the hosts in your on-prem network that are connected to your VCN by an IPSec VPN connection.
  D. An Internet resolver allows instances to use the host names that are published on the Internet.

  ---

  https://docs.cloud.oracle.com/iaas/Content/Network/Concepts/dns.htm

  This is an Oracle-provided option that includes two parts:Internet Resolver: Lets instances resolve hostnames that are publicly published on the internet. The instances do not need to have internet access by way of either an internet gateway

  or a connection to your on-premises network (such as an IPSec VPN connection through a DRG ).VCN Resolver: Lets instances resolve hostnames (which you can assign) of other instances in the same VCN. For more information, see

  About the DNS Domains and Hostnames.By default, new VCNs you create use the Internet and VCN Resolver. If you're using the Networking API, this choice refers to the VcnLocalPlusInternet enum in the DhcpDnsOption object.

  The Internet and VCN Resolver does not let instances resolve the hostnames of hosts in your on-premises network connected to your VCN by IPSec VPN connection or FastConnect. Use your own custom DNS resolver to enable that.

  https://docs.cloud.oracle.com/iaas/Content/Network/Concepts/dns.htm?Highlight=DNS%20resolver#About

• Question 110:

  You have deployed a compute instance (VM.Standard2.24) to run an Oracle database. With this set up, you run into some performance issues and want to leverage an OCI Dense IO shape (VM.DenseIO2.24), with which you get 25.6 TB local NVMe SSD. You do not want to lose the configuration changes you made to the instance. Which of the following TWO steps ARE NOT required to make this transition?

  A. Terminate the VM.Standard2.24 instance and do not preserve the boot volume
  B. B. Create a new instance using the VM.Dense102.24 shape using the preserved boot volume and move the Oracle Database data to NVMe disks
  C. C. Terminate the VM.Standard2.24 instance and preserve the boot volume
  D. D. Create a new instance using a VM.DenseIO2.24 shape using the preserved boot volume and move the Oracle Database data to block volumes
  A. Terminate the VM.Standard2.24 instance and do not preserve the boot volume
  D. D. Create a new instance using a VM.DenseIO2.24 shape using the preserved boot volume and move the Oracle Database data to block volumes

  ---

  You can permanently terminate (delete) instances that you no longer need. Any attached VNICs and volumes are automatically detached when the instance terminates. Eventually, the instance's public and private IP addresses are released and become available for other instances. By default, the instance's boot volume is deleted when you terminate the instance, however you can preserve the boot volume associated with the instance, so that you can attach it to a different instance as a data volume, or use it to launch a new instance.

  Dense I/O Shapes Designed for large databases, big data workloads, and applications that require high-performance local storage. DenseIO shapes include locally-attached NVMe-based SSDs.

  so once you create the VM.DenseIO you need to moce the Database to locally-attached NVMe-based SSDs