1. Question 1 In which phase of the data lifecycle do you establish the data you need, the amount of data you need, and how you intend to use the…
3. Question 3 Tools for ______________ break up a job into a series of logical steps which are monitored for completion and time to completion. 1 point Job-level Runtime…
4. Question 4 Database partitioning helps optimize databases for performance. It does this by: 1 / 1 point Dividing large tables into smaller individual tables Reducing inconsistencies and anomalies in data Tracking…
2. Question 2 You can perform partial matches of data values in a data column using: 1 / 1 point Average function Slicing a data set Count function Filtering patterns …
5. Question 5 Database normalization is a design technique that helps reduce inconsistencies and anomalies from data. 1 / 1 point True False Database normalization helps reduce inconsistencies that arise…
1. Question 1 What are some of the querying techniques you can apply to identify extreme values in a data column? 1 / 1 point Slicing a data set Maximum and Minimum…
5. Question 5 When you detect a value in your data set that is vastly different from other observations in the same data set, what would you report that as?…
2. Question 2 ___________ focuses on cleaning the database of unused data and reducing redundancy and inconsistency. 1 / 1 point Data Visualization Data Profiling Denormalization Normalization Correct Normalization cleanses the…
4. Question 4 When you’re combining rows of data from multiple source tables into a single table, what kind of data transformation are you performing? 1 / 1 point Normalization Joins Unions…
3. Question 3 OpenRefine is an open-source tool that allows you to: 1 / 1 point Enforces applicable data governance policies automatically Use add-ins such as Microsoft Power Query to identify issues…
