Exam C2090-600 topic 1 question 16 discussion

The answer D is correct. Indeed, The event monitor can be used to obtain information at a specific point in time. Other uses have not been ruled out. The answer A is wrong. The Event Monitor data can be reviewed even after deactivating the event monitor.

The answer A is correct. You can view data collection with a SQL query even if the event monitor is active. But, Optionally, depending on how you are using the event monitor data, deactivate data collection before you start examining the event data. If the event monitor remains active, it continues to write data to the output tables. Therefore, the results from one query might differ from the results that you obtain by running the same query later on. Reference : https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.admin.mon.doc/doc/t0059089.html

The answer C is wrong. All event monitors can write to regular tables that can be queried directly using SQL. Reference : https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.admin.mon.doc/doc/c0059021.html

The answer B is wrong. Indeed, By default, some event monitors activate automatically upon database activation; others require that you activate them manually. However, an event monitor created with the AUTOSTART option will not automatically be activated until the next database activation. Use the SET EVENT MONITOR STATE statement to force a recently-created event monitor into the active state. To determine whether an event monitor starts automatically, refer to the reference information for the relevant CREATE EVENT MONITOR statement. Reference : https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.admin.mon.doc/doc/t0059044.html See paragraph "2. Activate the event monitor."

The answer D is wrong. Indeed, Monitoring table functions and snapshot routines return the values of monitor elements at the specific point in time the routine is run, which is useful when you want to check the current state of your system. However, you might not always want to monitor points in time. There are many times when you need to capture information about the state of your system at exactly the time that a specific event occurs. Event monitors serve this purpose. REFERENCE : https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.admin.mon.doc/doc/r0005993.html