1Z1-921 무료 덤프문제 온라인 액세스

Which three are recommended configurations for installing and running MySQL InnoDB Cluster?

• A.use SSD,s for data and replication logs
• B.Networks must be in separate regions.
• C.isolated machine resources
• D.Use Network-attached storage (NAS) for the data files.
• E.Groups must be in even numbers; 2, 4, 6, 8.
• F.The number of machines per group must be 3, 5, 7 or 9.
• G.smaller VM,s work best - with a maximum of eight vCPU,s and 16GB of RAM

You want to create an encrypted table. So, you enter this command:
CREATE TABLE 'test_encryption2% (
'id' int(10) unsigned NOT NULL AUTO_INCREMENT,
'server_name' varchar(15) NOT NULL,
PRIMARY KEY ('id') ) ENGINE=MYISAM AUTO_INCREMENT=l DEFAULT CHARSET=latin1 ENCRYPTION = 'Y1; You receive the following error:
ERROR 1031 (HY000): Table storage engine for 'test_encryption2' doesn't have this option Which statement correctly explains the reason for this error?

• A.You cannot use the AUTO_INCREMENT option to create an encrypted table. This is what is causing the error.
• B.The term "server_name" is a reserved MySQL term. You cannot use it for the new table. This is what is causing the error.
• C.The test_encryption2 already exist. You are not using the correct option to recreate it and it is causing the error.
• D.The encryption feature only works with InnoDB tables. You are creating a MylSAM table, and it is causing the error.

Which two statements are correct about MySQL Enterprise Edition?

• A.Oracle MySQL Enterprise tools & plugins are available as optional services (installation Feature Pack I/II).
• B.MySQL Enterprise Edition can be installed on an Oracle Cloud Infrastructure Compute Instance.
• C.Oracle offers 24x7, global support for MySQL Enterprise Edition products installed on Oracle Cloud Infrastructure Compute Instances.
• D.MySQL configuration can be changed in /etc/lib/myi.cnf.
• E.MySQL Enterprise Product Suite can be installed on an Oracle Cloud Infrastructure Virtual Cloud Network.

Which three are characteristics of the JSON data type?

• A.It supports indexing directly against the JSON-defined column.
• B.It is based on the TEXT data type.
• C.It validates the JSON syntax on insert or merge.
• D.Key or array references enable quick read-access to look up document elements directly.
• E.A set of SQL functions substantially support the SQL utilization of the data type.
• F.Comparisons of JSON values are not case-sensitive.

Which two are advantages of using Document Store in MySQL?

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