070-466 試験問題を無料オンラインアクセス

DRAG DROP
You manage a SQL Server Reporting Services (SSRS) instance running in native mode.
You are troubleshooting a performance problem and need to know which reports are frequently executed. You discover that the report server execution logs are empty, despite significant report activity.
You need to ensure that the server is configured for report execution logging.
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: This server is running in NATIVE mode (not Sharepoint mode)
To enable execution logging (in Native mode):
* Start SQL Server Management Studio with administrative privileges. For example right-click the Management Studio icon and click 'Run as administrator'.
* Connect to the desired report server.
* Right-click the server name and click Properties. If the Properties option is disabled, verify you ran SQL Server Management Studio with administrative privileges.
* Click the Logging page.
* Select Enable report execution Logging.
Ref: http://msdn.microsoft.com/en-us/library/ms159110.aspx

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.)

• A.PowerShell
• B.SharePoint Products Configuration Wizard
• C.SQL Server Configuration Manager
• D.SharePoint Central Administration
• E.PowerPivot Configuration Tool

You are developing a SQL Server Reporting Services (SSRS) sales summary report.
The report header consists of several images. Report users require PDF exports of the report with no bulky images of the report header.
You need to ensure that the header of the report is hidden when a user exports the report to PDF format.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A.Set the Hidden property of the report header to TRUE.
• B.Set the Hidden property of the report header to (Globals!RenderFormat.Name = "PDF").
• C.Set the Hidden property of the report header to (Globals!RenderFormat.IsInteractive = False).
• D.Set the Hidden property of the report header to FALSE.

You are creating a SQL Server Analysis Services (SSAS) cube.
You need to create a time dimension. It must be linked to a measure group named Sales at the day granularity level. It must also be linked to a measure group named Salary at the month granularity level.
What should you do?

• A.Use the Business Intelligence Wizard to define dimension intelligence.
• B.Create a dimension. Create regular relationships between the cube dimension and the measure group. Configure the relationships to use different dimension attributes.
• C.Add a measure that uses the Count aggregate function to an existing measure group.
• D.Create several dimensions. Add each dimension to the cube.
• E.Add a hidden measure that uses the Sum aggregate function. Add a calculated measure aggregating the measure along the time dimension.
• F.Create a dimension with one attribute hierarchy. Set the IsAggregatable property to False and then set the DefaultMember property. Use a many-to-many relationship to link the dimension to the measure group.
• G.Use role playing dimensions.
• H.Create a new named calculation in the data source view to calculate a rolling sum. Add a measure that uses the Max aggregate function based on the named calculation.
• I.Add a measure that uses the DistinctCount aggregate function to an existing measure group.
• J.Add a calculated measure based on an expression that counts members filtered by the Exists and NonEmpty functions.
• K.Create a dimension. Then add a cube dimension and link it several times to the measure group.
• L.Add a measure group that has one measure that uses the DistinctCount aggregate function.
• M.Create a dimension with one attribute hierarchy. Set the IsAggregatable property to False and then set the DefaultMember property. Use a many-to-many relationship to link the dimension to the measure group.
• N.Create a dimension with one attribute hierarchy. Set the ValueColumn property, set the IsAggregatable property to False, and then set the DefaultMember property. Configure the cube dimension so that it does not have a relationship with the measure group. Add a calculated measure that uses the MemberValue attribute property.
• O.Create a dimension with one attribute hierarchy. Set the IsAggregatable property to False and then set the DefaultMember property. Use a regular relationship between the dimension and measure group.

You are developing a new SQL Server Reporting Services (SSRS) report in SQL Server Data Tools (SSDT).
The report must define a report parameter to prompt the user for the business unit. Each business unit has a unique font scheme combination of font and size properties.
You need to ensure that all of the text boxes in the table headers use the correct business unit font properties.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A.Add two report variables named FontFamily and FontSize. Assign them with expressions to return the appropriate colors. For each header text box, use expressions to set the FontFamily and FontSize properties by using the variables.
• B.Add two Microsoft Visual C# functions to the code block of the report to implement FontFamily and FontSize functions. For each header text box, use expressions to set the FontFamily and FontSize properties by using the functions.
• C.Add one report variable for FontFamily Assign it with an expression to return the appropriate colors. For each header text box, set the Color and FontSize properties by using the variables.
• D.For each header text box, assign expressions to the FontFamily and FontSize properties.