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

What is the role of MySQL Enterprise Firewall in preventing SQL injection attacks?

• A.Optimizes query performance to avoid slow queries
• B.Provides an audit trail of all queries executed in the database
• C.Monitors and blocks queries that do not match a predefined safe pattern
• D.Encrypts SQL queries before execution

Which of the following steps is necessary after installing MySQL on a Windows system?

• A.Install MySQL as a Linux service
• B.Compile the server from source code
• C.Set up table partitioning
• D.Configure server options in my.ini

What is the main limitation of asynchronous replication in MySQL?

• A.It can result in data loss if the primary server crashes before the replicas receive the changes
• B.It only works with InnoDB tables
• C.It has a higher latency than synchronous replication
• D.It requires all replicas to acknowledge each transaction

Which MySQL Enterprise Edition feature allows you to track database activity in order to meet compliance requirements?

• A.MySQL Enterprise Firewall
• B.MySQL Enterprise Backup
• C.MySQL Enterprise Audit
• D.MySQL Enterprise Monitor

What is the maximum length of a VARCHAR column in MySQL?

• A.32,767 characters
• B.65,535 characters
• C.1,000 characters
• D.255 characters