Azure Data Fundamentals

Objects in which things about data should be captured and stored are called: ____________.

• Tables
• Entities
• Rows
• Columns

You need to process data that is generated continuously and near real-time responses are required. You should use _________.

• Batch Processing
• Scheduled data processing
• buffering and processing
• streaming data processing

Extract, Transform, Load (ETL)

• Optimize data privacy
• Provide support for Azure Data Lake
• Manage Large volumes of data

Extract, Load, Transform (ELT)

• Optimize data privacy
• Provide support for Azure Data Lake
• Manage Large volumes of data

The technique that provides recommended actions that you should take to achieve a goal or target is called _____________ analytics

• Descriptive
• Diagnostic
• Predictive
• Prescriptive

Tables

• Create relationships
• Improve processing speed for data searches
• store instances of entities as rows
• display data from predefined queries

Indexes

• Create relationships
• Improve processing speed for data searches
• store instances of entities as rows
• display data from predefined queries

Views

• Create relationships
• Improve processing speed for data searches
• store instances of entities as rows
• display data from predefined queries

Keys

• Create relationships
• Improve processing speed for data searches
• store instances of entities as rows
• display data from predefined queries

The process of splitting an entity into more than one table to reduce data redundancy is called: _____________.

• deduplication
• denormalization
• normalization
• optimization