Which two actions should you perform?
You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package.
The package uses at least one sequence container in one transaction. Each transaction controls a Data Flow task and a Control Flow task. Each Data Flow task has a Success constraint.
The Control Flow task follows the Success constraint. The package must include the following requirements:
Each Data Flow task must use its own transaction.
The Control Flow task and the Data Flow task that precedes it must succeed or fail as an atomic unit.
A restart point must restart each Data Flow task and the Control Flow task that follows it as an atomic unit.
You need to make changes in the control flow designer to meet the outlined requirements.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
?
You are developing an application to update a users social status. You need to consume the service using Windows Communication Foundation (WCF).
The client configuration is as follows.
<system.serviceModel>
<bindings>
<webHttpBinding>
<binding name=”SocialConfig”>
<security mode=”TransportCredentialOnly”>
<transport clientCredentialType=”Basic”
?realm=”Social API” />
</security>
</binding>
</webHttpBinding>
</bindings>
<client>
<endpoint address=”http://contoso.com”
binding=”webHttpBinding”
bindingConfiguration=”SocialConfig”
contract=”ISocialStatus”
name=”SocialClient” />
</client>
</system.serviceModel>
The service contract is defined as follows.
[ServiceContract]
public interface ISocialStatus
{
[OperationContract]
[WebInvoke(UriTemplate =
“/statuses/update.xml?status={text}”)]
void UpdateStatus(string text);
}
Which code segment should you use to update the social status?
What should you do?
You are a database administrator for AIOTestKing.com. One of the databases on a SQL Server 2005 computer contains a stored procedure. Users run this stored procedure to import data into a table. The stored procedure needs to use the TRUNCATE TABLE command before importing new data into the table. However, the users who run the stored procedure do not have permission to truncate the table. You need to provide a way for the stored procedure to truncate the table before it imports new data. What should you do?
Which message encoding should you use?
A Windows Communication Foundation (WCF) service is responsible for transmitting XML documents between systems. The service has the following requirements: It must minimize the transmission size by attaching the XML document as is without using escape characters or base64 encoding. It must interoperate with systems that use SOAP but are not built on the .NET platform. You need to configure the service to support these requirements. Which message encoding should you use?
Which three tasks should you perform?
You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package.
While testing, a Transact-SQL user-defined function causes duplicate key values that stop the transformation.
To permit the transformation to continue, the package must perform the following tasks:
1 Ascertain which rows are affected.
2 Insert the rows that fail into a table.
3 Continue with the process.
You need to change certain properties in the package to meet the requirements.
Which three tasks should you perform? (Each correct answer presents part of the solution. Choose three.)
What should you do?
You are creating a Windows Communication Foundation (WCF) service that is implemented as follows. (Line numbers are included for reference only.)
01 [ServiceContract]
02 [ServiceBehavior(IncludeExceptionDetailsInFaults = true)]
03 public class OrderService
04 {
05 [OperationContract]
06 public void SubmitOrder(Order anOrder)
07 {
08 try
09 {
10
11 }
12 catch(DivideByZeroException ex)
13 {
14
15 }
16 }
17 }
You need to ensure that the stack trace details of the exception are not included in the error information sent to the client.
What should you do?
Which two actions should you perform?
You are a database administrator for AIOTestKing.com. The company runs a popular database-driven Web site against a SQL Server 2005 computer named AIOTestKing B. You need to ensure a quick response time and appropriate audit trail in the event that AIOTestKing B experiences excessive traffic due to denial-of-service (DoS) attacks. Which two actions should you perform? (Each correct answer presents part of the solution.
Choose two.)
What are two possible ways to achieve this goal?
A WCF service code is implemented as follows. (Line numbers are included for reference only.)
01 <ServiceContract()>
02 <ServiceBehavior(
03 InstanceContextMode:=InstanceContextMode.Single)>
04 Public Class CalculatorService
05
06 <OperationContract()>
07 Public Function Calculate(ByVal op1 As Double,
08 ByVal op As String, ByVal op2 As Double) As Double …
24 End Function
25
26 End Class
You need to decrease the response time of the service. What are two possible ways to achieve this goal? (Each correct answer presents a complete solution. Choose two.)
What should you do?
You need to create a package that must meet the following requirements:
It must be transactional. It must be optimized for 20 tables. It must be stored securely in the msdb database of a remote server.
What should you do?
Which XML segment should you add to the system.serviceModel configuration section of the web.config file?
Four Windows Communication Foundation (WCF) services are hosted in Microsoft Internet Information Services (IIS). No behavior configuration exists in the web.config file.
You need to configure the application so that every service and endpoint limits the number of concurrent calls to 50 and the number of concurrent sessions to 25.
Which XML segment should you add to the system.serviceModel configuration section of the web.config file?