What should you do?
You work as DBA at AIOTestKing.com. You administer two SQL Server 2005 computers named AIOTestKing A and AIOTestKing B. AIOTestKing A and AIOTestKing B contain a copy of a database named Sales. The database is replicated between AIOTestKing A and AIOTestKing B by using transactional replication. A full backup of each database is performed every night.
Transaction log backups are performed every hour. Replication latency is typically less than two minutes. One afternoon, the Sales database on AIOTestKing A becomes corrupted.
You are unable to repair the database. The Sales database on AIOTestKing B is unaffected.
You need to return the Sales database on AIOTestKing A to normal operation as quickly as possible. You must ensure a minimum loss of data and minimal impact to users of either server. What should you do?
What should you do?
A Windows Communication Foundation (WCF) service has a callback contract. You are developing a client application that will call this service. You must ensure that the client application can interact with the WCF service. What should you do?
What should you do?
You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package. The package contains 30 Data Flow tasks and 30 Control Flow tasks. The package runs slower than expected. You need to capture the start time, the finish time, and the elapsed time for the validation
and execution of the package. What should you do?
What should you do?
The endpoint of a Windows Communication Foundation (WCF) service uses basicHttpBinding for its binding. Your company’s policies have changed to require that messages not be sent in clear text.
You must ensure that all messages are encrypted when traveling across the network.
What should you do?
Which Transact-SQL statement should you use?
You are a database administrator for AIOTestKing.com. You are responsible for a SQL Server 2005 database that has several indexes. You need to write a stored procedure that checks the indexes for fragmentation. Which Transact-SQL statement should you use?
What should you design?
You are designing an application by using Microsoft .NET Framework 4 and Microsoft Visual Studio 2010. You plan to design an instrumentation strategy for the application. You need to ensure that the strategy meets the following requirements: Captures detailed performance information. Enables or disables diagnostic messages by using an application configuration option without requiring the application to restart. What should you design?
Which three actions should you perform?
You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package.
The package has the following features:
Two Data Flow tasks and two Control Flow tasksA success constraint between each Data Flow task and the subsequent Control Flow task
The package uses one transaction for all the tasks.
You need to configure the package so that the two Data Flow tasks use their own transactions. You also need to ensure that each Control Flow task is enlisted in the same transaction as its preceding Data Flow task.
Which three actions should you perform? (Each correct answer presents part of the solution.
Choose three.)
Which XML segment should you add to the system.serviceModel/diagnostics/messageLogging/filters configuration e
A Windows Communication Foundation (WCF) service has the following contract.
[ServiceContract(Namespace=”http://contoso.com”)]
public interface IShipping
{
[OperationContract]
string DoWork(int id);
}
This is one of several service contracts hosted by your application. All endpoints use SOAP 1.2 bindings with WS-Addressing 1.0. The System.ServiceModel.MessageLogging trace source in the system.diagnostics configuration section is configured with one listener.
You need to make sure that only the messages that are returned from the DoWork operation are logged.
Which XML segment should you add to the system.serviceModel/diagnostics/messageLogging/filters configuration element?
What are two possible ways to achieve this goal?
You are a database administrator for AIOTestKing.com. Your SQL Server 2005 computer contains one user database that holds sales transaction information. Users report that the queries and stored procedures that they use every day are taking progressively longer to execute. You also notice that the amount of free disk space on the SQL Server computer is decreasing. You need to create a maintenance plan to correct the performance and storage problems. What are two possible ways to achieve this goal? (Each correct answer presents a complete solution. Choose two.)
Which two actions should you perform?
You use Microsoft .NET Framework 4 to create a Windows application. You plan to deploy the application by using Trusted Application Deployment. The application can only be installed by users who have elevated permissions. You need to ensure that users are not prompted for additional permissions when they install the application. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)