1Z0-920 試験問題を無料オンラインアクセス

What three are ways to export and import data in MySQL Workbench?

• A.SQL Data Export and Import Wizard
• B.Binary Data Export and Import Wizard
• C.Data Modeling Import Export Wizard
• D.Backup Data Export and Import Wizard
• E.Table Data Export and Import Wizard
• F.Result Data Export and Import

Which two deployment architectures could you use for scaling-out database reads?

• A.Adding a memcached-tier for caching data and objects in RAM to reduce the number of times an external data source must be read.
• B.Changing the system setting with memory stickiness to true in order not to swap out mysq1dfrom memory.
• C.Edit the configuration file and increase the value for parallel_read_workers and reboot the server
• D.Altering the storage engine for all tables to memory to increase performance.
• E.Implementing a three-node, single-primary InnoDB Cluster.

What are two ways in which customers can receive notifications such as outages, configuration changes, database emergencies, and other information on their Database as a Service instances?

• A.Browser pop-ups
• B.Email
• C.Application-to-application messaging
• D.SMS-notification tab on the dashboard
• E.Direct support call from an Oracle representative

You just installed MySQL by Using a Package Manager on Linux.
Where are the default InnoDB redo log files stored?

• A./usr/redo
• B./usr/bin/logs
• C./var/lib/mysql
• D./var/lib/mysql/innodb
• E./etc/my.cnf
• F./usr/mysql

You need to change the password level for a test system.
Which two allow to change this level before you create new test user/passwords?

• A.SET GLOBAL validate_password_policy='new level';
• B.SET GLOBAL force_password_complex_policy=0;
• C.Add validate_password_policy='new level' in the [mysqld] section of the MySQL configuration file.
• D.Add validate_password='new level' in the [security] section of the MySQL configuration file.