Pinpoint 1z0-888 Questions Pool 2021

NEW QUESTION 1
A particular government’s security policy is to have very strict data encryption and safety settings. This is done by restricting access based on their own CA authority and limiting access to particular users within a department. Which method could be used to restrict access as required?

• A. using GRANT … REQUIRE X509 AND REQUIRE ISSUER ‘/C=…..’ AND REQUIRE SUBJECT ‘/C=…..’
• B. using GRANT USAGE, X509, …….ON *.* TO user@remotehost IDENTIFIED BY ‘secret_password’
• C. using GRANT … REQUIRE SSL for a secure connection
• D. using GRANT USAGE, SSL, …..ON *.* TO user@remotehost IDENTIFIED BY ‘secret_password’

Answer: A

NEW QUESTION 2
What two statements are true regarding FLUSH TABLES FOR EXPORT?

• A. It can be used to export TEMPORARY tables.
• B. Table only exports when the table has its own tablespace.
• C. The InnoDB Storage engine must be used for the table being exported.
• D. It is the safest way to extract tables from the shared tablespace.
• E. Partitioned tables are not supporte

Answer: AB

NEW QUESTION 3
Which three statements correctly describe MySQL InnoDBCluster?

• A. The cluster can be operated in multimaster mode with conflict detection for DML statements.
• B. All MySQL client programs and connectors can be used for executing queries.
• C. It provides fully synchronous replication between the nodes.
• D. There is support for automatic failover when one node fails.
• E. The data is automatically shared between the nodes.
• F. Each query will be executed in parallel across the node

Answer: BDF

NEW QUESTION 4
You are setting up a new installation of MySQL Server 5.7 (a GA release.) You have used a ZIP or TAR
package to ensure that the mysqld binary, along with its support files, such as plug-ins and error messages, now exist on the host. Assume that the default datadir exists on the host. You installed the binary in the default location (the default -- basedir value) for your operating system.
Which step should you perform before defining your own databases and database tables?

• A. Execute a command with a minimal form of: mysql --initialize
• B. Register mysqld as a service that will start automatically on this host machine.
• C. Create a configuration file containing default-storage-engine=InnoDB.
• D. Set an exception in the host machine’s firewall to allow external users to talk to mysqld.
• E. Create additional login accounts (so that everyone does not need to log in as root) and assign them appropriate privileges.

Answer: C

NEW QUESTION 5
Which three options are most likely to be changed for production form their default values?

• A. innodb_buffer_pool_size
• B. max_connections
• C. join_buffer_size
• D. character_set_system
• E. innodb_log_file_size
• F. max_user_connections
• G. port

Answer: EFG

NEW QUESTION 6
You have a consistent InnoDB backup created with mysqldump, the largest table is 50 GB in size. You start to restore your backup with this command;
shell> mysql –u root –p < backup.sql
After 30 minutes, you notice that the rate of restore seems to have slowed down. No other processes or external factors are affecting server performance.
Which is the most likely explanation for this slowdown?

• A. The MySQL server has stopped inserting data to check index consistency.
• B. InnoDB is doing CRC32 checks over the tablespace data as it grows.
• C. The MySQL server is taking a periodical snapshot of data so it can resume the restore if it is interrupted mid-way.
• D. InnoDB has filled the redo log and now must flush the pages.
• E. Secondary indexes no longer fit into the buffer poo

Answer: A

NEW QUESTION 7
You have installed MySQL Server for the first time on your system. However, the data directory along with the tables in the mysql system database are missing. Which step do you perform to create the contents of the data directory?

• A. Run the create_system_tables.sql file
• B. Run the mysql_unpack.sql file
• C. Invoke mysqld with the --initialize option.
• D. Invoke mysql with the --initialize optio

Answer: C

NEW QUESTION 8
Which three are key advantages of standard MySQL replication?

• A. supports native automatic failover
• B. enables automatic resync of databases when discrepancies are detected
• C. provides arbitrary geographic redundancy with minimal overhead to master
• D. synchronously guarantees identical slave copy
• E. is easy to configure and has low performance overhead
• F. can easily add slaves for read scaling

Answer: BEF

NEW QUESTION 9
Consider the CHECK TABLE command.
In which two situations should this command be used? (Choose two.)

• A. to find out why a query takes a long time to execute on a given table
• B. to make sure a table has no structural problems
• C. to improve performance by updating index distributing statistics on InnoDB tables
• D. to repair table structure problem
• E. to make sure that no table indexes are corrupted

Answer: BE

Explanation:
The CHECK TABLE statement performs an integrity check on table structure and contents. It works for MyISAM and InnoDB tables. For MyISAM tables, it also updates the index statistics. If the table is a view, CHECK TABLE verifies the view definition. If the output from CHECK TABLE indicates that a table has problems, the table should be repaired.

NEW QUESTION 10
MySQL is installed on a Linux server and has this configuration:
[mysqld] user=mysql
datadir=/data/mysql/
As the ‘root’ user, you change the datadir location by executing:
shell> cp –R /var/lib/mysql /data/mysql/ shell> chown –R mysql /data/mysql
What is the purpose of changing ownership of datadir to the ‘mysql’ user?

• A. MySQL needs to be run as the root user, but files cannot be owned by it.
• B. The mysqld process requires all permissions within datadir to be the same.
• C. MySQL cannot be run as the root user.
• D. MySQL requires correct file ownership while remaining secur

Answer: A

NEW QUESTION 11
An existing master-slave setup is currently using a delayed replication of one hour. The master has crashed and the slave
must be “rolled forward” to provide all the latest datA. The SHOW SLAVE STATUS indicates these values: RELAY_LOG_FILE=hostname-relay-bin.00004 RELAY_LOG_POS=1383
Which command set would make the slave current?

• A. STOP SLAVE; SET GLOBAL master_delay=0; START SLAVE;
• B. STOP SLAVE; CHANGE MASTER TO RELAY_LOG_FILE = ‘hostname-relay-bin.00004’, RELAY_LOG_POS = 1383;
• C. STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; START SLAVE;
• D. STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; RELAY_LOG_FILE = ‘hostname-relay-bin.00004’, RELAY_LOG_POS = 1383;

Answer: C

NEW QUESTION 12
You inherited a busy InnoDB OLTP Instance with 100 schemas and 100 active users per schema. Total dataset size is 200G with an average schema size G.
The data is transient and is not backed up and can be repopulated easily. Performance and responsiveness of the DB is paramount.
The query pattern for the DB instance is split 90/10 read/write. DB host is dedicated server with 256G RAM and 64 cores.
One of your colleagues made some recent changes to the system and users are now complaining of performance impacts. Which four configuration file edits might your colleague have performed to cause the negative DB performance?

• A. table_open_cache = 64
• B. innodb_buffer_pool_instances=64 innodb_buffer_pool_size=200G
• C. log_bin=mysql –bin Innodb_flush_log_at_trx_commit=1
• D. sync_binlog=10
• E. innodb_flush_method=O_DIRECT
• F. max_heap_table_size = 2G tmp_table_size=2G
• G. query_cache_size = 2G query_cache_enabled=1
• H. innodb_flush_log_at_trx_commit=0

Answer: ABEG

NEW QUESTION 13
Consider:

Which statement best describes the meaning of the value for the key_len column?

• A. It shows how many bytes will be used from each index row.
• B. It shows the number of characters indexed in the key.
• C. It shows the total size of the index row.
• D. It shows how many columns in the index are examine

Answer: A

NEW QUESTION 14
Force Majeure is a catastrophic failure on a major level of the database operation. Regular backups are key to helping avoid data loss in such situations.
Which two other steps can help avoid data loss in a major catastrophe?

• A. Implement a failover strategy to another geographic location.
• B. Create a master-master pair for each service.
• C. Have a second data centre in a different region or country.
• D. Keep software updated to the latest version.
• E. Use RAID 10 storage for datA.
• F. Use on-site network-attached storage to separate service from dat

Answer: AC

NEW QUESTION 15
You will configure a MySQL Server to act as a replication master. Which two options must be configured correctly to allow this?

• A. log-master-updates
• B. rpl-recovery-rank
• C. server-id
• D. enable-master-start
• E. log_bin
• F. master-logging

Answer: CE

NEW QUESTION 16
An administrator installs MySQL to run under a mysql OS account. The administrator decides to disable logins to the mysql account by using /nologin or /bin/false as the user’s shell setting.
Which statement is true?

• A. The mysql user needs a login and its home directory must be the base directory of the installation.
• B. The OS needs to allow logging in as mysql so that administrative tasks can be performed.
• C. This prevents mysqld from starting when standard startup scripts are used.
• D. This prevents creation of a command shell with the mysql account, while allowing mysqld to ru

Answer: A

NEW QUESTION 17
After rebooting the host, you attempt to start the mysqld service. You get the following error: Can’t start the server: Bind on TCP/IP port: Address already in use
What is the most likely cause of this error?

• A. The mysql service has already been started on the same port.
• B. The network service process in the server is frozen, so all TCP/IP connections are paused and cannot be reused.
• C. You failed to specify the port number 3306 to the command to start the server, so it is defaulting to port 80, which is in use by the built-in web server.
• D. The /etc/hosts file does not have a valid IP entry for mysqld localhost, so it is binding to 127.0.0.1, which is already in use.
• E. The mysql.sock file in the MySQL /tmp directory was not removed after the reboot, so mysqld still thinks there is an active server running.

Answer: E

NEW QUESTION 18
Which two statements describe how InnoDB recovery works?

• A. InnoDB handles most crash recoveries automatically.
• B. InnoDB blocks some operations when innodb_force_recovery is set to greater than 0.
• C. There will in general be lost committed transactions after a crash using the default settings.
• D. It is required to enable binlog_gtid_simple_recovery to perform a crash recovery.
• E. It is recommended to set innodb_force_recovery = 1 as part of normal operations.
• F. It is always required to enable innodb_force_recovery to perform a crash recover

Answer: BF

NEW QUESTION 19
When you examine a new MySQL installation with default configuration, you find a file called ibdata1 in the database directory. Which two statements are true about this file?

• A. it contains the binary log.
• B. it contains a general tablespace.
• C. it is the default location for all new tables that you create.
• D. it contains the system tablespace.
• E. it contains the redo log.
• F. it contains the undo lo

Answer: CD

NEW QUESTION 20
Group Replication uses global transaction identifiers to track executed transactions and are fundamental in avoiding transaction conflict. Which additional three steps help in avoiding conflicts in group replication?

• A. Set isolation level to be SERIALIZABLE.
• B. Use the binary log row format.
• C. Set isolation level to be READ COMMITTED.
• D. Configure IPv6 network for hosts.
• E. Guarantee a secondary index on every table.
• F. Guarantee a primary key on every table.
• G. Set multiple slave parallel worker thread

Answer: ABF

NEW QUESTION 21
Which statement is true about using Microsoft Windows Cluster as a platform for MySQL?

• A. It relies on the shared disk architecture being visible to both servers.
• B. It is provided by means of IP-level disk replication.
• C. It implements High Availability by using the NET Connector's load balancing capabilities.
• D. It is a shared-nothing architectur

Answer: A

NEW QUESTION 22
What is the best method for monitoring Group Replication conflict resolution?

• A. the PERFORMANCE_SCHEMA tables
• B. the SHOW PROCESSLIST command
• C. the INNODB Lock Monitor details
• D. the SHOW STATUS command
• E. the INFORMATION_SCHEMA tables

Answer: A

NEW QUESTION 23
Exhibit:

What does the possible_keys column in this output denote?

• A. if it is possible for you to include any indexes in your query
• B. whether there are any indexes on the tables that you are querying
• C. if there are any indexes that may be used to solve this query
• D. whether there are any indexes in your query

Answer: A

NEW QUESTION 24
Which two statements are true about InnoDB auto-increment locking?

• A. InnoDB never uses table_level locks.
• B. InnoDB always protects auto-increment updates with a table-level lock
• C. InnoDB does not use locks to enforce auto-increment uniqueness.
• D. The auto-increment lock can be a table-level lock.
• E. Some settings for innodb_autoinc_lock_mode can help reduce lockin

Answer: DE

NEW QUESTION 25
......