Microsoft
70-768 · Question #69
You are developing a tabular Business Intelligence Semantic Model (BISM) database based on a SQL Server database. In the data source, the FactInternetSales table is partitioned by month. Data from…
The correct answer is D. Process the latest FactInternetSales model table partition, the DimProduct table, and the. See the full explanation below for the reasoning.
Question
You are developing a tabular Business Intelligence Semantic Model (BISM) database based on a SQL Server database. In the data source, the FactInternetSales table is partitioned by month. Data from the current month has been updated and new data has been inserted in the FactInternetSales table, in the DimProduct table, and in the DimCustomer table. In the model, the FactInternetSales table is also partitioned by month. You need to ensure that the model has the most recent data while minimizing the processing time. What should you do?
Options
- AProcess the latest FactInternetSales model table partition, the DimProduct table, and the
- BProcess the latest FactInternetSales model table partition, the DimProduct table, and the
- CProcess the latest FactInternetSales model table partition, the DimProduct table, and the
- DProcess the latest FactInternetSales model table partition, the DimProduct table, and the
- EProcess the latest FactInternetSales model table partition, the DimProduct table, and the
How the community answered
(49 responses)- A2% (1)
- B4% (2)
- C8% (4)
- D84% (41)
- E2% (1)
Community Discussion
No community discussion yet for this question.