Showing all 15 resultsSorted by latest
Username or email address *
Password *
Log in
Lost your password? Remember me
No account yet?
1z0-908
Practice makes perfect! Take this quiz now to test your knowledge and boost your confidence for the real exam.
1 / 5
Which three are characteristics of a newly created role? (Choose three.) E. It can be granted to user accounts. F. It can be protected with a password.
https://dev.mysql.com/doc/refman/8.0/en/roles.html https://www.mysqltutorial.org/mysql-roles/
2 / 5
The data in this instance is transient; no backup or replication will be required. It is currently under performing. The database size is static and including indexes is 19G. Total system memory is 32G. After profiling the system, you highlight these MySQL status and global variables: The OS metrics indicate that disk is a bottleneck. Other variables retain their default values. Which three changes will provide the most benefit to the instance? (Choose three.) E. innodb_doublewrite=0 F. max_connections=10000 G. innodb_undo_directory=/dev/shm
Reference: https://aws.amazon.com/blogs/database/best-practices-for-configuring-parameters- foramazon-rds-for-mysql-part-1-parameters-related-to-performance/
3 / 5
Which statement is true about InnoDB persistent index statistics? engine. is created. innodb_stats_persistent_sample_pages is increased. E. Increasing innodb_stats_persistent_sample_pages determines higher pages scanning speed, at the cost of increased memory usage. F. Tables are scanned and index statistics recalculated when an instance is restarted.
Reference: https://mariadb.com/kb/en/innodb-persistent-statistics/
4 / 5
Examine this statement, which executes successfully: You want to improve the performance of this query: Which change enables the query to succeed while accessing fewer rows? E. ALTER TABLE world.city ADD FULLTEXT INDEX (Name); F. ALTER TABLE world.city ADD FULLTEXT INDEX (Population);
Reference: https://dev.mysql.com/doc/refman/5.7/en/creating-spatial-indexes.html
5 / 5
tps://marks4certs.com/wp-content/uploads/quiz-images/1z0-908_Q3.jpeg
Your score is
Restart quiz
