READ Free Dumps For IBM- C2090-423
| Question ID 12819 | You have created a data rule to validate the AccountTotal column in a database on a daily |
| Option A | Add a Validity benchmark to the rule; assess the variance after current end of day run. |
| Option B | Add a Baseline Comparison benchmark to the rule with the interval option set to daily; assess thevariance to similarity percent after current end of day run. |
| Option C | Create three Metrics: one to evaluate current end of day total, one to hold the total value for the prior end of day; and one to assess the variance between the current and prior end of day values. |
| Option D | Add a Baseline Comparison benchmark to the rule; create a Metric to assess the current degradation percent minus the baseline degradation percent then divided by the standard deviation of the variance percent after current end of day run. |
| Correct Answer | C |
| Question ID 12820 | You are analyzing a known table with a 7 column primary key. You wish to minimize |
| Option A | Select only the 7 columns and run Multi-column Primary Key Analysis with Concatenate Multi-column option = Yes. Then review Primary Key Analysis on the Multi-column tab. |
| Option B | Select only the 7 columns and run Multi-column Primary Key Analysis with Composite Key Maximum Columns = 7. Then review Primary Key Analysis on the Multi-column tab. |
| Option C | Create a Virtual Column including only the 7 columns, select the Virtual Column and run Column Analysis. Then review Primary Key Analysis for the Virtual Column onthe Single column tab. |
| Option D | Create a Virtual Table including only the 7 columns, select the Virtual Table and run Multi-column Primary Key Analysis with Composite Key Maximum Columns = 1. Then review Primary Key Analysis on the Multi-column tab. |
| Correct Answer | C |