Home » New Updated Microsoft MCSE 70-466 Real Exam Questions and Answers Download 21-30

New Updated Microsoft MCSE 70-466 Real Exam Questions and Answers Download 21-30

Ensurepass

QUESTION 21

You are modifying a SQL Server Analysis Services (SSAS) cube. Users of the cube report that the precision for the TransactionCost measure is five digits. You need to ensure that the TransactionCost measure stores values to two digits of precision. What should you do?

 

  1. Add a named query in the data source view that casts the data source column to two digits of precision. Bind the TransactionCost measure to the new query.

  2. Add a named calculation in the data source view that casts the data source column to two digits of precision. Bind the TransactionCost measure to the new column.

  3. Use the FormatString measure property to format TransactionCost as #,##0.00;-#,##0.00.

  4. Use the MeasureExpression measure property to change the precision of TransactionCost to two digits.

  5. Use the FormatString measure property to format TransactionCost as Currency.

 

Correct Answer: B

 

 

QUESTION 22

A multinational retailer has retail locations on several continents. A single SQL Server Reporting Services (SSRS) instance is used for global reporting. A SQL Server Analysis Services (SSAS) instance for each continent hosts a multidimensional database named RetailSales. Each RetailSales database stores data only for the continent in which it resides. All of the SSAS instances are configured identically. The cube names and objects are identical.

 

Reports must meet the following requirements:

 

  • A report parameter named ServerName must be defined in each report.

  • When running a report, users must be prompted to select a server instance.

  • The report data source must use the Microsoft SQL Server Analysis Services data source type.

 

You need to create a data source to meet the requirements. How should you define the expression that is assigned to the connection string property of the data source?

 

  1. =”Data Source=@ServerName;Initial Catalog=RetailSales”

  2. =”Server=@ServerName;Initial Catalog=RetailSales”

  3. =”Data Source=” & Parameters!ServerName.Value & “;Initial Catalog=RetailSales”

  4. =”Server=” & Parameters!ServerName.Value & “;Initial Catalog=RetailSales”

  5. =”Server=” & Parameters!ServerName.Value

 

Correct Answer: C

 

 

QUESTION 23

You install SQL Server Reporting Services (SSRS). You need to restore a copy of the symmetric key. Which command should you run?

 

  1. rskeymgmt -a -f %temp%rs.key -p Password1

  2. rskeymgmt -e -f %temp%rs.key -p Password1

  3. rskeymgmt i

  4. rskeymgmt d

 

Correct Answer: A

 

 

QUESTION 24

Note: This question is part of a series of questions that use the same set of answer choices. An answer choice may be correct for more than one question in the series.

 

You are designing a SQL Server Analysis Services (SSAS) cube. You need to create a measure to count unique customers. What should you do?

 

  1. Add a hidden measure that uses the Sum aggregate function. Add a calculated measure aggregating the measure along the time dimension.

  2. Create a dimension. Then add a cube dimension and link it several times to the measure group.

  3. Create several dimensions. Add each dimension to the cube.

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

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

  6. Add a calculated measure based on an expression that counts members filtered by the Exists and NonEmpty functions.

  7. Create a dimension. Create regular relationships between the cube dimension and the measure group. Configure the relationships to use different dimension attributes.

  8. Add a measure that uses the Count aggregate function to an existing measure group.

  9. Use the Business Intelligence Wizard to define dimension intelligence.

  10. Add a measure group that has one measure that uses the DistinctCount aggregate function.

  11. Add a measure that uses the LastNonEmpty aggregate function. Use a regular relationship between the time dimension and the measure group.

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

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

  14. Use role playing dimensions.

  15. Add a measure that uses the DistinctCount aggregate function to an existing measure group.

 

Correct Answer: J

 

 

QUESTION 25

Note: This question is part of a series of questions that use the same set of answer choices. An answer choice may be correct for more than one question in the series.

 

You are developing a SQL Server Analysis Services (SSAS) multidimensional project. A fact table is related to a dimension table named DimScenario by a column named ScenarioKey.

 

The dimension table contains three rows for the following scenarios:

 

  • Actual

  • Budget Q1

  • Budget Q3

 

You need to create a dimension to allow users to view and compare data by scenario. What should you do?

 

  1. Create a dimension. Create regular relationships between the cube dimension and the measure group. Configure the relationships to use different dimension attributes.

  2. Add a measure that uses the DistinctCount aggregate function to an existing measure group.

  3. Add a calculated measure based on an expression that counts members filtered by the Exists and NonEmpty functions.

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

  5. Add a hidden measure that uses the Sum aggregate function. Add a calculated measure aggregating the measure along the time dimension.

  6. Create a dimension. Then add a cube dimension and link it several times to the measure group.

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

  8. Use the Business Intelligence Wizard to define dimension intelligence.

  9. Add a measure that uses the Count aggregate function to an existing measure group.

  10. Use role playing dimensions.

  11. Add a measure group that has one measure that uses the DistinctCount aggregate function.

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

  13. Add a measure that uses the LastNonEmpty aggregate function. Use a regular relationship between the time dimension and the measure group.

  14. Create several dimensions. Add each dimension to the cube.

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

 

Correct Answer: L

 

 

QUESTION 26

Note: This question is part of a series of questions that use the same set of answer choices. An answer choice may be correct for more than one question in the series.

 

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?

 

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

  2. Add a measure group that has one measure that uses the DistinctCount aggregate function.

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

  4. Create a dimension. Then add a cube dimension and link it several times to the measure group.

  5. Use role playing dimensions.

  6. Add a calculated measure based on an expression that counts members filtered by the Exists and NonEmpty functions.

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

  8. Add a hidden measure that uses the Sum aggregate function. Add a calculated measure aggregating the measure along the time dimension.

  9. Add a measure that uses the DistinctCount aggregate function to an existing measure group.

  10. Create several dimensions. Add each dimension to the cube.

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

  12. Create a dimension. Create regular relationships between the cube dimension and the measure group. Configure the relationships to use different dimension attributes.

  13. Use the Business Intelligence Wizard to define dimension intelligence.

  14. Add a measure that uses the LastNonEmpty aggregate function. Use a regular relationship between the time dimension and the measure group.

  15. Add a measure that uses the Count aggregate function to an existing measure group.

 

Correct Answer: L

 

 

QUESTION 27

Note: This question is part of a series of questions that use the same set of answer choices. An answer choice may be correct for more than one question in the series.

 

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?

 

  1. Create a dimension. Create regular relationships between the cube dimension and the measure group. Configure the relationships to use different dimension attributes.

  2. Add a measure that uses the LastNonEmpty aggregate function. Use a regular relationship between the time dimension and the measure group.

  3. Add a measure group that has one measure that uses the DistinctCount aggregate function.

  4. Use role playing dimensions.

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

  6. Add a measure that uses the Count aggregate function to an existing measure group.

  7. Create several dimensions. Add each dimension to the cube.

  8. Add a hidden measure that uses the Sum aggregate function. Add a calculated measure aggregating the measure along the time dimension.

  9. Add a calculated measure based on an expression that counts members filtered by the Exists and NonEmpty functions.

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

  11. Create a dimension. Then add a cube dimension and link it several times to the measure group.

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

  13. Add a measure that uses the DistinctCount aggregate function to an existing measure group.

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

  15. Use the Business Intelligence Wizard to define dimension intelligence.

 

Correct Answer: D

 

 

QUESTION 28

Note: This question is part of a series of questions that use the same set of answer choices. An answer choice may be correct for more than one question in the series.

 

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?

 

  1. Add a measure that uses the LastNonEmpty aggregate function. Use a regular relationship between the time dimension and the measure group.

  2. Create several dimensions. Add each dimension to the cube.

  3. Add a measure group that has one measure that uses the Dist
    inctCount aggregate function.

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

  5. Add a calculated measure based on an expression that counts members filtered by the Exists and NonEmpty functions.

  6. Use the Business Intelligence Wizard to define dimension intelligence.

  7. Create a dimension. Create regular relationships between the cube dimension and the measure group. Configure the relationships to use different dimension attributes.

  8. Use role playing dimensions.

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

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

  11. Create a dimension. Then add a cube dimension and link it several times to the measure group.

  12. Add a hidden measure that uses the Sum aggregate function. Add a calculated measure aggregating the measure along the time dimension.

  13. Add a measure that uses the Count aggregate function to an existing measure group.

  14. Add a measure that uses the DistinctCount aggregate function to an existing measure group.

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

 

Correct Answer: I

 

 

QUESTION 29

Note: This question is part of a series of questions that use the same set of answer choices. An answer choice may be correct for more than one question in the series.

 

You are developing a SQL Server Analysis Services (SSAS) cube. The data warehouse has a table named FactStock that is used to track movements of stock. A column named MovementQuantity contains quantities of stock. A positive quantity is used for input and negative quantity is used for output. A column named MovementDate is related to the time dimension. The quantity in stock, at a given point in time, can be evaluated as the sum of all MovementQuantity values at that point in time. You need to create a measure that calculates the quantity in stock value. What should you do?

 

  1. Create several dimensions. Add each dimension to the cube.

  2. Add a measure that uses the DistinctCount aggregate function to an existing measure group.

  3. Create a dimension. Create regular relationships between the cube dimension and the measure group. Configure the relationships to use different dimension attributes.

  4. Add a measure that uses the LastNonEmpty aggregate function. Use a regular relationship between the time dimension and the measure group.

  5. Use the Business Intelligence Wizard to define dimension intelligence.

  6. Add a calculated measure based on an expression that counts members filtered by the Exists and NonEmpty functions.

  7. Create a dimension. Then add a cube dimension and link it several times to the measure group.

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

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

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

  11. Use role playing dimensions.

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

  13. Add a measure group that has one measure that uses the DistinctCount aggregate function.

  14. Add a hidden measure that uses the Sum aggregate function. Add a calculated measure aggregating the measure along the time dimension.

  15. Add a measure that uses the Count aggregate function to an existing measure group.

 

Correct Answer: O

 

 

QUESTION 30

You install SQL Server Reporting Services (SSRS). You need to back up a copy of the symmetric key. Which command should you run?

 

  1. rskeymgmt i

  2. rskeymgmt -a -f %temp%rs.key -p Password1

  3. rskeymgmt -d

  4. rskeymgmt -e -f %temp%rs.key -p Password1

 

Correct Answer: D

 

Instant Access to Download Latest Complete Collection of Microsoft MCSE 70-466 Real Exam

Try Microsoft MCSE 70-466 Free Demo

HOT EXAM!
New Updated Microsoft MCSE 70-466 Real Exam Questions and Answers Download 31-40
New Updated Microsoft MCSE 70-466 Real Exam Questions and Answers Download 11-20

Name of author

Name: admin