Exam Number: 1Z0-160
Exam Title: Oracle Database Cloud Service
Associated Certification Paths
Oracle Database Cloud Administrator Certified Professional
Oracle Database Cloud Service Operations Certified Associate
Oracle Database Cloud Administrator Certified Associate
Duration: 120 minutes
Number of Questions: 70
Passing Score: 63%
Validated Against:
Exam has been validated against Oracle Database as a Service Cloud v 12.1.0.3
Format: Multiple-Choice
Complete Recommended Training
Complete the training below to prepare for your exam (optional):
Database Cloud Channel
Oracle Database Cloud for Oracle DBAs Ed 3
Additional Preparation and Information
A combination of Oracle training and hands-on experience (attained via labs and/or field experience) provides the best preparation for passing the exam.
The 1Z0-160 – Oracle Database Cloud Service Certification exam validates concepts and skills covering the full Database product family and focuses on the Database Cloud Service (DBCS) only. It is primarily designed for On-Premise DBAs to add cloud expertise to their certification titles, and for operators that use DBCS to provision services. If you are looking for a certification that covers ALL of the services in the DB Cloud family, please see the Data Management CLS and exam 1Z0-950: Oracle Data Management Cloud Service 2018 Associate
The contents covered in this exam is based on OCI-C.
Creating Database Deployment
Fundamentals of Oracle Database Cloud Service
Identify the steps for creating a Database Deployment
Identify Database Deployment options and service levels.
Allocate the Oracle Cloud Service storage volumes when a Database Deployment instance is created
Multi-Tenant- Advantage and value proposition.
Database Deployment Administration
Use My Service Dashboard and Database Cloud Console
Administer users/privileges needs for the Oracle Cloud Service
Administer storage/disks requirements of the Oracle Cloud Service
Patch your Database Deployment
Differentiate between oracle and opc users
Configure SSH connections to compute node in Database Deployment
Database Deployment backup and restore utilities and options.
Database Deployment Connectivity and Security
Configure Security rules
User authentication and roles
Generate an SSH Public/Private key pair
Create an SSH tunnel to a port in the compute node
Enable access to DBaaS Monitor
Connect remotely to the Database Deployment database using SQL*Net
Administer Oracle REST Data Services (ORDS)
Enable access to Oracle Application Express (APEX)
Performance and Scaling
Identify Scaling issues for Compute and Storage.
Learn how to avoid and resolve Database Deployment performance issues.
QUESTION: No: 1
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 VNI and database instance from remote hosts by using SSH.
C. Contact the administrator of your company’s intra net 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 exampIe.com and you wanted to use clouddbl as the custom
host name for a compute node, you would request a DNS record that associates cIouddbI.exampIe.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-domainname.html
QUESTION: No: 2
With Oracle Database Cloud Service as the subscription type, you must configure a database for Backup and Recovery.
Which two options do you have to back up your database instance?
A. No backups required. You are responsible for configuring the database backups.
B. Backup to cloud storage and VIVI block storage. Ten days worth of backups are kept, with five most recent days worth of backups available directly on VIVI block storage.
C. Backup to Oracle Cloud Service storage volumes that is equal to five times the value that was provided in Usable Data Storage when the instance was created.
D. Backup to cloud storage and VIVI block storage. Fourteen days worth of backups are kept, with seven most recent days worth of backups available directly on VNI block storage.
Answer: A,C
Explanation:
When creating a new database deployment on Oracle Database Cloud Service, you choose whether you
want automatic backups to be configured for the database. Your choices are:
Both Cloud Storage and Local Storage-30 days’ worth of backups are kept, with the 7 most recent days’
worth available directly on the compute node’s local storage.
Cloud Storage Only-30 days’ worth of backups are kept, with all backups on cloud storage.
None-automatic backups are not configured.
References:
https://docs.oracIe.com/en/cloud/paas/database-dbaas-cloud/csdbi/db-depIoyments.htmI
QUESTION: No: 3
Users must be granted roles to manage Cloud services.
Which three statements are true about roles and role assignment in Database as a Service (DBaaS)?
A. Service administrators can assign and remove roles only for users of the services that they manage.
B. The DBaaS Database Administrator role permits granting the DBaaS Database Administrator or DBaaS Database Operator role to existing users.
C. Identity domain administrators can assign and remove roles for users in any identity domains.
D. The DBaaS Database Operator role permits the ability to scale, patch, and backup or restore service instances.
E. DBaaS network administrators can grant access privileges to designated users.
Answer: A,D,E
Explanation:
A: A Service administrator manages administrative functions related to Oracle Cloud services within an identity domain.
D: The privileges given to the DBaaS Database Administrator role include:
Can scale, patch, and back up or restore database deployments
QUESTION: No: 4
Which users are created and can be used for database and host management of your DBaaS database servers?
A. root, opc and oracle users
B. root, oracle and cloud users
C. root and oracle users
D. opc and oracle users
E. cloud and oracle users
Answer: D
Explanation:
Linux user accounts that are provisioned on an Oracle Database Cloud Service deployment that hosts an Oracle Real Application Clusters (Oracle RAC) database:
* ope
The system administrator account you use to connect to the compute node using SSH. This user can use the sudo command to perform operations that require root-user access.
* oracle
The Oracle Database administrator account you use to access the system and perform non-root database administration tasks.
* grid
The Oracle Grid Infrastructure administrator account you use to perform ASNI, ACFS, and cluster ware administration tasks.
* root
The root administrator for the system. You do not have direct access to this account. To perform
operations that require root-user access, use the sudo command as the ope user.
References:
https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/Iinux-user-accounts-rac.html
QUESTION: No: 5
Which two situations require that your Database as a Service (DBaaS) instance be scaled up?
A. The DBaaS instance is maxed out on semaphore sets.
B. The database instance has reached the limit in the Iicense_max_sessions database parameter.
C. The DBaaS instance is maxed out on CPU.
D. The database instance is out of space in the sysaux and system tablespaces.
E. The DBaaS instance is maxed out on storage.
F. The DBaaS instance is maxed out on semaphores.
Answer: C,E
Explanation:
Existing DBCS instances may scale up to bigger shapes in OCPU, IVIemory and Storage for vertical scaHng.
For horizontal scaling, DBCS provides RAC with the Extreme Performance option currently allowing applications to scale up to 2 nodes, each with a max of 160CPU shapes.
Note: An Oracle CPU (OCPU) provides CPU capacity equivalent of one physical core of an Intel Xeon processor with hyper threading enabled. Each OCPU corresponds to two hardware execution threads,
known as vCPUs.
References:
https://cloud.oracIe.com/opc/database/faq
Click here to view complete Q&A of 1Z0-160 exam
Certkingdom Review, Certkingdom PDF Torrents
Best Oracle 1Z0-160 Certification, Oracle 1Z0-160 Training at certkingdom.com