PrepAway - Latest Free Exam Questions & Answers

Author: seenagape

What should you do?

You are a database administrator for AIOTestKing.com. Your company uses a different company’s application that is based on SQL Server 2005 Standard Edition. The application executes a query that uses an index query hint. The index query hint is not suitable for your environment, but you cannot modify the query. You need to force the application to use a different query execution plan. What should you do?

What should you do to correct the problem?

You work as DBA at AIOTestKing.com. You administer two Windows Server 2003 computers named AIOTestKing A and AIOTestKing B. You install SQL Server 2005 on both AIOTestKing A and AIOTestKing B to host a new company database. AIOTestKing A hosts a read-write copy of the company database in which all changes are made. AIOTestKing B subscribes to a publication on AIOTestKing A and is only used for reporting. A Windows domain administrator provides you with a domain user account named SQLSRV to use as the security context for the SQL Server services. A password policy of 42 days exists in the Default Domain Group Policy object (GPO). You install the database on AIOTestKing A and AIOTestKing B and configure replication. Everything works fine for six weeks, but then all SQL Server services fail. You need to correct the problem. What should you do?

Which deployment method should you use?

You use Microsoft .NET Framework 4 to create a Windows application. You use ClickOnce technology to install the application on computers that run Windows 7 with User Access Control (UAC) enabled. The application requires access to environment variables on each computer. You need to ensure that users who do not have administrative permissions can install the application. Which deployment method should you use?

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?

What should you do?

You are designing a Windows application by using Microsoft .NET Framework 4. Remote users have limited network connectivity. Users will not have write permissions to the local file system. You plan to design the error logging strategy for the application. You need to ensure that the application can collect error information. You also need to ensure that the errors can be analyzed from a centralized location. What should you do?

What should you do?

You are developing an ASP.NET Web page that contains input controls, validation controls, and a button named btnSubmit.
The page has the following code-behind. (Line numbers are included for reference only.)

01 public partial class _Default : System.Web.UI.Page
02 {
03 protected void SaveToDatabase()
04 {
05
06 }
07
08 protected void btnSubmit_Click(object sender, EventArgs e)
09 {
10
11 }
12 }

You need to ensure that all data that is submitted passes validation before the data is saved in a database.
What should you do?