1er parcial Data Analytics 2021-1S

Prescriptive analytics is intended to:

• Provide insights into the causes of the current scenario

• Obtain a general data-driven description on the current strategic position of the organization

• Help decision-makers to select alternativestrategic pathways according to target outcomes

• Provide predictions and forecasts of alternative strategic decision outcomes

True or false: Data integration is a component of ETL

• True

• False

True or False: most of the Data Analytics resources are spent in ETL development and execution

• True

• False

It is NOT a key aspect of the implementation of every ETL task:

• Robust exception management

• Detailed logging and error reporting

• Detailed user interfaces

• Automated process resuming/restarting

True or False: Data Lakes are the best alternative for unstructured data

• True

• False

Which is the best choice to ensure the application of information security policies?

• ELT

• ETL

• Both of them are equivalent in terms of information security

True of False: Staging could be optional according to the order selected for the Extraction, Transformation and Loading processes

• True

• False

The identification of new/updated records in the data source is a responsability of

• The Extraction process

• The Transformation process

• The mapping stage

• The profiling stage

The usage of a staging area support processes of

• Extraction

• Both of them

• Transformation

• None of them

True or False: CSV, JSON and XML support structured data

• True

• False