What should you do?
You are a database administrator for AIOTestKing.com. A SQL Server 2005 computer named AIOTestKing A has a database named Inventory. AIOTestKing A is responsible for aggregating manufacturing part numbers from your company’s trading partners. The manufacturing part numbers are stored in the Product table in the Inventory database. Every night, data is sent as text files from each trading partner to AIOTestKing.
You need to import data and ensure that no duplicate manufacturing part numbers exist in the data imported from the text files that are stored in the Inventory database on AIOTestKing.
You want to achieve this goal with the minimum amount of impact on your company’s trading partners and your IT department. What should you do?
Which code segment should you insert at line 03?
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. You are creating the data layer of the application. You write the following code segment. (Line numbers are included for reference only.)
01 Public Shared Function GetDataReader(sql As String) As SqlDataReader
02 Dim dr As SqlDataReader = Nothing
03
04 Return dr
05 End Function
You need to ensure that the following requirements are met: The SqlDataReader returned by the GetDataReader method can be used to retrieve rows from the database. SQL connections opened within the GetDataReader method will close when the SqlDataReader is closed. Which code segment should you insert at line 03?
What should you do?
You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package. The package is named UpdateTable.dtsx and contains a variable named runID. The package must run by using the dtexec utility. The runID variable must be set at runtime to a value of 5. You need to meet the outlined requirements. What should you do?
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(
03InstanceContextMode:=InstanceContextMode.Single)>
04Public Class CalculatorService
05
06 <OperationContract()>
07Public Function Calculate(ByVal op1 As Double,
08ByVal op As String, ByVal op2 As Double) As Double
24End Function
25
26End Class
You need to increase the rate by which clients get the required response from the service.
What are two possible ways to achieve this goal? (Each correct answer presents a complete solution.
Choose two.)
What should you do first?
You are a database administrator for AIOTestKing.com. You notice that one of the data files on a SQL Server 2005 computer is corrupted. You need to restore the database from the most recent set of backups. You want to perform this task as quickly as possible, with a minimum loss of data. What should you do first?
Which code segment should you use?
You use Microsoft .NET Framework 4 to create a Windows Presentation Foundation (WPF) application. You write the following code fragment.
<StackPanel TextBox.PreviewTextInput=”StackPanel_PreviewTextInput”>
<TextBox Name=”TxtBoxA”/>
<TextBox Name=”TxtBoxB”/>
<TextBox Name=”TxtBoxC”/>
</StackPanel>
You create an event handler named StackPanel_PreviewTextInput. You also have a collection of strings named Keywords. You need to ensure that TxtBoxA and TxtBoxB do not contain any of the strings in the Keywords collections. Which code segment should you use?
Which two actions should you perform?
You are designing a Microsoft SQL Server 2005 Integration Services (SSIS)package.The OLE DB
data source for the package is a database that is updated frequently.You need to create a package that
accomplishes the following tasks:
Implement the IRowsetFastLoad interface.Support various data flow destinations. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
What should you do?
Windows Communication Foundation (WCF) application uses a data contract that has several data
members. You need the application to throw a Serialization Exception if any of the data members are not
present when a serialized instance of the data contract is deserialized. What should you do?
What should you do?
You are a database administrator for AIOTestKing.com. You have separate SQL Server 2005 development and production environments. You use the Business Intelligence Development Studio to create a SQL Server Integration Services (SSIS) package in your development environment. Then, you use the SSIS package to import data into your development environment from one of your company’s trading partners. You need to deploy the SSIS package to your production environment. Your production environment uses different table names than your development environment. What should you do?
Which element should you add to the system.serviceModel section in the application configuration file?
You are moving a Windows Communication Foundation (WCF) service into production. You need to be able to monitor the health of the service. You only want to enable all performance counter instances exposed by the ServiceModelService 4.0.0.0 counter group. Which element should you add to the system.serviceModel section in the application configuration file?