Oracle
1Z0-883 · Question #86
1Z0-883 Question #86: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-883 to reveal the answer and full explanation for question #86. The question stem and answer options stay visible for context.
Question
You are using the performance Schema to investigate replication on a slave: Mysql> SELECT THREAD_ID threads.NAME, SUM (COUNT_STAR) AS Totalcount, SUM (SUM_TIMER_WAIT) AS Totaltime FROM performance_schema.events_waits_summary_by_thread_by_event_name INNER JOIN performance_schema,threads USING (THREAD_ID) WHERE threads .NAME LIKE `thread/sql/slave-%' GROUP BY THREAD_ID, threads.NAME; Assume that all instruments and consumers are enabled and all threads are instrumented. Which two facts can be concluded from the given output?
Exhibit
Options
- AAt most two schemas are being updated concurrently.
- BThe server needs more cores to use all slave threads.
- CThe slave cannot process the relay log fast enough to use all threads.
- DThe slave is configured with slave_parallel_workers = 4.
Unlock 1Z0-883 to see the answer
You've previewed enough free 1Z0-883 questions. Unlock 1Z0-883 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.