Ensurepass

QUESTION 41

You are developing a SQL Server Analysis Services (SSAS) cube for the sales department at your company.

 

The sales department requires the following set of metrics:

 

Ÿ   Unique count of customers

Ÿ   Unique count of products sold

Ÿ   Sum of sales

 

You need to ensure that the cube meets the requirements while optimizing query response time. What should you do? (Each answer presents a complete solution. Choose all that apply.)

 

A.      Use ROLAP storage for all partitions.

B.      Use the Distinct Count and Sum measure aggregation functions.

C.      Use the Define Semiadditive Behavior page to enable semi-additive behavior.

D.      Use the Define Semiadditive Behavior page to disable semi-additive behavior.

E.       Create a single measure group containing all measures

F.       Place the distinct count measures in separate measure groups.

 

Correct Answer: BF

 

 

QUESTION 42

You are developing a SQL Server Analysis Services (SSAS) cube. The cube contains several dimensions, a local measure group, and a linked measure group. Both measure groups use MOLAP partitions. You need to write-enable one of the linked measure group partitions to support Microsoft Excel 2010 PivotTable What-If Analysis. What should you do before the partition can be write-enabled?

 

A.      Set the Type property of the partition s measure group to Forecast.

B.      Set the StorageMode property of the linked measure group to Rolap.

C.      Implement the local measure group as a linked measure group.

D.      Implement the linked measure group as a local measure group.

 

Correct Answer: D

 

 

QUESTION 43

You are developing a SQL Server Analysis Services (SSAS) tabular project. A column named City must be added to the table named Customer. The column will be used in the definition of a hierarchy. The City column exists in the Geography table that is related to the Customer table. You need to add the City column to the Customer table. How should you write the calculation?

 

A.      City:=RELATEDTABLE(Geography)

B.      City:=Geography[City]

C.      =RELATED(Geography[City])

D.      City:=RELATED(Geography[City])

E.       =RELATEDTABLE(Geography)

F.       =Geography[City]

 

Correct Answer: C

 

 

QUESTION 44

A production SQL Server Analysis Services (SSAS) cube is processed daily. The users query facts by using a hierarchy named Geography from a dimension named Geography. The DimGeography table in the data source view is used as the source of the Geography dimension.

 

The table has the following structure:

 

CREATE TABLE [dbo].[DimGeography](

[DimensionKey] [int] IDENTITY(1,1) NOT NULL,

[CityKey] [int] NOT NULL,

[CityName] [varchar](50) NOT NULL,

[StateProvinceKey] [int] NOT NULL,

[StateProvinceName] [varchar](50) NOT NULL,

[CountryKey] [int] NOT NULL,

[CountryName] [varchar](50) NOT NULL) ON [PRIMARY]

 

The Geography dimension has three attribute hierarchies:

 

Ÿ   City

Ÿ   State-Province

Ÿ   Country

 

The attributes have the following relationships defined:

 

City > State-Province > Country.

 

Each attribute has a key and a name sourced from the related key and name columns in the DimGeography table.

 

During processing, you receive the following error message: “Errors in the OLAP storage engine: A duplicate attribute key has been found when processing: Table: ‘dbo_DimGeography’, Column: ‘StateProvinceKey’, Value: ’23’. The attribute is ‘State-Province’.”

 

You verify that the data is accurate. You need to ensure that the dimension processes successfully. What should you do?

 

A.      Delete the Geography hierarchy.

B.      Remove the State-Province attribute.

C.      Relate the State-Province and Country attributes directly to the City attribute.

D.      Remove the duplicate data from the DimGeography table.

 

Correct Answer: C

 

 

QUESTION 45

You are developing a SQL Server Analysis Services (SSAS) tabular project. A model contains tables and columns that must not be visible to the user. The columns and tables cannot be removed because they are used in calculations. You need to hide the tables and columns. What should you do?

 

A.      Right-click the applicable tables and columns and select the Hide from Client Tools option.

B.      In the Properties window for the applicable tables and columns, set the Visible property to True.

C.      Right-click the applicable tables and columns and select the Hide option.

D.      In the Properties window for the applicable tables and columns, set the Enabled property to False.

 

Correct Answer: A

 

 

QUESTION 46

You are designing a SQL Server Reporting Services (SSRS) report. The report defines a single SQL Server data source and dataset. You need to include additional data sourced from a SQL Azure database in the report. What should you do?

 

A.      Create a SQL Azure data source and then add a dataset that uses the new data source.

B.      Create a SQL Server data source and then add a dataset that uses the new data source.

C.      Generate an Atom-compliant data feed for the report.

D.      Create a SQL Azure dataset that uses the existing data source.

 

Correct Answer: A

 

 

QUESTION 47

You are managing a SQL Server Reporting Services (SSRS) instance in native mode. A role named Folder Access Controller is present on the server. The Folder Access Controller role consists of only the Set security for individual items task. When role members open Rep
ort Manager, they cannot view folders. You need to modify the Folder Access Controller role so that the role members can view folders. Which task should you add to the Folder Access Controller role?

 

A.      Manage data sources

B.      View reports

C.      Manage folders

D.      View models

 

Correct Answer: C

 

 

QUESTION 48

You are designing a SQL Server Reporting Services (SSRS) report to display product names and their year-to-date (YTD) sales quantity. YTD sales quantity values are classified in three bands: High Sales, Medium Sales, and Low Sales. You add a table to the report. Then you define two columns based on the fields named ProductName and YTDSalesQuantity. You need to set the color of the product text to red, yellow, or blue, depending on the value of the YTD sales quantity values. What should you do?

 

A.        Use an expression for the TextDecoration property of the text box.

B.        Use an expression for the Color property of the text box.

C.        Add an indicator to the table.

D.        Use an expression for the Style property of the text box.

E.         Use an expression for the Font property of the text box.

 

Correct Answer: B

 

 

QUESTION 49

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.      Change the storage mode of the partition to ROLAP.

B.      Create a drillthrough action that will query the underlying data source in real time for the Total Quantity On Hand measure.

C.      Add an additional MOLAP partition to the measure group.

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.

 

Correct Answer: D

 

 

QUESTION 50

You are developing a SQL Server Analysis Services (SSAS) tabular project that will be used by the finance, sales, and marketing teams.

 

Ÿ   The sales team reports that the model is too complex and difficult to use.

Ÿ   The sales team does not need any information other than sales-related resources in the tabular model.

Ÿ   The finance and marketing teams need to see all the resources in the tabular model.

 

You need to implement a solution that meets the needs of the sales team while minimizing development and administrative effort. What should you do?

 

A.      Create a perspective for the sales team.

B.      Create a separate partition for each team.

C.      Create a separate data source for each team.

D.      Enable client side security to filter non-sales data.

 

Correct Answer: A

 

 

Comments are closed.