Validate your Skills with Updated 1z0-915-1 Exam Questions & Answers and Test Engine [Q15-Q29]

Rate this post

Validate your Skills with Updated 1z0-915-1 Exam Questions & Answers and Test Engine

Tested & Approved 1z0-915-1 Study Materials Download Free Updated 67 Questions

QUESTION 15
You want to create a second user called admin2 with the same privileges as the administrator specified when creating the DB system.
Which statement helps you achieve this?

CREATE USER admin2 IDENTIFIED BY ‘Password’ DEFAULT ROLE ‘administrator’;

CREATE USER admin2 IDENTIFIED BY ‘Password’; GRANT SUPER ON *.* TO admin2 WITH GRANT OPTION;

CREATE USER admin2 IDENTIFIED BY ‘Password’; GRANT AUDIT_ADMIN,
BACKUP_ADMIN, SESSION_VARIABLES_ADMIN ON *.* TO admin2 WITH GRANT OPTION;

CREATE USER admin2 IDENTIFIED BY ‘Password’; GRANT ALL PRIVILEGES ON *.* TO admin2 WITH GRANT OPTION;

QUESTION 16
Which is true about dynamic variables in MySQL HeatWave configurations?

Initialization variables are not dynamic.

Changes in dynamic variables require a server restart.

Dynamic variables in a custom configuration can be changed without copying the configuration to a new configuration.

All user variables are dynamic.

QUESTION 17
Automatic backup retention of a DB system is disabled. Which operation deletes all automatic backups of the DB system?

Enabling point-in-time recovery

Disabling delete protection

Deleting the DB system

Disabling point-in-time recovery

QUESTION 18
Which sequence of steps must you perform to change the configuration of a high-availability DB system?

Disable high availability, edit the DB system, change the configuration, and enable high availability.

Stop the DB system, edit the DB system, change the configuration, and start the DB system.

Edit and change the configuration of all secondary instances, switch over to a secondary instance, andedit and change the configuration of the former primary instance.

Edit the DB system and change the configuration.

QUESTION 19
Which three operations can be performed on a MySQL HeatWave backup? (Choose three.)

Delete an active manual backup when point-in-time recovery is enabled on the DB system.

Change the retention period of an active manual backup.

Restore an active backup to a new DB system in another region.

Change the retention period of an active automatic backup.

Move an active backup to another compartment.

QUESTION 20
Which operation is necessary before enabling a MySQL HeatWave cluster?

Start Cloud Shell in OCI Console connected to the DB system’s network.

Create all the schemas and tables in the DB system but do not load the data.

Offload the data to object storage to facilitate reloading into the cluster.

Create a DB system with a HeatWave shape.

QUESTION 21
Which two methods can you use to import data into a MySQL DB system by using MySQL Shell? (Choose two.)

util.importTable()

util.dumpInstance()

util.dumpSchemas()

util.loadDump()

QUESTION 22
Which is true about changing the storage size of a DB system?

You must increase the DB system’s storage size in multiples of 100 GB.

You cannot decrease the DB system’s storage size.

You must stop the DB system before changing its storage size.

The DB system shuts down during the resize operation.

QUESTION 23
Which two are true about MySQL HeatWave configuration resources? (Choose two.)

You can set a value for any global MySQL variable in a configuration.

You must copy the configuration before changing any variable values.

You can view custom configuration sets with the OCI CLI oci mysql db-system get command.

You can compare configurations in the same compartment in OCI console.

QUESTION 24
A MySQL DB system has an endpoint in an OCI VCN subnet. The VCN is not configured with VCN peering, VPN access, and FastConnect. You want to connect to the MySQL DB system directly from an OCI Cloud Shell session.
Which two are true? (Choose two.)

You must attach the Cloud Shell session to a VCN subnet that can connect to the MySQL DB system.

You must install mysql client programs in the Cloud Shell session.

The MySQL DB system subnet must be in the Cloud Shell tenancy home region.

The VCN subnet of the Cloud Shell session must have a Service Gateway in its route table.

The VCN subnet of the Cloud Shell session must have an Internet Gateway in its route table.

QUESTION 25
You create a new MySQL DB system. It fails because you use mysql.sys as the administrator username.
What is the reason?

mysql.sys is a reserved username that cannot be used in customer-defined user accounts.

The username can contain only uppercase characters.

The username cannot contain non-alphanumeric characters, such as a period.

The username must have at least 10 characters.

QUESTION 26
You can perform a node estimate when adding a HeatWave cluster to a DB system in OCI Console. Which two tasks are performed by the node estimate process? (Choose two.)

Generate a load command to activate Auto Parallel Load.

Estimate the number of OCPUs required to process selected user tables.

Estimate the memory required for each user table.

Generate a set of alter statements to load selected tables into the HeatWave cluster.

Estimate the disk storage required for each user table.

QUESTION 27
You have successfully provisioned a MySQL DB system on Oracle Cloud Infrastructure by using OCI Console. You have installed the standard MySQL client libraries and MySQL Shell on your workstation that is not connected to any VPN, FastConnect, or SSH tunnel.
You CANNOT connect directly to the DB system endpoint from your workstation connected to the Internet.
What is the reason?

MySQL DB system allows only SSL-encrypted connections.

MySQL DB system endpoint does not have a public IP address.

MySQL DB system allows only connections through a proxy server.

MySQL DB system cannot use the standard MySQL client libraries.

QUESTION 28
What must you do to minimize a DB system down time caused by automatic maintenance operations?

Create read replicas.

Add HeatWave cluster.

Enable crash recovery.

Enable high availability.

QUESTION 29
You want to deploy a high-availability MySQL DB system in a region with multiple availability domains.
Which two types of subnet provide maximum redundancy? (Choose two.)

A public AD-specific subnet

A private regional subnet

A public regional subnet

A private AD-specific subnet

Oracle 1z0-915-1 Exam Syllabus Topics:

Topic	Details
Topic 1	Inbound Replication: For database administrators and replication experts, this section of the exam covers setting up and troubleshoot inbound replication and creating channels.
Topic 2	MySQL HeatWave Service: For database administrators, cloud architects, and DevOps engineers, this section of the exam covers identifying key features and benefits, describing MySQL HeatWave architecture, defining MySQL HeatWave terminology, and identifying MySQL HeatWave limitations.
Topic 3	Backing up and restoring DB systems: For database administrators and disaster recovery specialists, this section of the exam covers backing up and restoring a DB system, managing automatic backups, and performing point-in-time recovery.
Topic 4	MySQL HeatWave Configurations: For database administrators and performance tuning specialists, this part of the exam covers creating custom configurations, comparing configurations, describing the effects of changing dynamic and non-dynamic variables, and updating a DB system configuration.
Topic 5	Managing DB systems: For network administrators and cloud infrastructure specialists, this domain of the exam covers demonstrating a command of DRG and DRG Attachments, applying BGP in the OCI environment, evaluating OCI VPN Services, and validating the various FastConnect products from OCI.