← Back to exam page

70-467 – Designing Business Intelligence Solutions with Microsoft SQL Server 2012

Loading demo links...

Showing 7–9 of 10 questions

Question 7 (Case Study 1)

You need to create the calculation for SalespersonName.

What should you do? (Each correct answer presents a complete solution. Choose all that apply.)

Select all that apply, then click Submit answer.

  • ○

    Create a computed column in the data warehouse's DimSalesperson table. Include the column in the Sales Reporting model's Salesperson table.
  • ○

    Modify the data warehouse's DimSalesperson table and add a new column. Use an UPDATE statement to populate the new column with values. Update the SSIS package developed to populate the data warehouse's DimSalesperson table to use a Derived Column transformation to produce the calculation.
  • ○

    Configure the Sales Reporting model's Salesperson table properties to be based on a query. Define a derived column in the query.
  • ○

    Add a calculated column to the Sales Reporting model's Salesperson table by using the Data Analysis Expressions (DAX) language CONCATENATE function.
  • ○

    Create a view in the data warehouse that defines a derived column based on the DimSalesperson table. Base the Sales Reporting model's Salesperson table on the view. Include the column in the Sales Reporting model's Salesperson table.
  • ○

    Add a calculated column to the Sales Reporting model's Salesperson table by using the Data Analysis Expressions (DAX) language ADDCOLUMNS function.
Question 8 (Case Study 1)

You need to create the Sales Reporting shared SSRS data source.

Which SSRS data connection type should you use?

Select an option, then click Submit answer.

  • ○

    OData
  • ○

    Microsoft SQL Server
  • ○

    ODBC
  • ○

    OLE DB
Question 9 (Case Study 2)

You need to perform the pre-upgrade database backup operation by using SQL Server Management Studio (SSMS).

How should you configure the backup options?

Select an option, then click Submit answer.

  • ○

    Select the Apply compression check box. Select the Encrypt backup file check box and supply a password.
  • ○

    Clear the Apply compression check box. Select the Encrypt backup file check box and supply a password.
  • ○

    Clear the Apply compression check box. Clear the Encrypt backup file check box.
  • ○

    Select the Apply compression check box. Clear the Encrypt backup file check box.