Data Aggregation — Learn free

Self-check

Questions 1–10 of 10

1. What is Data Aggregation?
Question 1A. Reducing the number of rows returned by a queryB. Converting details into a summarised formatC. Matching records across different systemsD. Converting data into a single standard formatE. Validating data against its source
2. Which everyday example illustrates Data Aggregation in *I Am Datapedia!*?
Question 2A. Asking for a Wi-Fi passwordB. Keeping a passwords inventoryC. Answering 'there are 12 months' instead of naming every month of the yearD. Checking the country a product was made inE. Moving a desktop to another office
3. In the installations example, what would you send your manager instead of the detailed list?
Question 3A. A list of every device serial numberB. A summarised report showing 6 iOS and 3 Android installationsC. A synthetic datasetD. The raw log fileE. A geocoded map of every installation
4. Which aggregation functions are listed as ISO standard?
Question 4A. COUNT, SUM, AVG, MIN, MAXB. STDEV, VAR, VARP, CHECKSUM_AGG, GROUPINGC. DISTINCT, GROUP BY, ORDER BY, WHERE, JOIND. STRING_AGG, COUNT_BIG, GROUPING_ID, STDEVP, APPROX_COUNT_DISTINCTE. ROUND, FLOOR, CEIL, ABS, MOD
5. Which of the following is listed among the other, non-ISO aggregation functions?
Question 5A. SUMB. AVGC. MIND. STRING_AGGE. COUNT
6. Which of the following is NOT named as an aggregation function?
Question 6A. APPROX_COUNT_DISTINCTB. CHECKSUM_AGGC. COUNT_BIGD. GROUPING_IDE. SUBSTRING
7. Where are aggregation functions normally used, according to *I Am Datapedia!*?
Question 7A. In databases or data stores, to summarise stored dataB. In network routersC. In word processorsD. In CCTV camerasE. In email clients
8. How widely is Data Aggregation used, according to the author?
Question 8A. Only by data scientistsB. Only in cloud systemsC. Everywhere in daily life, whether in the office or at homeD. Only in financial reportingE. Rarely, since Big Data
9. Which pair of functions both belong to the list of other aggregation functions concerned with variance and standard deviation?
Question 9A. MIN and MAXB. AVG and COUNT_BIGC. COUNT and SUMD. STDEV and VARE. GROUPING and STRING_AGG
10. Which function computes the average and is listed as an ISO standard aggregation function?
Question 10A. GROUPINGB. MEANC. MEDIAND. STDEVE. AVG