You are implementing the indexing strategy for a fact table in a data warehouse. The fact table is named
Quotes. The table has no indexes and consists of seven columns:
[ID]
[QuoteDate]
[Open]
[Close]
[High]
[Low]
[Volume]
Each of the following queries must be able to use acolumnstore index:
SELECT AVG ([Close]) AS [AverageClose]
FROM Quotes
WHERE [QuoteDate] BETWEEN ‘20100101’ AND ‘20101231’.
SELECT AVG([High] – [Low]) AS [AverageRange]
FROM Quotes
WHERE [QuoteDate] BETWEEN ‘20100101’ AND ‘20101231’.
SELECT SUM([Volume]) AS [SumVolume]
FROM Quotes
WHERE [QuoteDate] BETWEEN ‘20100101’ AND ‘20101231’
You need to ensure that the indexing strategy meetsthe requirements. The strategy must also minimize the
number and size of the indexes. What should you do?

You are developing a SQL Server Integration Services (SSIS) package that imports data into a data warehouse
hosted on SQL Azure. The package uses a Foreach container to process text files found in a folder. The
package must be deployed to a single server by using the Project Deployment model. Multiple SQL Server
Agent jobs call the package. Each job is executed on a different schedule. Each job passes a differentfolder
path to the package. You need to configure the package to accept the folder path from each job. Which
package configuration should you use?

You are creating a SQL Server Master Data Services (MDS) model. This model is used to store a master list of
products. An attribute must be added to the Productentity to define the sales manager responsible foreach
product. You need to create an attribute in the Product entity that prevents users from entering invalid sales
manager values. Which type of attribute should you create?

You are designing a data warehouse with two fact tables. The first table contains sales per month and the
second table contains orders per day. Referential integrity must be enforced declaratively. You need to design a
solution that can join a single time dimension to both fact tables. What should you do?

You are completing the installation of the Data Quality Server component of SQL Server Data Quality Services
(DQS). You need to complete the post-installation configuration. What should you do?

You are completing the installation of the Data Quality Server component of SQL Server Data Quality Services
(DQS). You need to complete the post-installation configuration. What should you do?

You are using the Knowledge Discovery feature of the Data Quality Services (DQS) client application tomodify
an existing knowledge base. In the mapping configuration, two of the three columns are mapped to existing
domains in the knowledge base. The third column, named Team Type, does not yet have a domain. You need
to complete the mapping of the Team Type column. What should you do?

You are developing a SQL Server Integration Services (SSIS) project that copies a large amount of rowsfrom a
SQL Azure database. The project uses the Package Deployment Model. This project is deployed to SQL Server
on a test server. You need to ensure that the project is deployed to the SSIS catalog on the production server.
What should you do?

You are developing a SQL Server Integration Services (SSIS) package. To process complex scientific data
originating from a SQL Azure database, a custom task component is added to the project. You need to ensure
that the custom component is deployed on a test environment correctly. What should you do?

You are implementing a SQL Server Integration Services (SSIS) package that loads data hosted in a SQL
Azure database into a data warehouse. The source system contains redundant or inconsistent data. When the
package finds invalid data, the row containing the invalid data must be omitted but it must also be written to a
text file for further analysis. You need to establish the best technique to log these invalid rows while keeping the
amount of development effort to a minimum. What should you do?