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

You are designing a SQL Server Analysis Services (SSAS) cube for the sales department at your company.
The sales department has the following requirements for the cube:
* Include a year-over-year (YOY) calculation
* Include a month-over-month (MOM) calculation
You need to ensure that the calculations are implemented in the cube.
Which Multidimensional Expressions (MDX) function should you use?

• A.TIMEINTELLIGENCE()
• B.UNREGINTERCEPT()
• C.LASTPERIODS()
• D.PARALLELPERIOD()

You are designing a SQL Server Reporting Services (SSRS) report to display vineyard names and their year-to-date (YTDJ grape yield.
Grape yield values are classified in three bands:
*High Yield
*Medium Yield
*Low Yield
You add a table to the report. Then you define two columns based on the fields named VineyardName and YTDGrapeYield You need to set the color of the vineyard text to red, yellow, or blue, depending on the value of the YTD grape yield values.
What should you do?

• A.Use an expression for the Style property of the vineyard text box.
• B.Add an indicator to the table.
• C.Use an expression for the Font property of the vineyard text box.
• D.Use an expression for the TextDecoration property of the vineyard text box.
• E.Use an expression for The Color property of the vineyard text box.

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?

• A.From the Web.config file, modify the impersonation settings.
• B.Register a Service Principal Name (SPN) for Server1.
• C.Register a Service Principal Name (SPN) for DB1.
• D.From the SQL Server Data Tools, modify the impersonation settings.

You are modifying a SQL Server Analysis Services (SSAS) cube.
The cube consists of a single measure group that contains the following measures:
*Total Quantity On Hand
*Average Quantity On Hand
The measure group has a single partition that uses the MOLAP storage mode.
You need to modify the cube design to ensure that the Total Quantity On Hand measure is updated in real-time and that Average Quantity On Hand measure is updated hourly.
What should you do?

• A.Add an additional MOLAP partition to the measure group.
• B.Create a drillthrough action that will query the underlying data source in real time for the Total Quantity On Hand measure.
• C.Change the storage mode of the partition to ROLAP.
• D.Create a new measure group for the Total Quantity On Hand measure. Configure the storage mode for the new measure group's partition to ROLAP.

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.For each header text box, assign expressions to the FontFamily and FontSize properties.
• D.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.