Reverse ETL — Learn free

Self-check

Questions 1–10 of 10

1. When is the Business Analytics cycle from OLTP to OLAP considered complete?
Question 1A. When data reaches the Data WarehouseB. When the Machine Learning model is trainedC. When top management sees the dashboardD. Once Reverse ETL has been performedE. When the campaign message is sent to customers' mobiles
2. In the social media example, what constitutes Reverse ETL?
Question 2A. Writing back to social media in the format it acceptsB. Pulling all kinds of data from social mediaC. Storing social media posts in a Data LakeD. Running sentiment analysis on postsE. Deleting old social media data
3. What does Business Analytics support?
Question 3A. Network Security SystemsB. Payroll SystemsC. Decision Support Systems (DSS)D. Version Control SystemsE. Ticketing Systems
4. In the sales campaign example of Reverse ETL, what can the customer representative see when opening the source system?
Question 4A. The Machine Learning model's accuracy scoreB. The Data Lake storage costC. The list of every campaign ever runD. The customer's credit card numberE. That a campaign was sent to the buyer's mobile but the buyer never reacted to it
5. Where must the output of a campaign be sent for the analytics cycle to end?
Question 5A. To the Data Warehouse onlyB. To the source systemsC. To an external archiveD. To the marketing team's spreadsheetE. To the Machine Learning model
6. What must Reverse ETL follow before writing back into a source system?
Question 6A. The Data Warehouse star schemaB. The BI tool's report layoutC. The source system's own OLTP data modelD. The Data Lake folder structureE. The social media API only
7. Which of the following statements about Reverse ETL is NOT correct?
Question 7A. Reverse ETL is simply copying and pasting the analytics output into the source systemB. Reverse ETL completes the Business Analytics cycleC. Reverse ETL can mean writing back to social media in the format it acceptsD. Reverse ETL lets source-system users see the outcome of campaignsE. Reverse ETL must respect the source system's OLTP data model
8. Once data has moved into stores such as a Data Lake or Data Warehouse, how are analytics performed for prediction or forecasting?
Question 8A. By manual spreadsheet reviewB. By re-running the OLTP transactionsC. By archiving the dataD. By reverse engineering the source schemaE. Using Data Science practices such as Machine Learning and Deep Learning
9. What common misconception about the Business Analytics cycle does the concept of Reverse ETL correct?
Question 9A. That data must be masked before analyticsB. That the cycle is complete once management decides to initiate campaigns based on the analyticsC. That Data Lakes replace Data WarehousesD. That OLTP systems cannot feed OLAP systemsE. That Machine Learning is optional
10. Which of the following are named as OLAP-side datastores in the Business Analytics cycle?
Question 10A. Web servers and load balancersB. Firewalls and proxiesC. Email servers and file sharesD. Data Warehouses, Data Marts, Data Lakes, Data Lake Houses and Data VaultsE. Spreadsheets and word processors