READ Free Dumps For IBM- C2090-423
Question ID 12756 | You are trying to identify a multi-column primary key in a table of 50 million records. What |
Option A | None, you must always assess full volume of data. |
Option B | Use a data sample; apply regression analysis to identify statistically likely candidates; apply duplicate check. |
Option C | Use a data sample; limit the test to specific columns at one time; incrementally increase the number of possible column combinations. |
Option D | Use a data sample; apply functional dependency analysis to remove dependent columns; incrementally increase the number of possible column combinations. |
Correct Answer | C |
Question ID 12757 | You are evaluating a Date of Birth field in your customer table. Which of the following |
Option A | Ensure no null values; Evaluate skews in frequency; Ensure consistency in format. |
Option B | Ensure only binary values; Evaluate skews in frequency; Ensure no special characters. |
Option C | Ensure no skews in frequency; Ensure only numeric values; Evaluate as a primary key. |
Option D | Ensure all unique values; Evaluate out-of-range in frequency; Ensure consistency in format. |
Correct Answer | A |