1Z0-920 무료 덤프문제 온라인 액세스

The user -os-user'@"localhost" was created to monitor connections and shut down the server, and was granted these privileges:
GRANT PROCESS, SHUTDOWN ON *.* TO "OS-user*@"localhost';
Which three are commands that the os-user can execute?

• A.SHOW PROCESSLIST;
• B.KILL PROCESS;
• C.SHOW STATUS;
• D.GRANT PROXY
• E.SHOW BINLOG EVENTS;
• F.SHUTDOWN

The user 'fwuser'@'localhost% was registered with the MySQL Enterprise Firewall and was granted privileges for the SAKILA database. You executed the commands:

You want to clear the account whitelist for the * fwuser" @* localhost* user. Which statement should you run to accomplish this?
A)

B)

C)

D)

• A.Option D
• B.Option A
• C.Option C
• D.Option B

Which two methods help prevent MySQL security risks?

• A.Ensure that MySQL accounts have short and easy passwords.
• B.Transmit plain (unencrypted) data over networks.
• C.Use a firewall to control access to MySQL ports.
• D.Use the secure installation script "mysql_alays_secure_installation".
• E.Allow unauthorized clients to connect to the server.
• F.Grant only permissions that a user requires.

Which two are advantages of using Document Store in MySQL?

• A.MySQL can store XML as a schema-less database
• B.MySQL is a document database allowing PDF and Word documents
• C.MySQL provides a native data type to index PDF documents
• D.MySQL provides a NoSQL API to access the document store
• E.MySQL provides a native data type to store JSON data as a document

An existing MySQL Database environment has been doing backup and restore in a logical way by using the mysq1dump and mysq1 client utilities. When the backup is started using mysqldump with single-transaction mode, the existing application has long wait time. When the restore is required, it takes more than three hours to restore.
What two are benefits of using mysqlbackup from MySQL Enterprise Backup in this situation?

• A.mysqlbackup utilities dump the full database into a SQL file, which is imported into the mysql client in single-thread mode. mysqlbackup restores data from physical backups. Physical backup methods are faster than logical methods because they involve only file coping without conversion.
• B.mysqlbackup can back up tables with the InnoDB engine without blocking. The backup is hot with InnoDB. Together with Incremental Backup, mysqlbackup from MySQL Enterprise Backup shortens the backup windows.
• C.MySQL Enterprise Backup does not back up system data so that it is much faster.
• D.mysqlbackup from MySQL Enterprise Backup allows logical backup with concurrency built in to get faster backup speed and restoration speed.
• E.MySQL Enterprise Backup provides tape backup integration by default. It has the virtual tape option, which allows backup to tape device directly without extra third-party software integration.