Synapse

Operational data (source data) is stored in what kind of datastore?

• OLAP

• OLTP

• SMTP

• FTP

An .................. system is market-oriented and is used for data analysis by knowledge workers, including managers, executives, and analysts.

• Both of the above

• OLTP

• OLAP

• None of the above

OLAP stands for...

• Online Analytical Processing

• Online Advanced Processing

• Online Advanced Preparation

• Online Analytical Performance

What are the applications of OLAP?

• Business reporting for sales, marketing

• Budgeting

• Forecasting

• All of the above

The important aspect of the data warehouse environment is that data found within the data warehouse is...

• subject-oriented

• time-variant

• integrated

• All of the above

Synapse is...

• a junction between two nerve cells

• an analytics service that brings together data warehousing and Big Data analytics

• a synonym for 'synergy'

Synapse supports ... tables.

• Heap

• Columnstore index

• Clustered index

• All of the above

A rowgroup is a group of rows that are compressed into columnstore format at the same time. What is the maximum number of rows per row group?

• 100.000

• 1.048.576

• 512

• 5.242.880

In Synapse, rows in a distributed table are stored across ... distributions.

• 60

• 64

• 128

• 24

A ... distributed table distributes table rows across the Compute nodes by using a deterministic function to assign each row to one distribution.

• heap

• hash

• round-robin

• replicate