← Back to exam page

70-767 – Implementing a SQL Data Warehouse

Loading demo links...

Showing 4–6 of 10 questions

Question 4

HOTSPOT

You create a Microsoft SQL Server Integration Services (SSIS) package as shown in the SSIS Package exhibit. (Click the Exhibit button.)

The package uses data from the Products table and the Prices table. Properties of the Prices source are shown in the OLE DB Source Editor exhibit

(Click the Exhibit Button.) and the Advanced Editor for Prices exhibit (Click the Exhibit button.)

You join the Products and Prices tables by using the ReferenceNr column.

You need to resolve the error with the package.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

Hot Area:

Answer is in the explanation below.

Question 5

Your company manufactures several types of products.

The company has a production tracking application that stores the following data about the products:

The production date

The cost of production

The names of the products

The amount of waste created

The number of products produced

The name of the facility where the products are produced

You are designing a data warehouse for the data. You add a Date dimension.

You need to ensure that you can create a composite primary key for the fact table.

Which two columns should you add to the new dimension tables? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

Select all that apply, then click Submit answer.

  • ○

    Cost of Production
  • ○

    Amount Produced
  • ○

    Waste Amount
  • ○

    Product Name
  • ○

    Facility Name
Question 6

You manage the user accounts in master data Services (MDS).

You need to assign a user access to the MDS data and functions.

Which two components must you assign? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

Select all that apply, then click Submit answer.

  • ○

    file share permissions
  • ○

    model object permissions
  • ○

    functional area permissions
  • ○

    SQL Database permissions