Pertemuan 5 - Azure Data Engineer

In which order should you load tables in the data warehouse?

• Staging tables, then dimension tables, then fact tables

• Staging tables, then fact tables, then dimension tables

• Dimension tables, then staging tables, then fact tables

Which command should you use to load a staging table with data from files in the data lake?

• COPY

• LOAD

• INSERT

When a customer changes their phone number, the change should be made in the existing row for that customer in the dimension table. What type of slowly changing dimension does this scenario require?

• Type 0

• Type 1

• Type 2

Which workload management feature influences the order in which a request gets access to resources?

• Workload classification

• Workload importance

• Workload isolation

One of functions to generate an incrementing row number ...

• ROW_NUMBER

• IDENTITY

• PRIMARY KEY

What would be the best approach to investigate if the data at hand is unevenly allocated across all distributions?

• Grouping the data based on partitions and counting rows with a T-SQL query

• Using DBCC PDW_SHOWSPACEUSED to see the number of table rows that are stored in each of the 60 distributions

• Monitor query speeds by testing the same query for each partition

Dedicated SQL pool workload management in Azure Synapse consists of three high-level concepts, except:

• Workload Importance

• Workload Clustering

• Workload Isolation

Resources reserved in a workload group are held exclusively for that workload group to ensure execution.

• Workload classification

• Workload importance

• Workload isolation

... provides you with personalized messages that provide information on best practices to optimize the setup of your Azure services.

• Azure Services

• Azure Synapse Link

• Azure Advisor

The logic for 'Leo' only to access the columns specified for the department he works in, is a logic that is located in the database tier, rather than on the application level data tier.

• Column level security

• Row level security