PrepAway - Latest Free Exam Questions & Answers

Author: seenagape

What should you do?

You are a database administrator for AIOTestKing.com. A user named AIOTestKing belongs to the Windows SalesManagers group. AIOTestKing needs a Reporting Services report to display annual sales information by territory. A user named Joe reports to AIOTestKing and belongs to the Windows Sales group. He needs a report that is limited to his sales territory, but still displays the same detailed sales data that is on AIOTestKing’s report. You need to design a secure solution that meets the reporting needs of the users and that consumes the minimal amount of server resources. What should you do?

Which header and request type should you use in the application?

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create a Windows Communication Foundation (WCF) Data Services service. You discover that when an application submits a PUT or DELETE request to the Data Services service, it receives an error. You need to ensure that the application can access the service. Which header and request type should you use in the application?

What should you do?

You are designing a Microsoft SQL Server 2005 Reporting Services (SSRS) report model. Users must develop their own SSRS reports by using your report model in the Report Builder tool. The data source for the report model is a Microsoft SQL Server 2000 database that contains 900 tables and 700 views. You need to build a report model that allows users access to only the 10 tables that they require for reporting. What should you do?

?

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. Your SQL Server 2005 database contains a table named Customer with a column named PostalCode in it. New PostalCode values are added regularly. You need to ensure that values contained in the PostalCode column are verified. You need to retrieve, from the Postal Service in each country in which you have customers, the domain of values for the PostalCode column.
Rapid response time for data access is of primary concern. What should you do?

Which expression should you use?

You are designing a Microsoft SQL Server 2005 Reporting Services (SSRS) report. The report must use a custom assembly to perform real-time lookup and currency conversion. The assembly has a static class named CurrencyConversion that exists in the namespace FinancialCalc. The class has a method named ToEUR that requires two arguments, Currency and CurrencyCode. You need to reference the ToEUR method in an expression to convert USD to EURO when the report runs. Which expression should you use?

What should you do?

You are creating a Windows Communication Foundation (WCF) service that accepts messages from
clients when they are started.
The message is defined as follows.
[MessageContract] public class Agent {
public string CodeName { get; set; }
http://www.test4pass.com Leading the way in IT Certification Exams
public string SecretHandshake { get; set; }
}
You have the following requirements:
“The CodeName property must be sent in clear text.
The service must be able to verify that the property value was not changed after being sent by the client.
“The SecretHandshake property must not be sent in clear text and must be readable by the service.
What should you do?