You are developing a SQL Server Integration Services (SSIS) package that downloads data from a Windows Azure SQL Database database. A stored procedure will be called in an Execute SQL task by using an ODBC connection. This stored procedure has…
You are developing a SQL Server Integration Services (SSIS) package that loads data into a data warehouse hosted on Windows Azure SQL Database. You must combine two data sources together by using the ProductID column to provide complete details for…
You are developing a SQL Server Integration Services (SSIS) package. An Execute SQL task in the package checks product stock levels and sets a package variable named InStock to TRUE or FALSE depending on the stock level found. After the…
You are the Master Data Services (MDS) administrator at your company. An existing user must be denied access to a certain hierarchy node for an existing model. You need to configure the user’s permissions. Which user management menu item should…
You are loading a dataset into SQL Server. The dataset contains numerous duplicates for the Artist and Song columns. The values in the Artist column in the dataset must exactly match the values in the Artist domain in the knowledge…
You are developing a SQL Server Integration Service (SSIS) package. The package loads a customer dimension table by using a data flow task. Changes to the customer attributes must be tracked over time. You need to produce a checksum value…
A SQL Server Integration Services (SSIS) package is designed to download data from a financial database hosted in SQL Azure. The connection string to the financial database is defined as a project parameter named FinConStr. The parameter value must be…
A new dedicated server is used to execute resource-intensive SQL Server Integration Services (SSIS) 2012 packages. The environment that you are deploying the packages to has the following constraints: The operating system is Windows Server 2008 R2. The SSIS packages…
You are the administrator for a Data Quality Server. You are adding a user who must have permission to: Edit and execute a project View the activity monitoring data This user must not be able to: Perform any kind of…
You are designing a SQL Server Integration Services (SSIS) package configuration strategy. The package configuration must meet the following requirements: Include multiple properties in a configuration. Force packages to load all settings in the configuration. Support Encrypting File System (EFS)…