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…
5. Question 5 Security Monitoring and Intelligence systems: 1 point Ensure users access information based on their role and privileges Ensure only authorized devices can connect to…
1. Question 1 Which one of these steps is an intrinsic part of the “Data Processing Layer” of a data platform? 1 point Read data in batch or streaming…
3. Question 3 What is the role of “Network Access Control” systems in the area of network security? 1 / 1 point To ensure attackers cannot tap into data while it is…
4. Question 4 ____________ ensures that users access information based on their roles and the privileges assigned to their roles. 1 / 1 point Security Monitoring Firewalls Authentication Authorization Correct One…
2. Question 2 Systems that are used for capturing high-volume transactional data need to be designed for high-speed read, write, and update operations. 1 / 1 point True False Correct High-speed…
