Knowledge check

Completed

Choose the best response for each of the questions below.

Check your knowledge

1.

Geoffrey is a data modeler at Adventure Works who developed a DirectQuery model that connects to the data warehouse. To improve the query performance of higher-grain sales queries, Geoffrey added an import aggregation table. What else should Geoffrey do to improve query performance of the higher-grain queries?

Set related dimension tables as aggregation tables.

Set related dimension tables to dual storage mode.

Set related dimension tables to import storage mode.

2.

Breana is a data modeler at Adventure Works who developed a manufacturing model, which is an import model. Breana needs to ensure that manufacturing reports deliver real-time results. Which type of table should Breana create?

Aggregation table.

Hybrid table.

Partitioned table.

3.

Mousef is a business analyst at Adventure Works who wants to create a new model by extending the sales dataset, which is delivered by IT. Mousef wants to add a new table of census population data sourced from a web page. Which model framework should Mousef use?

Composite.

DirectQuery.

Live connection.

You must answer all questions before checking your work.