To ease the debugging of packages, you standardize the SQL Server Integration Services (SSIS) package logging methodology. The methodology has the following requirements:
* Centralized logging in SQL Server
* Simple deployment
* Availability of log information through reports or T-SQL
* Automatic purge of older log entries
* Configurable log details
You need to configure a logging methodology that meets the requirements while minimizing the amount of deployment and development effort. What should you do?
A. Deploy the package by using an msi file.
B. Use the gacutil command.
C. Create an OnError event handler.
D. Create a reusable custom logging component.
E. Use the dtutil /copy command.
F. Use the Project Deployment Wizard.
G. Run the package by using the dtexec /rep /conn command.
H. Add a data tap on the output of a component in the package data flow.
I. Run the package by using the dtexec /dumperror /conn command.
J. Run the package by using the dtexecui.exe utility and the SQL Log provider.
K. Deploy the package to the Integration Services catalog by using dtutil and use SQL Server to store the configuration.
You are maintaining a Data Quality Services (DQS) environment. The production server failed and a new server has been set up. The DQS databases are restored to a new server. All the appropriate permissions are granted. DQS users are experiencing issues connecting to the new Data Quality Server. You need to enable users to connect to the new server. Which Surface Area Configuration property should you enable?
Drag and Drop Question
You are building a SQL Server Integration Services (SSIS) package to load product data sourced from a SQL Azure database to a data warehouse. Before the product data is loaded, you create a batch record by using an Execute SQL task named Create Batch. After successfully loading the product data, you use another Execute SQL task named Set Batch Success to mark the batch as successful.
You need to create and execute an Execute SQL task to mark the batch as failed if either the Create Batch or Load Products task fails. Which three steps should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)
Drag and Drop Question
You are building a SQL Server Integration Services (SSIS) package to load data from all files that are automatically copied to a directory each night through an external FTP process. You need to load data from all copied files to a destination table in SQL Server. Which three steps should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)
You are developing a data flow to load sales data into a fact table. In the data flow, you configure a Lookup Transformation in full cache mode to look up the product data for the sale. The lookup source for the product data is contained in two tables. You need to set the data source for the lookup to be a query that combines the two tables. Which page of the Lookup Transformation Editor should you select to configure the query? To answer, select the appropriate page in the answer area.
You are reviewing the design of a customer dimension table in an existing data warehouse hosted on SQL Azure. The current dimension design does not allow the retention of historical changes to customer attributes such as Postcode.
You need to redesign the dimension to enable the full historical reporting of changes to multiple customer attributes including Postcode. What should you do?
A. Add StartDate and EndDate columns to the customer dimension.
B. Add an IsCurrent column to the customer dimension.
C. Enable Snapshot Isolation on the data warehouse.
D. Add CurrentValue and PreviousValue columns to the customer dimension.
Your network contains an Active Directory domain named contoso.com. The domain contains a Microsoft Application Virtualization (App-V) 5.0 infrastructure. You package two complex applications named App1 and App2. You create a connection group that contains App1 and App2. You discover that App2 overwrites some of the registry settings used by App1. You need to recommend a solution for the deployment of App1 and App2 to meet the following requirements:
Prevent App2 from overwriting the registry settings of Appl.
Ensure that App1 and App2 can share information.
What should you recommend?
More than one answer choice may achieve the goal. Select the BEST answer.
A. Change the order of packages in the package library.
B. Modify the PackageId of App1.
C. Change the order of packages in the connection group.
D. Create a single package that contains App1 and App2.
E. Modify the VersionId of App1.
You need to deploy App1 and App2 to the RD Session Host servers. The solution must meet the application requirements. What should you do first?
A. Install Microsoft Silverlight.
B. Install the Windows Internal Database feature.
C. Install the Quality Windows Audio Video feature
D. Install the App-V Remote Desktop Services client.
Case Study: 2
A.Datum Corporation is a geological research company. The company has a main office and a branch office. The main office is located in Seattle. The branch office is located in Miami. Users in the research department work in the Miami office.
The network contains a single-domain Active Directory forest named adatum.com. Network Infrastructure. The relevant servers on the network are configured as shown in the following table.
You need to configure security for the HR users to meet the application requirements What should you configure in Group Policy Management Editor?
A. Security Options
B. Restricted Groups
C. Public Key Policies
D. Application Control Policies