Data Pipelines — Learn free

Self-check

Questions 1–10 of 10

1. In simple terms, what is a Data Pipeline?
Question 1A. A set of rules for classifying dataB. The travelling of data from one point to anotherC. A database backup mechanismD. A tool for masking sensitive dataE. A dashboard for monitoring servers
2. In the Pull data processing mechanism, which system initiates the movement of data?
Question 2A. The source system pushes data to the targetB. A third-party broker moves the dataC. Data flows continuously with no initiatorD. The target system pulls data from the source systemE. The BI tool requests data from the warehouse
3. By what other name is Bulk Loading known?
Question 3A. Data DumpB. Data StreamC. Data DeltaD. Data SnapshotE. Data Trickle
4. What does CDC Loading process?
Question 4A. The whole dataset every timeB. Only the metadata of the sourceC. Only the data that has changed at the sourceD. A random sample of the sourceE. Only deleted records
5. Which of the following is an example of Batch processing in a Data Pipeline?
Question 5A. Moving a post the moment it is likedB. Streaming CCTV footage second by secondC. Pushing a card transaction instantlyD. Sending an OTP on paymentE. Starting processing after 24 hours or perhaps 12 hours
6. Which example illustrates Real-Time (event-based) processing in a Data Pipeline?
Question 6A. A nightly load of the sales tableB. A post being LIKED on Facebook or LinkedIn moving immediately to downstream systemsC. A weekly data dump to the warehouseD. A monthly financial closeE. A quarterly data archive
7. What effect does better hardware have on Batch processing?
Question 7A. It removes the need for a data pipelineB. It makes bulk loading impossibleC. It converts batch into streaming automaticallyD. It allows the batch time duration to be made smallerE. It has no effect on batch duration
8. Which of the following is NOT one of the named Data Processing Mechanisms?
Question 8A. PushB. PullC. MergeD. StreamingE. None of these; all are named mechanisms
9. What is the likely future for an organisation that builds Data Pipelines without Data Lineage, a Data Catalog and Data Governance standards?
Question 9A. A Data SwampB. A Data VaultC. A Data MartD. Faster decision makingE. Lower hardware costs
10. Why does CDC play a vital role in supporting Real-Time processing from OLTP systems?
Question 10A. Because OLTP systems cannot be queried directlyB. Because CDC converts data into batchesC. Because CDC encrypts data before transferD. Because CDC replaces the need for a data warehouseE. Because in real time a very small size of data is expected to travel