Free 1z1-908 Exam Files Verified & Correct Answers Downloaded Instantly [Q10-Q29]

Rate this post

Free 1z1-908 Exam Files Verified & Correct Answers Downloaded Instantly

Instant Download 1z1-908 Dumps Q&As Provide PDF&Test Engine

Q10. You plan to take daily full backups, which include the ndbinfo and sys (internal) databases.
Which command will back up the databases in parallel?

mysqldump –single-transaction > full-backup-$(date +%Y%m%d).sql

mysqlpump –include-databases=% > full-backup-$(date +%Y%m$d).sql

mysqlpump –all-databases > full-backup-$(date +%Y%m%d).sql

mysqldump –all-databases > full_backup-$(date +%Y%m%d).sql

Q11. Which two queries are examples of successful SQL injection attacks? (Choose two.) SELECT user,passwd FROM members

WHERE user = ‘?’;INSERT INTO members(‘user’,’passwd’) VALUES
(‘[email protected]’,‘secret’);–‘;

SELECT id, name FROM user WHERE user.id=(SELECT members.id FROM members);

SELECT id, name FROM user WHERE id=23 OR id=32 OR 1=1;

SELECT id, name FROM user WHERE id=23 OR id=32 AND 1=1;

SELECT email,passwd FROM members

WHERE email = ‘INSERT INTO members(‘email’,’passwd’) VALUES
(‘[email protected]’, ‘secret’);–‘;
SELECT user, phone FROM customers WHERE name = ‘; DROP TABLE users; –‘;

Q12. You issue this command:
SHOW SLAVE STATUS –
In the output, there is a value for Seconds_behind_master.
How is this time calculated?

It is the time between the I/O thread receiving details of the master’s last transaction and the time it was applied by the SQL thread.

It is the time between the most recent transaction written to the relay logs and the time it was committed on the master.

It is the time between the I/O thread receiving details of the master’s last transaction and the time it was written to the relay log on the slave.

It is the time between the most recent transaction applied by a SQL thread and the time it was committed on the master.

Q13. Your MySQL server was upgraded from an earlier major version.
The sales database contains three tables, one of which is the transactions table, which has 4 million rows.
You are running low on disk space on the datadir partition and begin to investigate.
Examine these commands and output:

Which two statements are true? (Choose two.)

Executing SET GLOBAL innodb_row_format=COMPRESSED and then ALTER TABLE transactions will free up disk space.

Executing ALTER TABLE transactions will enable you to free up disk space.

Truncating the sales and leads table will free up disk space.

Truncating the transactions table will free up the most disk space.

The transactions table was created with innodb_file_per_table=OFF.

Q14. Examine these InnoDB Cluster parameter settings:

Now examine the partial status:

A permanent network failure isolates host3.
Which two statements are true? (Choose two.)

The instance deployed on host2 is elected as the new primary instance.

The instance deployed on host3 is expelled from the cluster and must be rejoined using cluster.addInstance (‘host3:3377’)

The instance deployed on host3 will automatically rejoin the cluster when connectivity is re-established.

Failure of the instance deployed on host1 provokes an outage.

The issuing command cluster.switchToMuitiPrimaryMode() will fail to enable multi-primary mode.

The primary instance can be specified by using the command
cluster.setPrimaryInstance(<host>:<port>).

Q15. Which two are contained in the InnoDB system tablespace (ibdata1) by default? (Chose two.)

table data

primary indexes

user privileges

InnoDB Data Dictionary

change buffer

doublewrite buffer

Q16. Examine the modified output:

Seconds_Behind_ Mastervalue is steadily growing.
What are two possible causes? (Choose two.)

The master is most probably too busy to transmit data and the slave needs to wait for more data.

One or more large tables do not have primary keys.

This value shows only I/O latency and is not indicative of the size of the transaction queue.

The master is producing a large volume of events in parallel but the slave is processing them serially.

The parallel slave threads are experiencing lock contention.

Q17. Which two storage engines provide a view of the data consistent with the storage system at any moment?
(Choose two.)

MyISAM

NDB

MEMORY

ARCHIVE

InnoDB

Q18. Which condition is true about the use of the hash join algorithm?

No index can be used for the join.

The query must access no more than two tables.

The smallest of the tables in the join must fit in memory as set by join_buffer_size.

At least one of the tables in the join must have a hash index.

Q19. Which three are characteristics of a newly created role? (Choose three.)

It can be dropped using the DROP ROLE statement.

It is stored in the mysql.role table.

It is created as a locked account.

It can be renamed using the RENAME ROLE statement.

It can be granted to user accounts.

It can be protected with a password.

Q20. There are five MySQL instances configured with a working group replication.
Examine the output of the group members:

Which two statements are true about network partitioning in the cluster? (Choose two.)

The cluster will shut down to preserve data consistency.

The cluster has built-in high availability and updates group_replication_ip_whitelistto remove the unreachable nodes.

The group replication will buffer the transactions on the online nodes until the unreachable nodes return online.

There could be both a 2 node and 3 node group replication still running, so shutting down group replication and diagnosing the issue is recommended.

A manual intervention to force group members to be only the working two instances is required.

Q21. Which two statements are true about the mysqld-auto.cnf file? (Choose two.)

This file is for storing MySQL Server configuration options in ISON format.

This file is for logging purposes only and is never processed.

It is read and processed at the beginning of startup configuration.

It is read and processed at the end of startup configuration.

It is always updated with changes to system variables.

This file is for storing MySQL server_uuid values only.

Q22. The data in this instance is transient; no backup or replication will be required. It is currently under performing.
The database size is static and including indexes is 19G.
Total system memory is 32G.
After profiling the system, you highlight these MySQL status and global variables:

The OS metrics indicate that disk is a bottleneck. Other variables retain their default values.
Which three changes will provide the most benefit to the instance? (Choose three.)

innodb_flush_log_at_trx_commit=1

buffer_pool_size=24G

innodb_log_file_size=1G

sync_binlog=0

innodb_doublewrite=0

max_connections=10000

innodb_undo_directory=/dev/shm

Q23. Examine this command and output:

Which two options will improve the security of the MySQL instance? (Choose two.)

Remove group read/write privileges from the private_key.pem file.

Remove world read privileges from the server-cert.pem certificate file.

Change the group ownership of the mysql directory to the mysql user group.

Remove world read privileges from the public_key.pem file.

Change the parent directory owner and group to mysql.

Remove the world read/execute privilege from the accounting directory.

Q24. Which two are valid uses for binary logs on a MySQL instance? (Choose two.)

recording the order in which queries are issued

audit of all queries

point-in-time recovery

replication

logging the duration and locks for all queries

Q25. You reconfigure and start a slave that was not replicating for several days.
The configuration file and CHANGE MASTER command are correct. Examine the GTID information from both master and slave:

Which statement is true?

Replication will fail because the slave has purged more aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa transactions than the master.

Replication will fail because the master does not have the required transaction with bbbbbbbb-bbbb- bbbb-bbbb-bbbbbbbbbbbb GTIDs in its binary logs.

Replication will fail because the master has already purged transactions with cccccccc-cccc-cccc- cccc-cccccccccccc GTIDs.

Replication will fail because of inconsistent numbers in cccccccc-cccc-cccc-cccc-cccccccccccc GTIDs.

Replication will work.

Q26. Examine this statement, which executes successfully:

You want to improve the performance of this query:

Which change enables the query to succeed while accessing fewer rows?

ALTER TABLE world.city ADD SPATIAL INDEX (Name);

ALTER TABLE world.city ADD SPATIAL INDEX (Population);

ALTER TABLE world.city ADD INDEX (Population);

ALTER TABLE world.city ADD INDEX (Name);

ALTER TABLE world.city ADD FULLTEXT INDEX (Name);

ALTER TABLE world.city ADD FULLTEXT INDEX (Population);

Q27. Examine this statement, which executes successfully:

You want to improve the performance of this query:

Which change enables the query to succeed while accessing fewer rows?