最新的Microsoft Implementing Data Models and Reports with Microsoft SQL Server - 70-466免費考試真題
You need to ascertain why Marc did not receive his reports.
What should you do?
What should you do?
正確答案: B
You are developing a BI Semantic Model (BISM) based on a simple and small dataset sourced from SQL Server. The data size and complexity of the data relationships will not change. The model will be used to produce reports in Power View.
You need to use an appropriate project type.
Which project types should you use? (Each answer presents a complete solution. Choose all that apply.)
You need to use an appropriate project type.
Which project types should you use? (Each answer presents a complete solution. Choose all that apply.)
正確答案: A,B,D
說明：（僅 Fast2test 成員可見）
You are managing a SQL Server Reporting Services (SSRS) instance.
A website must pass credentials to the local security authority for Reporting Services.
You need to configure Reporting Services to issue a challenge/response when a connection is made without credentials.
Which authentication type should you configure in the RSReportServer.config file?
A website must pass credentials to the local security authority for Reporting Services.
You need to configure Reporting Services to issue a challenge/response when a connection is made without credentials.
Which authentication type should you configure in the RSReportServer.config file?
正確答案: D
說明：（僅 Fast2test 成員可見）
You need to configure SSRS to meet the maximum number of snapshots requirement.
What should you do? (Each answer presents a complete solution. Choose all that apply.)
What should you do? (Each answer presents a complete solution. Choose all that apply.)
正確答案: A,D
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.)
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.)
正確答案:
Explanation:
Box 1:
Box 2:
Box 3:
Note:
* In Reporting Services, a dataset is based on an existing a data source. A dataset specifies a query, query parameters, filters, and a field collection. You can also specify data options, such as case, collation, kanatype, width, and accent, for the data retrieved from the data source. For more information, see Understanding Report Datasets.
To create a dataset, you must have defined an embedded or shared data source.
* When you deploy Reporting Services, a set of data processing extensions are automatically installed and registered on both the report authoring client and on the report server to provide access to a variety of data source types . SQL Server 2008 Reporting Services (SSRS) installs the following data source types: Microsoft SQL Server, Microsoft SQL Server Analysis Services, Oracle, SAP NetWeaver BI, Hyperion Essbase, Teradata, OLE DB, ODBC, and XML.
* In the Report Data pane, right-click on a dataset created from a SQL Server Analysis Services data source type, and then clickQuery. The MDX query designer opens in Design mode.
* Drag a dimension to the filter area and drop it on the first cell in
theDimensioncolumn.
* In theHierarchycolumn, choose a value from the drop-down list.
* In theOperatorcolumn, choose an operator for the drop-down list.
* In theFilter Expressioncolumn, select individual values from the drop-down list, or click theAllmember to choose all values.
* In theParameterscolumn, select the check box to create a report parameter.
* ClickRun.
* To define a query parameter in MDX in Design modeAfter you run the query, clickDesign on the toolbar to toggle to Query mode to view the MDX query that was created. Do not change the query text in Query mode if you want to continue to use Design mode to develop the query. ClickDesignto toggle back to Design mode.
* Click OK.
* In the Report Data pane, right-click the name of the data source, and then clickAdd Dataset. TheQuerypage of theDataset Propertiesdialog box opens.
* InName, type a name for the dataset or accept the default name.
* In Data source, select the name of an existing shared data source, or click New to create a new embedded data source.
* Select a Query type option. Options vary depending on the data source type.
* In Query, type the query, stored procedure, or table name. Alternatively, click Query Designer to open the graphical or text-based query designer tool, or Import to import the query from an existing report.
* To create a datasetIn a few cases, the field collection specified by the query can only be determined by running the query on the data source. For example, a stored procedure may return a variable set of fields in the result set. Click Refresh Fields to run the query on the data source and retrieve the field names that are needed to populate the dataset field collection in the Report Data pane. The field collection appears under the dataset node after you close the Dataset Properties dialog box.
* In Timeout, type the number of seconds that the report server waits for a response from the database. The default value is 0 seconds. When the time out value is 0 seconds, the query does not time out.
* Click OK.
The dataset and its field collection appear in the Report Data pane under the data source node.
After you deploy the RegionalSales report, users report that they cannot see product data when they receive the reports by email.
You need to ensure that the sales department managers can see all of the data.
In the report, you update the Hidden property of each group.
What should you do next?
You need to ensure that the sales department managers can see all of the data.
In the report, you update the Hidden property of each group.
What should you do next?
正確答案: A
說明：（僅 Fast2test 成員可見）
You are developing a SQL Server Reporting Services (SSRS) sales summary report.
The report header consists of several images.
You need to ensure that the header of the report is hidden when a user exports the report to PDF format.
Which Hidden property expression should you use for the report header? {More than one answer choice may achieve the goal. Select the BEST answer.)
The report header consists of several images.
You need to ensure that the header of the report is hidden when a user exports the report to PDF format.
Which Hidden property expression should you use for the report header? {More than one answer choice may achieve the goal. Select the BEST answer.)
正確答案: C
DRAG DROP
You are developing a SQL Server PowerPivot model to monitor the rate of production of defective products.
The PowerPivot model contains many tables. The FactProduction table is configured as shown in the following diagram.
The model requires a key performance indicator (KPI) named Defective Units to measure the rate of production of defective units. The rate of production of defective units is calculated by dividing the sum of the Defects column by the sum of the Units column.
The KPI has the following requirements.
* If the rate of production of defective products equals or exceeds 5% then the KPI must report a status of off target (red).
* If the rate of production of defective products is less than 5% and equals or exceeds 2% then the KPI must report a status of slightly off target (yellow).
* If the rate of production of defective products less than 2% then the KPI must report a status of on target (green).
You need to develop the KPI to meet the requirements.
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 PowerPivot model to monitor the rate of production of defective products.
The PowerPivot model contains many tables. The FactProduction table is configured as shown in the following diagram.
The model requires a key performance indicator (KPI) named Defective Units to measure the rate of production of defective units. The rate of production of defective units is calculated by dividing the sum of the Defects column by the sum of the Units column.
The KPI has the following requirements.
* If the rate of production of defective products equals or exceeds 5% then the KPI must report a status of off target (red).
* If the rate of production of defective products is less than 5% and equals or exceeds 2% then the KPI must report a status of slightly off target (yellow).
* If the rate of production of defective products less than 2% then the KPI must report a status of on target (green).
You need to develop the KPI to meet the requirements.
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:
* (Step 1, step 2): The model requires a key performance indicator (KPI) named Defective Units to measure the rate of production of defective units. The rate of production of defective units is calculated by dividing the sum of the Defects column by the sum of the Units column.
* Step 3: The KPI has the following requirements.
*If the rate of production of defective products equals or exceeds 5% then the KPI must report a status of off target (red).
*If the rate of production of defective products is less than 5% and equals or exceeds 2% then the KPI must report a status of slightly off target (yellow).
*If the rate of production of defective products less than 2% then the KPI must report a status of on target (green).
You need to configure the partition storage settings to support the reporting requirements.
Which partition storage setting should you use?
Which partition storage setting should you use?
正確答案: B
You develop a SQL Server Analysis Services (SSAS) tabular project. The tabular model loads data from a SQL Server relational database each day.
You define a connection.
You need to ensure that the connection minimizes the attack surface area of the server.
How should you define the impersonation information for the connection? (More than one answer choice may achieve the goal. Select the BEST answer.)
You define a connection.
You need to ensure that the connection minimizes the attack surface area of the server.
How should you define the impersonation information for the connection? (More than one answer choice may achieve the goal. Select the BEST answer.)
正確答案: A
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.)
What should you do? (Each correct answer presents part of the solution. Choose all that apply.)
正確答案: C,D
You are managing a SQL Server Analysis Services (SSAS) tabular database.
The database must meet the following requirements:
* The processing must load data into partitions or tables.
* The processing must not rebuild hierarchies or relationships.
* The processing must not recalculate calculated columns.
You need to implement a processing strategy for the database to meet the requirements.
Which processing mode should you use?
The database must meet the following requirements:
* The processing must load data into partitions or tables.
* The processing must not rebuild hierarchies or relationships.
* The processing must not recalculate calculated columns.
You need to implement a processing strategy for the database to meet the requirements.
Which processing mode should you use?
正確答案: C
HOTSPOT
You create a new report in SQL Server Data Tools (SSDT). The report queries a Microsoft Azure SQL Database database table.
In a report table showing sales by cities, you need to enable users to interactively drill through to another report to show details of the customer sales within a chosen city.
Which text box property page should you use? (To answer, select the appropriate tab in the answer area.)
You create a new report in SQL Server Data Tools (SSDT). The report queries a Microsoft Azure SQL Database database table.
In a report table showing sales by cities, you need to enable users to interactively drill through to another report to show details of the customer sales within a chosen city.
Which text box property page should you use? (To answer, select the appropriate tab in the answer area.)
正確答案:
HOTSPOT
You are developing a SQL Server Analysis Services (SSAS) cube.
Revenue must be compared to a goal and described by a status and a trend. Revenue, goal, status, and trend will be defined by Multidimensional Expressions (MDX) expressions.
You need to add the Revenue indicator.
Which tab should you select? (To answer, select the appropriate tab in the work area.)
You are developing a SQL Server Analysis Services (SSAS) cube.
Revenue must be compared to a goal and described by a status and a trend. Revenue, goal, status, and trend will be defined by Multidimensional Expressions (MDX) expressions.
You need to add the Revenue indicator.
Which tab should you select? (To answer, select the appropriate tab in the work area.)
正確答案:
