Ensurepass

QUESTION 61

You are developing a BI Semantic Model (BISM) that will be used to analyze complex budgeting and forecast data sourced from a financial database. The model will be deployed to a server with 28 GB of RAM. The source data, located in a SQL Server data warehouse, is currently using 15 terabytes of disk space and is doubling in size every month. The model will be queried by staff in the accounting department by using Microsoft Excel 2010. You need to ensure the highest query performance and scalability for the accounting department queries. Which project type should you choose?

 

  1. PowerPivot workbook deployed to SharePoint

  2. multidimensional project

  3. tabular project that uses the DirectQuery query mode

  4. tabular project that uses the In-Memory query mode

 

Correct Answer: B

QUESTION 62

You are designing a SQL Server Reporting Services (SSRS) report that sources data from a SQL Azure database. You need to design the report to show the sum of sales. The sales must be grouped by region on the rows and year on the columns. Which report item should you add?

 

To answer, select the appropriate setting in the answer area.

 

70-466-demo-10

 

  1. Text Box

  2. Line

  3. Table

  4. Matrix

  5. Rectangle

  6. List

  7. Image

  8. Subreport

  9. Chart

  10. Gauge

  11. Map

  12. Data Bar

  13. Sparkline

  14. Indicator

 

Correct Answer: D

 

QUESTION 63

You are deploying an update to a SQL Server Analysis Services (SSAS) cube to a production environment. The production database has been configured with security roles. You need to preserve the existing security roles in the production database. Database roles and their user accounts from the development environment must not be deployed to the production server. Which deployment method should you use?

 

  1. Back up and restore the database.

  2. Use the SQL Server Analysis Services Migration Wizard.

  3. Use the SQL Server Analysis Services Deployment Wizard.

  4. Deploy the project from SQL Server Data Tools to the production server.

 

Correct Answer: C

 

 

QUESTION 64

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

 

  1. Use the FormatString measure property to format SalesAmount as #,##0.00;-#,##0.00.

  2. Use the FormatString measure property to format SalesAmount as Currency.

  3. Use the MeasureExpression measure property to change the precision of SalesAmount to two digits.

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

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

 

Correct Answer: E

 

 

QUESTION 65

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

  1. Place the measures in a single measure group.

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

  3. Use the additive measure group functions.

  4. Use the semiadditive measure group functions.

  5. Use the Count and Sum measure aggregation functions.

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

 

Correct Answer: BF

 

 

QUESTION 66

You are developing a BI Semantic Model (BISM) that will be used to analyze complex budgeting and forecast data sourced from a financial database. The model will be deployed to a server with 32 GB of RAM. The source data, located in a SQL Server data warehouse, is currently using 10 terabytes of disk space and is doubling in size every three months. The model will be queried by staff in the accounting department by using Microsoft Excel 2010. You need to ensure the highest query performance and scalability for the accounting department queries. Which project type should you choose?

 

  1. tabular project that uses the DirectQuery query mode

  2. PowerPivot workbook

  3. tabular project that uses the In-Memory query mode

  4. multidimensional project

 

Correct Answer: D

 

 

QUESTION 67

You are developing a BI Semantic Model (BISM) that retrieves data from several sources. These sources include a SQL Azure database and an OData data feed that includes rainfall data for towns on the east coast of Australia. The model will be deployed to a server with significantly more memory than the total size of the source data. You have the data feed URL, which you will use when developing the model in SQL Server Data Tools (SSDT).

 

The model must meet the following requirements:

 

  • Performance must be maximized.

  • Data latency of up to one month is acceptable.

 

You need to choose a project type and a data access mode to meet the requirements. What should you do?

 

  1. In SSDT, select the multidimensional project type and use the MOLAP storage mode.

  2. In SSDT, select the tabular project type and use the In-Memory query mode.

  3. In SSDT, select the multidimensional project type and use the ROLAP storage mode.

  4. In SSDT, select the tabular project type and use the DirectQuery query mode.

 

Correct Answer: B

 

 

QUESTION 68

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?

 

  1. =RELATED(Geography.City)

  2. City:=VALUES(Geography[City])

  3. City:= LOOKUPVALUE(Geography[City],Geography[GeographyKey],[GeographyKey])

  4. =VALUES(Geography[City])

  5. City:= LOOKUP(Geography[City],Geography[GeographyKey],[GeographyKey])

  6. =RELATED(Geography[City])

 

Correct Answer: F

 

 

QUESTION 69

You are developing a SQL Server Analysis Services (SSAS) tabular project. The model has tables named Invoice Line Items and Products.

 

The Invoice Line Items table has the following columns:

 

  • Product Id

  • Unit Sales Price

 

The Unit Sales Price column stores the unit price of the product sold.

 

The Products table has the following columns:

 

  • Product Id

  • Maximum Sales Price

 

The Maximum Sales Price column is available only in the Products table.

 

You add a column named Is Overpriced to the Invoice Line Items table. The Is Overpriced column must store a value of TRUE if the value of the Unit Sales Price is greater than the value of the Maximum Sales Price. Otherwise, a value of FALSE must be stored. You need to define the Data Analysis Expressions (DAX) expression for the Is Overpriced column. Which DAX formula should you use? (Each answer represents a complete solution. Choose all that apply.)

 

  1. =IF([Unit Sales Price] > RELATED(Products[Maximum Sales Price]), TRUE, FALSE)

  2. =IF(RELATED(Products[Unit Sales Price]) > [Maximum Sales Price], TRUE, FALSE)

  3. =IF([Unit Sales Price] > LOOKUPVALUE(Products[Maximum Sales Price], Products[Product Id], [Product Id]), TRUE, FALSE)

  4. =IF(LOOKUPVALUE(Products[Unit Sales Price], Products[Product Id], [Product Id]) > [Maximum Sales Price]), TRUE, FALSE)

 

Correct Answer: AC

 

 

QUESTION 70

You are designing a SQL Server Reporting Services (SSRS) report for a bank. The bank has Automated Teller Machines (ATMs) in several regions. ATM operational data is stored in a SQL Azure database. The report must use a map to display the location and status of the ATMs as shown in the following exhibit.

 

70-466-demo-11

 

You need to ensure that the report displays only a user selected map region. Which source of spatial data should you use for the map?

 

  1. ESRI shape file

  2. Map gallery

  3. Bing Maps layer

  4. SQL Server spatial query

 

Correct Answer: D

 

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

Try Microsoft MCSE 70-466 Free Demo

 

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.