Which package property should you set?
You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package. You create a table and populate the table with the required data. You receive an error message “destination table not found” when you run the package without the package destination objects. You need to set a package property that runs the package without giving the “destination table not found” error message when the configuration setting of the Connection Manager fails. Which package property should you set?
Which approach should you recommend?
You are designing a data access service backed by Microsoft SQL Server. Other developers will use your service as a third-party service.
You have the following requirements:
To reduce maintenance cost, you must write the minimal amount of code required for fulfilling the goals.
The service must function with Microsoft and non-Microsoft technologies.
The service must implement the WS-Security standards.
You need to design the service to meet the requirements.
Which approach should you recommend?
What should you do?
You are a database administrator for AIOTestKing.com. Your company owns a chain of 10 retail stores. Each retail store maintains point-of-sale transactions on its own SQL Server 2005 computer, in a database table named Sales. The Sales table also contains sales data from other stores to enable customer returns to any of the 10 retail stores. The sales data is refreshed from the main office to each retail store hourly. A trigger named trg_Coupon on the Sales table is used to generate sales coupons based on customer sales and buying patterns. You need to configure replication between the server in each retail store and a central server in the main office by using the fewest number of steps. Replication does not have to be in real time. What should you do?
What should you do?
You are analyzing a Windows client application that uses Microsoft Visual Studio 2010 and Microsoft SQL Server 2008. The application updates two database tables from the main user interface (UI) thread. You need to ensure that the following requirements are met:
* The database tables are either updated simultaneously or not updated at all.
* Users are notified of the success or failure of the updates.
* Users are able to perform other tasks during the update process.
What should you do?
What should you do?
You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package. You need to ensure that the package came from a trusted source. What should you do?
What should you do?
You are creating a Windows Communication Foundation (WCF) service to process orders.
The data contract for the order is defined as follows.
[DataContract]
public class Order {
[DataMember] public string CardHolderName { get; set; [DataMember]
public string CreditCardNumber { get; set; }
}
You have the following requirements:
“Enable the transmission of the contents of Order from the clients to the service.
“Ensure that the contents of CreditCardNumber are not sent across the network in clear text.
“Ensure that the contents of CreditCardNumber are accessible by the service to process the order.
You need to implement the service to meet these requirements.
What should you do?
which business analyst is causing the problem. What are two possible ways to achieve this goal?
You are a database administrator for AIOTestKing.com. The company has a SQL Server 2005 computer named AIOTestKing A database on AIOTestKing A stores sales history data for the company’s Web-based order system. Twenty of the business analysts in the company create ad hoc queries against the database. The performance of AIOTestKing A is routinely slow. You need to find out which business analyst is causing the problem. What are two possible ways to achieve this goal? (Each correct answer presents a complete solution.
Choose two.)
Which class should you use?
You are building a client for a Windows Communication Foundation (WCF) service. You need to create a proxy to consume this service. Which class should you use?
What should you do?
You create 25 Microsoft SQL Server 2005 Integration Services (SSIS) packages on the development server. You decide to deploy the SSIS packages on the test server. You need to create a repeatable process that will allow you to deploy the packages to the package store on the test server if the packages change.
You also need to ensure that this is achieved with minimum effort. What should you do?
Which two actions should you perform?
You are adding a Windows Communication Foundation (WCF) service to an existing application. The application is configured as follows. (Line numbers are included for reference only.)
01 <configuration>
02 <system.serviceModel>
03 <services>
04 <service name=”Contoso.Sales.StockService”
05 behaviorConfiguration=”MetadataBehavior”>
06 <host>
07 <baseAddresses>
08 <add
baseAddress=”http://contoso.com:8080/StockService” />
09 </baseAddresses>
10 </host>
11 </service>
12 </services>
13 <behaviors>
14 <serviceBehaviors>
15 <behavior name=”MetadataBehavior”>
16 </behavior>
17 </serviceBehaviors>
18 </behaviors>
You need to configure the service to publish the service metadata.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)