1z0-950: Oracle Cloud Platform Data Management 2018 Associate

You want to define an Oracle SQL Developer connection to your Database Cloud Service database. Due to security requirements in your company, you must define an SSH connection in Oracle SQL Developer.

Which two values do you need to provide as part of the SSH connection definition? (Choose two.)

The public SSH key file for your database deployment.
The private SSH key file for your database deployment.
The port number of the listener on your database deployment.
The name of the pre-created security rule for the listener.
The IP address of the compute node hosting your Database Cloud Service database.

Correct answer: BC

Explanation:

Reference: https://blogs.oracle.com/dbaas/connecting-to-a-database-cloud-service-with-sql-developer-and-ssh

Your customer is planning to run both 12.1 and 12.2 databases on their Exadata Cloud Service. They have provisioned an instance and it is your responsibility to create the database deployments.

Which two statements are true? (Choose two.)

If you create the 12.1 database deployment first, you will not be able to create a 12.2 deployment.
You should always create the highest expected database deployment first.
It does not matter in which order you create the database deployments.
You can have multiple grid infrastructure versions running on the Exadata Cloud Service instance.
If you create the 12.1 database deployment first, and then the 12.2 deployment, the Oracle Grid Infrastructure will be automatically upgraded to 12.2.
A single SSH key pair can be used for both database deployments.

Correct answer: BD

Your newly created MySQL Cloud Service is not available from your application. Select the two correct options that apply. (Choose two.)

The MySQL instance is still in the “Creation” process.
The ‘opc’ user can be used to access MySQL only with the created SSH-Key.
You forgot to create the correct SSL/TLC certificate during the setup process.
Only ‘root’ is allowed to access from non-localhost.
You forgot to enable port 3306.

Correct answer: AE

An important client that you’ve recently begun working with is interested in moving some of their on-premises databases into the cloud. How do they determine the correct instance size for their initial deployment?

You should advise your customer to select the largest shape with lots of OCPUs and a high memory count. They can run their database on the larger shape and monitor it to determine the optimum values and then downsize when they’re sure they’ve got it right.
The client should consider the nature of their applications, number of users, and future load scale and select a shape that meets those requirements with a buffer for load spikes. A good starting point could be one that closely matches their on-premises hardware.
The only reason to move to the cloud is if the customer’s on-premises hardware is older and running out of gas. Since the Oracle Database Cloud runs on the latest Intel chips and the fastest available memory, they can safely provision with less than 10% of their current on-premises hardware capacity and be sure that their database will run at its fastest.
The client should carefully consider the nature of their applications, number of users, and run tests to try and predict their future workload size. They should then select a shape that will comfortably run their workload for the next few years because once they’ve selected a shape and instance size the only way to change is to delete the instance and redeploy.
Since they’re moving on-premises databases to the cloud, they’ll obviously want to utilize high memory shapes because everyone can use more memory and that’s the best platform for the future.

Correct answer: B

Your company has purchased a Quarter Rack X6 Exadata Service. The service instance has been created. You are required to provision an 11.2.0.4 database service.

Which two statements are true? (Choose two.)

You can choose a single instance database if required.
When the database is created, a new VM will be created to host it.
The Oracle Software Edition is automatically set to High Performance.
The standard billing frequency is hourly but you can choose monthly if required.
If the Both Cloud Storage and Exadata Storage option is not available, it is because this was not chosen during the provisioning of the Exadata cloud service instance.
When the database is created a new Oracle Home will be provisioned.

Correct answer: DE

When deploying Oracle Database products in the Oracle Database cloud, what is the division of security between the customer and Oracle?

In the public cloud model, Oracle is responsible for maintaining all credentials, ssh keys, and customer employee accounts and all activities that occur under those accounts.
The customer is responsible for the entire stack from the underlying cloud infrastructure to identity, networking, and operating system rules and configuration.
Oracle Cloud platform services operate under a shared responsibility model where Oracle is responsible for the underlying cloud infrastructure and the customer is responsible for securing their own workloads under the Oracle Database Cloud.
Oracle is completely responsible for all levels from the underlying cloud infrastructure to identity, networking, and operating system rules and configuration.
Oracle is responsible for Data Security while the customer is responsible for the database, Java, and other infrastructure services.

Correct answer: C

You are required to encrypt the backups you are making to the Oracle Database Backup Cloud Service.

Which two statements are correct? (Choose two.)

Backups can only be encrypted using password-based encryption.
The credentials used to connect to the storage cloud service are used to encrypt the backups.
When restoring a backup that was encrypted with Transparent Data Encryption you issue the RMAN command SET ENCRYPTION ON before restoring the database.
Transparent Data Encryption for backup encryption, you issue the RMAN command SET ENCRYPTION ON IDENTIFIED BY ‘mypwd’ before backing up the database.
When using Transparent Data Encryption for backup encryption, you issue the RMAN command SET ENCRYPTION ON IDENTIFIED BY ‘mypwd’ before backing up the database.
When restoring a backup that was encrypted with password-based encryption you issue the RMAN command SET ENCRYPTION ON IDENTIFIED BY ‘mypwd’ before restoring the database.

Correct answer: BC

Explanation:

Reference: https://docs.oracle.com/en/cloud/paas/db-backup-cloud/csdbb/backing-oracle-database-backup-cloud-service-using-transparent-data-encryption-tde.html#GUID-CF813DCB-EF00-4FCB-9C6F-B67E2269F05C

Your customer is beginning to make heavy use of their Oracle Database Cloud instances and they’re transferring a lot of data using Data Pump, RMAN, and SQL Developer Carts. They are concerned because their data movement jobs are taking a long time to complete.

What would you suggest to alleviate this problem? (Choose two.)

The customer can use the Oracle ZFS Appliance to bulk load data on a weekly basis. They can load their data on the appliance and then ship it to the Oracle cloud facility to have the data loaded manually.
Add all of the network performance optimization parameters to init.ora on each database and set them to TRUE.
Turn off SSH tunneling and transfer data in the clear because SSH is what’s slowing down the process.
The customer should implement an FTP Server. They can export the database data, upload it to the FTP server, and then import the data into the cloud database instances.
Suggest they upgrade to a better network connection. Oracle FastConnect VPN can provide a private, high bandwidth connection between the customer data center and the Oracle cloud offering more predictable network performance.

Correct answer: DE

You need to create a Database Cloud Service instance for a customer who wishes to have a database with disaster recovery. Which two statements are correct? (Choose two.)

To configure this across two data centers, the customer will need two identity domains.
Database Cloud Service Extreme Performance Edition and RAC are a requirement for this configuration.
Only Database Cloud Service Standard Edition cannot be used in this configuration.
If the customer needs to be able to open the disaster recovery database for queries during recovery, you will need to choose Database Cloud Service Extreme Performance for the software edition.
Only monthly billing is available in this configuration.

Correct answer: CD

Your customer has generated their SSH private and public key pairs. What’s the first thing you should instruct them to do before they access their cloud environments?

Advise your customer to generate another set of public and private keys to use as backups in case they lose the first set.
Advise your customer to create an encrypted backup copy of the public SSH keys and don’t let anyone have access.
Destroy the private key file to prevent any potential malicious access to their cloud environment.
Distribute the private keys to the LOB managers for safe keeping.
Advise your customer to create an encrypted backup copy of the private SSH keys and keep them secure.

Correct answer: E

Vendor:	Oracle
Exam Code:	1z0-950
Exam Name:	Oracle Cloud Platform Data Management 2018 Associate
Date:	Aug 20, 2018
File Size:	36 KB

Download Oracle Cloud Platform Data Management 2018 Associate.1z0-950.Pass4Sure.2018-08-20.42q.vcex

How to open VCEX files?

Demo Questions

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

ProfExam at a 20% markdown