1z0-160 | All About Exact 1z0-160 examcollection
Q21. You want to make sure that your database administrators have a convenient way to monitor your DBaaS instance. To do so, you need to enable the Oracle DBaaS Monitor.
How would you enable the Oracle DBaaS Monitor?
A. Use theenable_dbaas_monitorcommand.
B. Create an SSH tunnel to port 443.
C. Disable theora_p2_httpsslsecurity rule in Oracle Compute Cloud Service Console.
D. Use the Oracle GlassFish Server Administration Console.
E. Add ODBM access to each DBA’s user profile.
Answer: B
Explanation:
To access Oracle DBaaS Monitor when the HTTPS port is blocked, you must create an SSH tunnel to port 443 on the compute node hosting the DBaaS Monitor.
Note:How you access Oracle DBaaS Monitor depends on whether the HTTPS port (443) hasbeen unblocked. When a Database Cloud Service deployment is first created, theHTTPS port is blocked to ensure network security
Q22. You want all your colleagues to be able to access the compute node associated with an
Oracle Database Cloud – Database as a Service (DBaaS) instance. You want them to do so by using a custom host name rather than an IP address regardless of the client machine (personal or provided by the company) that they use for the access.
How would you enable this access?
A. Configure the Advanced Security Option (ASO).
B. Enable secure access to the DBaaS instance VM and database instance from remote hosts by using SSH.
C. Contact the administrator of your company’s intranet DNS and request a custom DNS record for the compute node’s public IP address.
D. Edit the machine’s/etc/hostsfile.
E. Resolve your domain name to the IP address of the DBaaS compute node by using the third-party domain registration vendor console.
Answer: C
Explanation:
You can associate a custom host name or domain name to the public IP address of a compute node associated with your Oracle Database Cloud Service environment.
To associate a custom host name to the public IP address of a compute node, contact the administrator of your DNS (Domain Name Service) and request a custom DNS record for the compute node’s public IP address. For example, if your domain is example.com and you wanted to use clouddb1 as the custom host name for a compute node, you would request a DNS record that associates clouddb1.example.com to your compute node's public IP address.
References:https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/define-custom-host-or-domain-name.html
Q23. Which three will be supported after migrating an on-premises database to a Database as a Service (DBaaS) instance on Oracle Cloud?
A. increased security of application roles
B. reduction in operational costs
C. ability to increase capacity on demand
D. provisioning of application testing
E. centralization of database management
Answer: C,D,E
Explanation:
References:https://www.oracle.com/database/solutions/private-dbaas.html
Q24. You get complaints from users of several different applications that performance has degraded over time.
These applications run in this configuration:
A check of wait events for the sessions belonging to these applications shows that the sessions are waiting longer and that there are more sessions from other applications in the same database instance.
You wish to avoid scaling up your Database as a Service (DBaaS) instance in Oracle Cloud.
Which four should you check and possibly reconfigure to avoid the need to scale up the DBaaS instance?
A. Modify the users that are using each application so that their sessions are associated with the correct consumer group in the PDB that is hosting their application.
B. Check the CDB plan to configure the shares allocated to all PDBs, including the PDBs that containthe two poorly performing applications.
C. Check the CDB plan only to configure the shares allocated to the PDBs that contain the two poorly performing applications.
D. Create separate consumer groups for the sessions for all applications in the PDB plansfor the PDBs that are hosting the two poorly performing applications.
E. Check the PDB plan for all the PDBs in the CDB, including the PDB that is hosting the two poorly performing applications.
F. Create a PDB plan for each PDB in the CDB that has poorlyperforming applications.
G. Create a separate CDB plan for each PDB that has poorly performing applications.
Answer: A,B,D,F
Q25. You did not configure Backup and Recovery during instance creation. You therefore need to schedule your backup strategy with RMAN.
Which two tasks would you need to perform to customize the backup configuration?
A. Use thebkup_apiutility logged in as theoracleuser to reconfigure the retention period and cycle period of the backups.
B. Edit the/home/oracle/bkup/oscfg.specspecification file that is used by the DBaaS backup feature to maintain the list of system files and folders that are to be backed up.
C. Edit the/home/oracle/bkup/dbcfg.specspecification file that is used by the DBaaSbackup feature to maintain the list of database configuration files that are to be backed up.
D. Usedbms_schedulerto perform automatic backups.
Answer: A,C
Explanation:
A:You can use the bkup_api utility to create an on-demand backup of a database deployment hostinga single-instance database or an Oracle Data Guard configuration.
By default, the backup is given a timestamp-based tag. To specify a custom backup tag, add the --tag option to the bkup_api command; for example, to create a longterm backup with the tag "monthly", enter the following command:
# /var/opt/oracle/bkup_api/bkup_api bkup_start --keep --tag=monthly
C.Customizing Which Database Configuration Files Are Backed Up To change which database configuration files are backed up:
References: Using Oracle Database Cloud Service (February 2021) , pages 6-4, 6-10 https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/using-oracle-database-cloud-service.pdf
Q26. Where is the Oracle Database Cloud software for monitoring and backup installed?
A. The Oracle Database Cloud software is located in the Database Automatic Diagnostic Repository (ADR).
B. The installation is done at/var/opt/oracle/dbaascliand/var/opt/oracle/bkup_api.
C. The location must be set during installation as user-defined locations for the installation to start.
D. The location is based on Oracle Flex Architecture, which is similar to non-DBaaS systems.
Answer: B
Explanation:
When a database deployment is created using the Oracle Database Cloud Serviceservice level, software is installed in the following locations.
* bkup_api utility /var/opt/oracle/bkup_api
* dbaascli utility /var/opt/oracle/dbaascli
* Oracle RESTData Services /u01/app/oracle/product/apex_listener
* Oracle Database
$ORACLE_HOME:
Note: Using the dbaascli utility, you can performoperations like:
References: Using Oracle Database Cloud Service (February 2021), A-4 https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/using-oracle-database-cloud-service.pdf
Q27. Which three statements are true about the service levels provided by Database as a Service (DBaaS)?
A. The Virtual Image service level provides a pre-created database.
B. The Virtual Image service level provides tools for backupsand patching.
C. The automated service provides a pre-installed virtual machine image.
D. The automated service provides a pre-created database.
E. The cloud tooling within the automated service level provides a tool for point-in-time database recovery.
Answer: B,D,E
Q28. How do you access “none default ports” on your DBaaS VM server?
A. Review a file calledportlist.iniin your installation directory to acquire the list of “none default ports” that are assigned to your VM server.
B. You file a service request with your DBaaS support team to have the “none default ports” opened for use.
C. You create an SSH tunnel to the “none default port”.
D. All communication to DBaaS services must be configured only by using the default ports that are assigned to your VM server during the installation of yourDBaaS instances.
Answer: B
Explanation:
To enable access to a compute node port, you enable the appropriate security rule.When you enable one of the predefined security rules, the given port on the computenode is opened to the public internet. To enable access to a different port, or restrictaccess to a port, you must create a security rule.
Note:When a database deployment is created, the following Oracle Compute Cloud
Servicesecurity rules are created, but set to a disabled status.
References: References: Using Oracle Database Cloud Service (February 2021), page 3-7 https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/using-oracle-database-cloud-service.pdf
Q29. You are using access rules to control network traffic among your DBaaS instances. Which statement is true about access rules?
A. They are used only for configuring external server access to DBaaS and do not impact how network groups communicate.
B. They define a specific communication path, which consists of a source, destination, and protocol-port combination overwhich communication is allowed.
C. They are used to map an external user to a database user to allow the user to communicate with and access the database.
D. They are used to encrypt communication between DBaaS instances.
Answer: B
Explanation:
On the Access Rule youcan define the following:
References:https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/service-console-access-rules-page.html
Q30. How would you enable a port persistently to keep communication open through that port always?
A. To enable a port persistently, you must contact your DBaaS support team to update the port specifications for use.
B. You can use server certificates to map a server’s identity to enable persistent connection through a port to DBaaS instances.
C. All ports that are available in DBaaS servers must use an SSH tunnel and cannot be enabled persistently.
D. To enable a port persistently, you would require access to the Compute Cloud Service Console to open the ports to a set of IP addresses.
Answer: A