070-466 無料問題集「Microsoft Implementing Data Models and Reports with Microsoft SQL Server」
You are developing a new SQL Server Reporting Services (SSRS) report in SQL Server Data Tools (SSDT).
The report contains tables, images, charts, page breaks, gauges, and indicators.
You need to ensure that the reports can be exported to Microsoft Excel and PDF formats and do not have any layout issues.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
The report contains tables, images, charts, page breaks, gauges, and indicators.
You need to ensure that the reports can be exported to Microsoft Excel and PDF formats and do not have any layout issues.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
正解：B
解答を投票する
You are designing a SQL Server Reporting Services (SSRS) report that sources data from a Microsoft Azure SQL Database database.
The report must display the value and status of a Key Performance Indicator (KPI).
Which report item should you use? (Each answer presents a complete solution. Choose all that apply.)
The report must display the value and status of a Key Performance Indicator (KPI).
Which report item should you use? (Each answer presents a complete solution. Choose all that apply.)
正解：B、D
解答を投票する
HOTSPOT
You create a new SharePoint site to store reports for the manufacturing department.
You need to recommend a solution to meet the security requirements for the sales department users and the manufacturing department users.
What should you recommend? To answer, select the appropriate group for the sales department users and the manufacturing department users in the answer area.
You create a new SharePoint site to store reports for the manufacturing department.
You need to recommend a solution to meet the security requirements for the sales department users and the manufacturing department users.
What should you recommend? To answer, select the appropriate group for the sales department users and the manufacturing department users in the answer area.
正解：
You deploy a tabular model in DirectQuery mode to a server named Server1. Server1 has SQL Server Analysis Services (SSAS) installed. The model uses a relational data source named DB1.
You need to ensure that Server1 passes the credentials of the current user browsing the model to DB1.
What should you do?
You need to ensure that Server1 passes the credentials of the current user browsing the model to DB1.
What should you do?
正解：A
解答を投票する
You are administrating a SQL Server Analysis Services (SSAS) tabular database.
You need to create a new role that allows its members to query data and to refresh data in the model.
Which permission should you use? (More than one answer choice may achieve the goal.
Select the BEST answer.)
You need to create a new role that allows its members to query data and to refresh data in the model.
Which permission should you use? (More than one answer choice may achieve the goal.
Select the BEST answer.)
正解：D
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
You are developing a Microsoft SQL Analysis Services (SSAS) multidimensional project A fact table named FactHouseSales has a measure column named Area. All values in the column are stored in square feet. Users must be able to analyze the area in different units.
You create a table named AreaUnit. Each row in the table consists of the unit name and a square feet conversion factor value.
You need to implement the area conversion in the project.
What should you do?
You create a table named AreaUnit. Each row in the table consists of the unit name and a square feet conversion factor value.
You need to implement the area conversion in the project.
What should you do?
正解：L
解答を投票する
A large manufacturing company has manufacturing plants in many states. Each state has a dedicated SQL Server instance that stores its manufacturing data. Each SQL Server instance is configured identically and all instances have identical database structures.
You are developing a daily report that summarizes information on manufacturing activity.
The report has the following requirements:
*It must have a stale name as one of the report parameters.
*It must provide a daily summary of manufacturing activity of a selected state.
*It must require minimal development and maintenance effort.
You need to develop the report to meet the requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
You are developing a daily report that summarizes information on manufacturing activity.
The report has the following requirements:
*It must have a stale name as one of the report parameters.
*It must provide a daily summary of manufacturing activity of a selected state.
*It must require minimal development and maintenance effort.
You need to develop the report to meet the requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
正解：D
解答を投票する
You are troubleshooting query performance for a SQL Server Analysis Services (SSAS) cube.
A user reports that a Multidimensional Expressions (MDX) query is very slow.
You need to identify the MDX query statement in a trace by using SQL Server Profiler.
Which event class should you use?
A user reports that a Multidimensional Expressions (MDX) query is very slow.
You need to identify the MDX query statement in a trace by using SQL Server Profiler.
Which event class should you use?
正解：B
解答を投票する
DRAG DROP
You have a single SQL Server 2008 R2 Analysis Services (SSAS) instance. You are planning to upgrade the instance to SQL Server 2014.
You need to import an existing PowerPivot workbook to create a tabular project.
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 have a single SQL Server 2008 R2 Analysis Services (SSAS) instance. You are planning to upgrade the instance to SQL Server 2014.
You need to import an existing PowerPivot workbook to create a tabular project.
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.)
正解：
Explanation:
Box 1:
Box 2:
Box 3:
Note:
* To create a new tabular model project from a PowerPivot for Excel file
* In SQL Server Data Tools, on theFilemenu, clickNew, and then clickProject.
(box 2)
* In theNew Projectdialog box, underInstalled Templates, clickBusiness Intelligence, and then clickImport from PowerPivot.(box 3)
* InName, type a name for the project, then specify a location and solution name, and then clickOK.
* In theOpendialog box, select the PowerPivot for Excel file that contains the model metadata and data you want to import, and then clickOpen.
Box 1:
* When creating a new tabular model project by importing from a PowerPivot workbook, the metadata that defines the structure of the workbook is used to create and define the structure of the tabular model project in SQL Server Data Tools. Objects such as tables, columns, measures, and relationships are retained and will appear in the tabular model project as they are in the PowerPivot workbook.
* Analysis Services provides three different approaches for creating a business intelligence semantic model: tabular, multidimensional, and PowerPivot. Tabular solutions use relational modeling constructs such as tables and relationships for modeling data, and the xVelocity in-memory analytics engine for storing and calculating data