1z0-915-1 by Oracle Valid Free Exam Practice Test

Question 1

You have obtained a new tenancy on Oracle Cloud Infrastructure. You first create a VCN by using the VCN Wizard, and then create a MySQL DB system. You want to create a Connection in Database tools to use the SQL Worksheet feature.
Which three steps are required? (Choose three.)

A. Import an X.509 certificate into the OCI vault. B. Create an OCI vault. C. Create an OCI secret. D. Create an encryption key. E. Create an OCI password.

Correct Answer: A,C,E

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 2

Which placement is NOT valid for a high-availability DB system? (Note: AD refers to availability domain and FD refers to fault domain.)

A. Primary instance: AD1-FD1; Secondary instance 1: AD1-FD2; Secondary instance 2: AD1-FD3 B. Primary instance: AD1-FD3; Secondary instance 1: AD1-FD2; Secondary instance 2: AD1-FD3 C. Primary instance: AD1-FD3; Secondary instance 1: AD2-FD2; Secondary instance 2: AD3-FD3 D. Primary instance: AD1-FD1; Secondary instance 1: AD2-FD2; Secondary instance 2: AD3-FD3

Correct Answer: B

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 3

Why would you select "Source cannot use GTID auto-positioning" when creating a channel?

A. The source gtid mode is OFF. B. The target DB system is a high-availability DB system. C. Some tables have no primary key D. The binary log offset is unknown.

Correct Answer: A

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 4

Which two are true about creating a new DB system with data import? (Choose two.)

A. A valid pre-authenticated request must be provided to access the data. B. The files containing the data must be uploaded through OCI Console on the "Create DB system" page. C. The data must be created with the mysqldump client utility. D. The data must be created with MySQL Enterprise Backup. E. The data must be stored in an Object Storage bucket in the same OCI region as the new DB system.

Correct Answer: A,E

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 5

Which three are features of MySQL AutoPilot? (Choose three.)

A. AutoML B. Auto thread pooling C. Auto encoding D. Auto provisioning E. Auto backup

Correct Answer: A,C,D

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 6

A port-forwarding Bastion session has been created for a MySQL DB system listening on 10.10.1.187:3306.
The SSH command provided by the Bastion session is:

An SSH tunnel is created successfully on a client machine by running this command:

Which command connects to the MySQL DB System from the client machine?

A. mysqlsh mysql://[email protected]:3311 B. mysqlsh mysql://[email protected]:3306 C. mysqlsh mysql://[email protected]:3311 D. mysqlsh mysql://[email protected]:3306

Correct Answer: A

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 7

You want to replicate data from an on-premises MySQL server to a MySQL DB system. The on-premises MySQL server runs in your corporate network. The MySQL server accepts incoming connections from the Internet on a public IP endpoint.
The DB system runs in Oracle Cloud Infrastructure. The DB system endpoint is connected to a privatesubnet of a VCN.
Which network configuration is required?

A. Create a service gateway in the VCN and configure the DB system subnet to route Internet-bound traffic to the service gateway. B. Create a NAT gateway in the VCN and configure the DB system subnet to route Internet-bound traffic to the NAT gateway. C. Create an Internet gateway in the VCN and configure the DB system subnet to route Internet-bound traffic to the Internet gateway. D. Configure an OCI network load balancer to accept incoming connections on a public IP and route to the DB system private IP address.

Correct Answer: B

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Oracle MySQL HeatWave Implementation Associate Rel 1 - 1z0-915-1 Exam Practice Test