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. The reports will show the relationship between product sales and rainfall
over time.
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 create a materialized reference dimension between a dimension named Regions and a measure group named Orders.
You use a table named Customers as a bridge as shown in the exhibit. (Click the Exhibit button.)

You need to ensure that data is updated to reflect any changes in the relationship. The solution must NOT require that the entire cube be reprocessed.
What should you reprocess?

You are modifying a SQL Server Analysis Service (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?

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 are creating a SQL Server Analysis Services (SSAS) multidimensional database.
Users need a time dimension for:
– Dates
– Delivery dates
– Ship dates
You need to implement the minimum number of required SSAS objects.
What should you do?

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?

You are managing a SQL Server Reporting Services (SSRS) instance in native mode. A system role named Developer Support is present on the server.
Members of the Developer Support role cannot modify the report execution timeout period.

You need to enable members of the Developer Support role to modify the report execution timeout period.
Which task should you add to the Developer Support role?

You are creating a new report in SQL Server Report Builder. You add a Microsoft Azure SQL Database data source. Then you add a dataset that has four fields
named Year, Country, Category, and Sales.
You must design a matrix as shown in the following table.

The category rows (the first three rows as shown in the diagram) must present total sales amount by category. The country rows {the next six rows as shown in the
diagram) must present total sales amount by country. The total row must present the total sales for each year.
You add a matrix to the report. You add a grouping of the Category field on the rows and a grouping of the Year field on the columns.
You need to add the countries on the rows of the matrix.
Which Row Group option should you select when you add the group?

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 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?