New 2024 Realistic 1z0-915-1 Dumps Test Engine Exam Questions in here [Q27-Q48]

NO.27 Which two are true about read replica load balancer? (Choose two.)

It has the same endpoint as the DB system.

It distributes connections among the source DB system and all read replicas.

User accounts containing a client host name cannot connect to the read replica load balancer.

It is created when the DB system is first created.

It distributes connections among read replicas.

NO.28 You want to create a read replica on a DB system.
Which is true about the read replica?

It must have at least 4 OCPUs.

It must have at least 1 TB of storage

It must be a bare metal shape

lt must have at least 64 GB of memory.

NO.29 Which table option defines a Lakehouse external table based on a CSV file?

ENGINE=csv SECONDARY_ENGINE=rapid ENGINE_ATTRIBUTE='{“file”: [{“region”:
“us-ashburn-1”, “namespace”: “mytenant”, “bucket”: “bucket01”, “name”: “airport.csv”}] }’

ENGINE=csv SECONDARY_ENGINE=lakehouse ENGINE_ATTRIBUTE='{“file”: [{“region”:
“us-ashburn-1”, “namespace”: “mytenant”, “bucket”: “bucket01”, “name”: “airport.csv”}] }’

ENGINE=lakehouse SECONDARY_ENGINE=csv ENGINE_ATTRIBUTE='{“file”: [{“region”:
“us-ashburn-1”, “namespace”: “mytenant”, “bucket”: “bucket01”, “name”: “airport.csv”}] }’

ENGINE=lakehouse SECONDARY_ENGINE=rapid ENGINE_ATTRIBUTE='{“file”: [{“region”:
“us-ashburn-1”, “namespace”: “mytenant”, “bucket”: “bucket01”, “name”: “airport.csv”}] }’

NO.30 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?

mysqlsh mysql://[email protected]:3311

mysqlsh mysql://[email protected]:3306

mysqlsh mysql://[email protected]:3311

mysqlsh mysql://[email protected]:3306

NO.31 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.

NO.32 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;

NO.33 You have a MySQL DB system with five active read replicas. The workload consists of 5% writes and 95% reads.
Which connection method provides the fastest query response time?

Connect to the source DB system to perform read-only operations.

Connect to a specific read replica to perform read-only operations.

Connect to the read replica load balancer to perform read-only operations.

Connect to the read replica load balancer to perform read/write operations.

NO.34 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.

NO.35 You want to import data into a DB system with MySQL Shell util.loadDump().
Which option can speed up the load?

updateGtidSet: off

showMetadata: false

skipBinlog: true

deferTableIndexes: all

NO.36 Which type of configuration variables CANNOT be modified in MySQL custom configurations?

Initialization variables

User variables

System variables

Default user variables

NO.37 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?

Configure an OCI network load balancer to accept incoming connections on a public IP and route to the DB system private IP address.

Create a service gateway in the VCN and configure the DB system subnet to route Internet-bound traffic to the service gateway.

Create an Internet gateway in the VCN and configure the DB system subnet to route Internet-bound traffic to the Internet gateway.

Create a NAT gateway in the VCN and configure the DB system subnet to route Internet-bound traffic to the NAT gateway.

NO.38 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.

NO.39 What must you do before deleting a DB system?

Take a manual backup

Stop the instance if it is running.

Disable delete protection if it is enabled.

Stop and remove any connected HeatWave Cluster.

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

Primary instance: AD1-FD1; Secondary instance 1: AD2-FD2; Secondary instance 2: AD3-FD3

Primary instance: AD1-FD3; Secondary instance 1: AD2-FD2; Secondary instance 2: AD3-FD3

Primary instance: AD1-FD1; Secondary instance 1: AD1-FD2; Secondary instance 2: AD1-FD3

Primary instance: AD1-FD3; Secondary instance 1: AD1-FD2; Secondary instance 2: AD1-FD3

NO.41 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.

NO.42 You want to migrate an on-premises MySQL database to a MySQL DB system on OCI.
Which method provides the least amount of application down time when switching to the DB system?

Run MySQL Shell on an OCI compute instance to export and import the data for faster migration.

Store the exported data in object storage to speed up the export and import.

Use inbound replication to synchronize the MySQL database transactions to the DB system.

Use the largest DB system shape to speed up the import.

NO.43 Which is true about exporting data to Object Storage with MySQL Shell util.dumpInstance?

You must have a valid OCI CLI configuration.

You must specify ociParManifest: true.

You must specify ocimds: true.

You must provide an OCI username and password to gain write access to Object Storage.

NO.44 You want to restore the backup of a stand-alone DB system to a new DB system.
Which two changes are allowed? (Choose two.)

Use a smaller data storage size for the new DB system.

Use a different subnet for the new DB system.

Use a different shape for the new DB system.

Use a different tenancy for the new DB system.

Use a different region for the new DB system.

NO.45 What happens when you perform a switchover of a high-availability DB system with an attached HeatWave cluster?

The HeatWave cluster is deleted and a new HeatWave cluster is attached to the new primary instance.

The HeatWave cluster is attached to the new primary instance.

The HeatWave cluster remains attached to the same DB system and the new primary instance redirects queries to that cluster.

The HeatWave cluster is no longer valid; you must re-create the HeatWave cluster.

NO.46 Which feature do you use to copy transactions from an on-premises MySQL instance to a DB system?

HeatWave cluster

Inbound replication

Read replica

Outbound replication

NO.47 You want to determine which version of MySQL is running on your DB system.
Which two SQL statements show the MySQL version? (Choose two.)

SELECT * FROM performance_schema.global_status WHERE VARIABLE_NAME=’version’;

select @@version;

SHOW VARIABLES LIKE ‘version’;

SHOW STATUS LIKE ‘version’;

SELECT @version;

NO.48 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.

Leave a Reply Cancel reply