Microsoft Implementing Data Models and Reports with Microsoft SQL Server - 070-466 Exam Practice Test
You are designing a SQL Server Reporting Services (SSRS) report.
The report defines a single SQL Server data source and dataset.
You need to include additional data sourced from a Microsoft Azure SQL Database in the report.
What should you do?
The report defines a single SQL Server data source and dataset.
You need to include additional data sourced from a Microsoft Azure SQL Database in the report.
What should you do?
Correct Answer: C
You maintain SQL Server Analysis Services (SSAS) instances.
You need to configure an installation of PowerPivot for Microsoft SharePoint in a SharePoint farm.
Which tool should you use? (Each correct answer presents a complete solution. Choose all that apply.)
You need to configure an installation of PowerPivot for Microsoft SharePoint in a SharePoint farm.
Which tool should you use? (Each correct answer presents a complete solution. Choose all that apply.)
Correct Answer: B,D,E
You need to modify the Sales Regions hierarchy to meet the reporting requirements.
Which SSAS feature should you use?
Which SSAS feature should you use?
Correct Answer: D
HOTSPOT
You are developing a SQL Server Analysis Services (SSAS) cube that contains the data for a running team.
The data warehouse used by the cube contains the time durations of laps run by each runner on the team. The time durations are stored in seconds as an integer.
You need to build the following two measures in the cube:
* A measure named Measure1 that must contain the average time duration of the laps run by each runner.
* A measure named Measure2 that must contain the lap-time duration and the name of the runner who ran the fastest lap.
What should you do? To answer, select the appropriate Aggregation Function property for each measure in the answer area.
You are developing a SQL Server Analysis Services (SSAS) cube that contains the data for a running team.
The data warehouse used by the cube contains the time durations of laps run by each runner on the team. The time durations are stored in seconds as an integer.
You need to build the following two measures in the cube:
* A measure named Measure1 that must contain the average time duration of the laps run by each runner.
* A measure named Measure2 that must contain the lap-time duration and the name of the runner who ran the fastest lap.
What should you do? To answer, select the appropriate Aggregation Function property for each measure in the answer area.
Correct Answer:
Explanation:
Note: For Measure1 we use Average, and for Measure2 Min to get the fastest time.
You are developing a SQL Server Analysis Services (SSAS) tabular project that will be used by the finance, sales, and marketing teams.
The sales team reports that the model is too complex and difficult to use. The sales team does not need any information other than sales-related resources in the tabular model. The finance and marketing teams need to see all the resources in the tabular model.
You need to implement a solution that meets the needs of the sales team while minimizing development and administrative effort.
What should you do?
The sales team reports that the model is too complex and difficult to use. The sales team does not need any information other than sales-related resources in the tabular model. The finance and marketing teams need to see all the resources in the tabular model.
You need to implement a solution that meets the needs of the sales team while minimizing development and administrative effort.
What should you do?
Correct Answer: A
You need to deploy the StandardReports project at the end of the current business day.
What should you do? (Each correct answer presents a complete solution. Choose all that apply.)
What should you do? (Each correct answer presents a complete solution. Choose all that apply.)
Correct Answer: C,D
You are developing a SQL Server Reporting Services (SSRS) report for a company that has a subscription to a dataset from the Microsoft Azure Data Market.
The dataset permits flexible queries.
You need to choose the connection type for the data source.
Which connection type should you choose?
The dataset permits flexible queries.
You need to choose the connection type for the data source.
Which connection type should you choose?
Correct Answer: D
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?
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?
Correct Answer: C