| Exam Code/Number: | 70-470Join the discussion |
| Exam Name: | Recertification for MCSE: Business Intelligence |
| Certification: | Microsoft |
| Question Number: | 316 |
| Publish Date: | Oct 09, 2026 |
|
Rating
100%
|
|
You are developing a BI Semantic Model (BISM) that will be used to analyze complex budgeting and forecast data sourced from a financial database. The model will be deployed to a server with 28 GB of RAM.
The source data, located in a SQL Server data warehouse, is currently using 15 terabytes of disk space and is doubling in size every month. The model will be queried by staff in the accounting department by using Microsoft Excel 2010.
You need to ensure the highest query performance and scalability for the accounting department queries.
Which project type should you choose?
You are deploying the Research model.
You need to ensure that the data contained in the model can be refreshed.
What should you do?
You need to configure data refresh for the Manufacturing Performance PowerPivot workbook.
What should you do? (Each correct answer presents part of the solution. Choose ail that apply.)
You need to create a measure for DOD sales.
What should you do? (Each correct answer presents part of the solution. Choose all that apply.)
DRAG DROP
You are developing a SQL Server Reporting Services (SSRS) report that sources data from a SQL Azure database and a SQL Server Analysis Services (SSAS) cube. The cube contains a date dimension and other dimensions. The report design includes two report parameters named StartDate and FinishDate as shown in the following diagram.
The Data Type property of the parameters is set to Date/Time.
You need to create the dataset based on the SSAS cube. You also need to ensure that the dataset is filtered by the existing report parameters.
Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)
