Which three actions should you perform?
You are a database administrator for AIOTestKing.com. A software developer in the company is running the following query against a SQL Server 2005 database. SELECT Surname FROM Employees WHERE UPPER(Surname) LIKE ‘COR%’ The software developer reports that the query runs quickly on a test database that has a small number of rows. However, the query runs very slowly on the production database that has millions of rows. The Surname column stores data in mixed case, by using case-sensitive collation. But the query needs to perform a case-insensitive search. You need to improve the performance of this query. However, you do not have permission to change the collation orders. And you cannot modify the application code that adds rows to the database. Which three actions should you perform? (Each correct answer presents part of the solution. Choose three.)
Which code segment should you use?
You are consuming a Windows Communication Foundation (WCF) service in an ASP.NET Web application. The service interface is defined as follows.
<ServiceContract()>
Public Interface ICatalog
<OperationContract()>
<WebGet(UriTemplate:=”/Catalog/Items/{id}”, ResponseFormat:=WebMessageFormat.Json)>
Function RetrieveItemDescription(ByVal id As Integer) As String
End Interface
The service is hosted at /Catalog.svc. You need to call the service using jQuery to retrieve the description of an item as indicated by a variable named itemId. Which code segment should you use?
Which expression should you use?
You are designing a Microsoft SQL Server 2005 Reporting Services (SSRS) accounting report.
Every other line of output in the report table must have a green background. You need to use the appropriate expression for the BackgroundColor property of the table. Which expression should you use?
What should you do?
Your Windows Communication Foundation (WCF) client application uses HTTP to communicate with the service. You need to enable message logging and include all security information such as tokens and nonces in logged messages.
What should you do?
What should you do?
You are a database administrator for AIOTestKing.com. You are responsible for managing 10 SQL Server 2005 computers that run Microsoft Windows Server 2003, Enterprise Edition. The company’s Microsoft Active Directory administrators handle all Group Policy object (GPO) deployments. The Active Directory administrators have deployed a security template named SQL05_Security.inf that has the appropriate settings to meet the company’s security policy. You need to identify the existing configuration of each SQL Server 2005 computer to ensure that it meets the company’s security policy. What should you do?
What should you do?
You are designing a complex and critical Windows desktop application by using Microsoft .NET Framework 4 and Microsoft Visual Studio 2010. You plan to implement a logging strategy for the application. You need to record all unexpected errors that occur in the application. What should you do?
What should you do?
You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package. The package is connected to a database on your development server by using a connection manager. You decide to use the DTExecUI utility to run the package. You need to change the connection of the connection manager to a different server at run time without using a package configuration file. What should you do?
What should you do?
You are creating a Windows Communication Foundation (WCF) service that implements operations in a
RESTful manner.
You need to add a delete operation.
You implement the delete method as follows.
string void DeleteItems(string id);
You need to configure WCF to call this method when the client calls the service with the HTTP DELETE
operation. What should you do?
What should you do?
You are a database administrator for AIOTestKing.com. The company hosts SQL Server 2005 databases for subscription-based customers. New customer databases are created frequently. Databases are removed when customers subscriptions end. Company managers want to track who creates each database and when each database is created. To store this information, you create a SQL Server database named Logging. You need to ensure that the appropriate information is written to the Logging database. What should you do?
What should you do?
You are designing an application by using Windows Presentation Foundation (WPF) and Microsoft .NET Framework 4. The application retrieves customer data from an enterprise resource planning (ERP) system. You need to ensure that the following requirements are met:
* Customer data is retrieved only once.
* Customer data is available on multiple forms within the application.
* Forms can implement TwoWay binding to the customer data.
What should you do?