최신 1Z1-921 무료덤프 - Oracle MySQL 2021 Implementation Essentials

문제1

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.

정답: A

문제2

What are the two main components required to set up persistent storage for MySQL on Kubernetes?
Response:

A. Pod and ReplicaSet

B. Secret and Deployment

C. PVC (Persistent Volume Claim) and ConfigMap

D. PVC (Persistent Volume Claim) and PV (Persistent Volume)

정답: D

문제3

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

A. Altering the storage engine for all tables to memory to increase performance.

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. Adding a memcached-tier for caching data and objects in RAM to reduce the number of times an external data source must be read.

E. Implementing a three-node, single-primary InnoDB Cluster.

정답: A,E

문제4

What is true about MySQL Enterprise Transparent Data Encryption (TDE)?

A. Enables data-at-rest encryption by encrypting the physical files of the database.

B. Tablespace keys are managed manually behind the scenes.

C. Data is encrypted automatically, in real time, after it is written to storage.

D. Encryption key is stored in a centralized key memory location

정답: A

문제5

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

A. The number of machines per group must be 3, 5, 7 or 9.

B. Networks must be in separate regions.

C. isolated machine resources

D. smaller VM,s work best - with a maximum of eight vCPU,s and 16GB of RAM

E. use SSD,s for data and replication logs

F. Use Network-attached storage (NAS) for the data files.

G. Groups must be in even numbers; 2, 4, 6, 8.

정답: A,F,G

문제6

What is Kubernetes in the context of MySQL?
Response:

A. A database management tool for MySQL.

B. A database engine for MySQL.

C. A cloud service provided by Oracle for MySQL databases.

D. An open-source container orchestration platform.

정답: D

문제7

Which MySQL command is used to grant specific privileges to a user on a database?
Response:

A. GIVE ACCESS

B. GRANT PERMISSIONS

C. SET PRIVILEGES

D. GRANT

정답: D

문제8

Which activity will take place if a table is created with both the compression and encryption options?

A. The tablespace data is encrypted first and then compression is performed.

B. The compression is performed, the ''data_at_rest_flag" is turned on and the tablespace data is encrypted.

C. The compression is performed before tablespace data is encrypted.

D. The system generates an error because the COMPRESSION and ENCRYPTION options cannot be used together.

정답: C

최신 1Z1-921 무료덤프 - Oracle MySQL 2021 Implementation Essentials

우리와 연락하기

유용한 링크

최신 업데이트