CompTIA Online Training

1Z0-888 MySQL 5.7 Database Administrator

October 8, 2018 by admin

Exam Title: MySQL 5.7 Database Administrator
Exam Number: 1Z0-888
Exam Price: $245.00 More on exam pricing
Format: Multiple Choice
Duration: 120 Minutes
Number of Questions: 75
Passing Score: 58%
Validated Against: Recommended Training
Take Recommended Training Courses

Complete one of the courses below to prepare for your exam (optional):

MySQL for Database Administrators Ed 4

Additional Preparation and Information

A combination of Oracle training and hands-on experience (attained via labs and/or field experience) provides the best preparation for passing the exam.

Installing MySQL
Installing MySQL
Installed Files and Directories
Initial Configuration
Starting and Stopping MySQL

Configuring MySQL
Server Options, Variables, and the Command Line
Option Files
System Variables

User Management
MySQL Privilege System
Creating and Modifying User Accounts
Configuring Passwords and Account Expiration
Authentication Plug-Ins
Granting Permissions
Resetting a Forgotten Root Password

Maintaining a Stable System
Stability
Capacity Planning
Troubleshooting
Identifying the Causes of Server Slowdowns
InnoDB Recovery

Backup Strategies
Understanding Backups
Creating a Backup Strategy
MySQL Backup Tools
Raw Backup Methods
Techniques that Use the Binary Log

MySQL Architecture
How MySQL Processes Requests
How MySQL Stores Data
Tablespaces
Redo and Undo Logs
How MySQL Uses Memory

Monitoring MySQL
Monitoring MySQL with Log Files
Monitoring MySQL with Status Variables
Monitoring MySQL with Performance Schema

MySQL Security
Security Risks
Network security
Password Security
Operating System Security
Protecting Against SQL Injections

Optimizing Query Performance
Identifying Slow Queries
The EXPLAIN statement
Working with Indexes
Index Statistics

Configuring a Replication Topology
Replication Conflicts
When to Use Replication
Configuring Replication
MySQL Utilities
Replication Threads
Monitoring Replication
Troubleshooting Replication

QUESTION 1
Is it true that binary backups always take less space than text backups?

A. Yes, because binary backups only contain data, and not statements required to insert data into the tables.
B. No, because text backups can have optimizations, which make them smaller, such as updating many rows at once.
C. No, because if InnoDB tables contain many empty pages, they could take more space than the INSERT statements.
D. Yes, because even if InnoDB tables contain many empty pages, text backups have empty INSERT statements for them.

Answer: C

QUESTION 2
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: C E

QUESTION 3
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 supported.

Answer: A B

QUESTION 4
Which are three facts about backups with mysqldump?

A. will lock all storage engines for duration of backup
B. can back up a remote database server
C. allow a consistent backup to be taken
D. are able to back up specific items within a database
E. create automatically compressed backups
F. are always faster to restore than binary backups

Answer: B C D

QUESTION 5
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 examined.

Answer: A

Comments |0|