0% 0 CS614 Final Term Quiz 5 1 / 22 Which of the following is not a task of Data Transformation? Enrichment Summarization Conversion Full Data Refresh 2 / 22 Which of the following is not a technique of "De-Normalization" ? ER Modeling Pre-joining Splitting Tables Adding Redundant Columns 3 / 22 Which of the following is not an "Orr's Law of Data Quality"? Data will be no better than its most stringent use!" Data duplication can be harmful for the organization!" Data quality is a function of its use, not its collection Data that is not used cannot be correct!" 4 / 22 Which of the following activity/activities is/are part of project planning phase in Kimballs DWH development approach? Establish the preliminary scope and justification All of the given options Assess organization's readiness for a data warehouse initiative Obtain resources 5 / 22 Waterfall model is appropriate when Requirements are clearly defined When the deadline is strict When resources are limited When budget is low 6 / 22 Which of the following is/are example(s) of static attributes? All of the given options Employee Blood Group Employee Name Employee Date of Birth 7 / 22 Which one of the following is not a technique of "Change Data Capture? in currently used Modem Source Systems? Triggers Timestamps Partitioning Dimensional Modeling 8 / 22 Which of the following is not an activity of Data Quality Analysis Project? Measure" Analyze" "Define" "Compression" 9 / 22 To identify the __________________ required we need to perform data profiling Complexity Cost Time Degree of Transformation 10 / 22 With data mining, the best way to accomplish this is by setting aside some of your data in a vault to isolate it from the mining process; once the mining is complete, the results can be tested against the isolated data to confirm the model's _______. Integrity Security Validity None of above 11 / 22 Which of the following is NOT one of the activities of ?Maintenance and Growth? phase in Kimball?s DWH development approach? Technical education Interface Deployment Education Program Support 12 / 22 Waterfall is a/an ______ model Simple linear sequential Rapid development Iterative Object oriented 13 / 22 Which of the following activity executes parallel with all other activities in Kimball?s DWH development approach? Project Planning Deployment Requirement elicitation Project management 14 / 22 Which of the following is NOT one of the advantages of changed data capture (CDC) technique? No incremental on-line I/O required for log tape Flat files are not required Extraction of changed data occurs immediately Limited query interface is required for data extraction 15 / 22 We should follow a proper ____________ cycle to implement a change even if it is smaller one. Development -> Production -> QA Production->Development -> QA Production -> QA ->Development Development -> QA -> Production 16 / 22 To measure or quantify the similarity or dissimilarity, different techniques are available. Which of the following option represent the name of available techniques? Both Pearson correlation and Euclidean distance Pearson correlation is the only technique None of these Euclidean distance is the only technique 17 / 22 With data mining, the best way to accomplish this is by setting aside some of your data in a ________ to isolate it from the mining process; once the mining is complete, the results can be tested against the isolated data to confirm the model's validity. Disk Cell Folder Vault 18 / 22 Which statement is true for De-Normalization? Redundant data is a performance liability at both query time and update time. Redundant data is a performance benefit at query time, but is a performance liability at update time. Redundant data is a performance benefit at both query time and update time. Redundant data is a performance liability at query time, but is a performance benefit at update time. 19 / 22 Which of the following is NOT one of the methodologies for Data Warehouse project development? User Driven System Driven Goal Driven Data Driven 20 / 22 Which of the following is NOT one of the examples of dynamic attributes? None of the given options Air pressure Date of Birth cnfim not Daily Sale 21 / 22 Which of the following is NOT one of the top-10 mistakes that should be avoided during DWH development? Not interacting directly with end user Training the users with dummy data and considering it success Not being an accommodating person Isolating IT support people from business users 22 / 22 Users do not care, how advance the front end of your DWH is, what they care is that: Tables should be properly de-normalized At least star or snow flake schema should be implementing Proper partitioning technique should be used They should get information in timely manner Provide Your Information Your score is The average score is 0% LinkedIn Facebook Twitter 0% Restart quiz Send feedback Share on facebook Facebook Share on twitter Twitter Share on whatsapp WhatsApp PrevCS614 Final Term Quiz 4 CS615 Final Term Quiz 1Next
