70-470 無料問題集「Microsoft Recertification for MCSE: Business Intelligence」
You are designing a partitioning strategy for a SQL Server Analysis Services (SSAS) cube.
New data is loaded in real-time into the data warehouse that feeds the cube. Between 10 million and 15 million rows of data are loaded into the main fact table each day from a Microsoft Azure SQL Database.
You have the following requirements:
- Maximize cube query performance during business hours. - Ensure that data is available in the cube as soon as possible after it is loaded into the data warehouse.
You need to design a partitioning strategy that meets the requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
New data is loaded in real-time into the data warehouse that feeds the cube. Between 10 million and 15 million rows of data are loaded into the main fact table each day from a Microsoft Azure SQL Database.
You have the following requirements:
- Maximize cube query performance during business hours. - Ensure that data is available in the cube as soon as possible after it is loaded into the data warehouse.
You need to design a partitioning strategy that meets the requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
正解：C
解答を投票する
You deploy a PowerPivot workbook to a PowerPivot Gallery in a Microsoft SharePoint site. Workbook data comes from two different sources: Source A and Source B.
The workbook contains five tables with a total of 20 million rows from Source A, and three small lookup tables from Source B.
Data from Source A is updated throughout the day. Data from Source B is updated at 3:00 P.M.
You have the following requirements:
- Refresh the PowerPivot workbook with updated lookup data as soon as possible.
- Minimize load on the source systems and the SharePoint environment during business hours.
- Minimize user involvement in the data refresh process.
You enable automatic data refresh for the workbook.
You need to configure a data refresh schedule for the workbook that meets the requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
The workbook contains five tables with a total of 20 million rows from Source A, and three small lookup tables from Source B.
Data from Source A is updated throughout the day. Data from Source B is updated at 3:00 P.M.
You have the following requirements:
- Refresh the PowerPivot workbook with updated lookup data as soon as possible.
- Minimize load on the source systems and the SharePoint environment during business hours.
- Minimize user involvement in the data refresh process.
You enable automatic data refresh for the workbook.
You need to configure a data refresh schedule for the workbook that meets the requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
正解：E
解答を投票する
You are developing a BI Semantic Model (BISM) that retrieves data from several sources including a SQL Azure database and an OData data feed. The model will be deployed to a server with significantly more memory than the total size of the source data.
You have the data feed URL, which you will use when developing the model in SQL Server Data Tools (SSDT).
The model must meet the following requirements:
- Maximize performance
- Data latency of up to one month is acceptable
You need to choose a project type and a data access mode to meet the requirements.
What should you do?
You have the data feed URL, which you will use when developing the model in SQL Server Data Tools (SSDT).
The model must meet the following requirements:
- Maximize performance
- Data latency of up to one month is acceptable
You need to choose a project type and a data access mode to meet the requirements.
What should you do?
正解：C
解答を投票する
DRAG DROP
You are developing a SQL Server Analysis Services (SSAS) cube.
You need to reuse a measure group from a different database.
In SQL Server Data Tools (SSDT), 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.)
You are developing a SQL Server Analysis Services (SSAS) cube.
You need to reuse a measure group from a different database.
In SQL Server Data Tools (SSDT), 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.)
正解：
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?
正解：B
解答を投票する
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?
正解：C
解答を投票する
You execute the SalesbyCategory report and receive the following error message:
"Members, tuples, or sets must use the same hierarchies in the function."
You need to ensure that the query executes successfully.
Which two actions should you perform? Each correct answer presents part of the solution.
"Members, tuples, or sets must use the same hierarchies in the function."
You need to ensure that the query executes successfully.
Which two actions should you perform? Each correct answer presents part of the solution.
正解：A
解答を投票する
You work in the Business Intelligence (BI) department of a multinational company.
The company has requested a new corporate BI solution that meets the following requirements:
The solution must use SQL Server Analysis Services (SSAS).
The model must incrementally add 10 million fact rows per month.
The model must be translated to English, French, or Spanish based on users'
locale.
---
- The model must be able to contain the most recent 36 months of data.
You need to select the appropriate model type and partitioning strategy to meet the requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
The company has requested a new corporate BI solution that meets the following requirements:
The solution must use SQL Server Analysis Services (SSAS).
The model must incrementally add 10 million fact rows per month.
The model must be translated to English, French, or Spanish based on users'
locale.
---
- The model must be able to contain the most recent 36 months of data.
You need to select the appropriate model type and partitioning strategy to meet the requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
正解：D
解答を投票する
You are designing a self-service reporting solution based on published PowerPivot workbooks.
The reporting solution must allow users to perform the following tasks:
---
Easily create reports.
Create report queries by dragging and dropping fields.
Create presentation-quality reports with minimal effort.
You need to choose a reporting tool that meets the requirements.
Which reporting tool should you choose? (More than one answer choice may achieve the goal. Select the BEST answer.)
The reporting solution must allow users to perform the following tasks:
---
Easily create reports.
Create report queries by dragging and dropping fields.
Create presentation-quality reports with minimal effort.
You need to choose a reporting tool that meets the requirements.
Which reporting tool should you choose? (More than one answer choice may achieve the goal. Select the BEST answer.)
正解：B
解答を投票する