What should you do?

Correct Answer for the following Question is given below 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 … Read more

What should you do?

Correct Answer for the following Question is given below You are performance tuning a SQL Server Integration Services (SSIS) package to load sales data from a source system into a data warehouse that is hosted on Windows Azure SQL Database.The package contains a data flow task that has seven source-to-destination execution trees.Only three of the … Read more

Which SQL Server application should you use?

Correct Answer for the following Question is given below You are installing SQL Server Data Quality Services (DQS).You need to give specific users access to the Data Quality Server.Which SQL Server application should you use?Ref: http://msdn.microsoft.com/en-us/library/hh213045.aspx Question: Which SQL Server application should you use? Options: SQL Server Configuration Manager SQL Server Data Tools SQL Server … Read more

What should you do?

Correct Answer for the following Question is given below You are designing a data warehouse for a software distribution business that stores sales by software title. It stores sales targets by software category.Software titles are classified into subcategories and categories. Each software title is included in only a single software subcategory, and each subcategory is … Read more

Which hierarchy type should you use?

Correct Answer for the following Question is given below You are creating a SQL Server Master Data Services (MDS) model for a company.The source data for the company is stored in a single table that contains the manager-to- subordinate relationships.You need to create a hierarchy representing the organizational structure of the company.Which hierarchy type should … Read more

Which stored procedure should you use?

Correct Answer for the following Question is given below You are using a SQL Server Integration Services (SSIS) project that is stored in the SSIS catalog. An Environment has been defined in the SSIS catalog.You need to add the Environment to the project.Which stored procedure should you use?Environments (Test, Production etc) are associated with projects … Read more

What should you do?

Correct Answer for the following Question is given below You are using the Knowledge Discovery feature of the Data Quality Services (DQS) client application to modify 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 Group, does not yet … Read more

Which Data Flow transformation should you use?

Correct Answer for the following Question is given below You are designing a SQL Server Integration Services (SSIS) data flow to load sales transactions from a source system into a data warehouse hosted on Windows Azure SQL Database. One of the columns in the data source is named ProductCode.Some of the data to be loaded … Read more

What should you do?

Correct Answer for the following Question is given below You are designing a data warehouse hosted on SQL Azure. The data warehouse currently includes the dimUser and dimDistrict dimension tables and the factSales fact table. The dimUser table contains records for each user permitted to run reports against the warehouse; and the dimDistrict table contains … Read more

What should you use to set the variable?

Correct Answer for the following Question is given below You are implementing a new SQL Server Integration Services (SSIS) 2012 package that loads data from various flat files and a Windows Azure SQL Database database.Daily transactions must be loaded into a staging database. All the SSIS tasks will use the CurrentDate variable as the transaction … Read more