Data Filtering — Learn free

Self-check

Questions 1–10 of 10

1. What is Data Filtering?
Question 1A. Removing duplicate columns from a tableB. Reducing the number of rows while pulling data from a tableC. Converting unstructured data into structured dataD. Encrypting rows before they leave the databaseE. Summarising detailed rows into totals
2. Why is a filter mandatory on every query run in the cloud?
Question 2A. Because cloud databases cannot return more than a fixed number of rowsB. Because cloud resources are limited and cannot be increasedC. Because each query is attached to a dollar value, so filtering keeps resource utilisation to a minimumD. Because unfiltered queries are blocked by network securityE. Because cloud tables have no primary keys
3. In an on-premises system, what can happen when someone runs a query without a filter?
Question 3A. The query is automatically given more RAMB. The query holds onto all the available resources and locks the rest of the queriesC. The query is billed at a higher rateD. The query is redirected to the development environmentE. The query returns only the latest month
4. Why is increasing compute resources on-premises slow?
Question 4A. Because a complete buying cycle through procurement is needed, which takes monthsB. Because the operating system must be reinstalledC. Because vendors only ship hardware once a yearD. Because the data must be filtered firstE. Because cloud approval is required
5. In which environment do developers have the liberty to run any kind of query, on-premises?
Question 5A. ProductionB. UATC. Development, because the data size is limited and staticD. The semantic layerE. The staging zone
6. Which default filters are commonly applied to KPIs on dashboards and reports?
Question 6A. Show all history for all locationsB. Show only data that failed validationC. Show only rows with null valuesD. Show only the latest month, a specific location or a particular type of data elementE. Show only data from development
7. What is the process of filtering and cleaning data before running models called?
Question 7A. Data CurationB. Data SyndicationC. Data ProfilingD. Data WranglingE. Data Aggregation
8. Who normally filters and cleans data for Data Citizens, and why?
Question 8A. Data Citizens themselves, because they write SQLB. Top management, because they own the dataC. Auditors, for complianceD. External syndication companiesE. Data Engineers, because Data Citizens use low-code and no-code drag-and-drop tools
9. Which datasets made filtering a basic requirement for storing and processing semi- and unstructured data?
Question 9A. Social media, CCTV and audio datasetsB. Payroll and HR dataC. Reference tables and lookupsD. Data dictionary entriesE. Development test fixtures
10. Which chain of consequences follows from an unfiltered query on limited on-premises resources?
Question 10A. Data drift and model retrainingB. Higher cloud bills and automatic scalingC. More accurate reports but slower dashboardsD. Duplicate rows and broken foreign keysE. Delayed datasets, delayed decisions, lost business opportunities and losses