Microsoft Microsoft Certifications 98-361 Questions & Answers

• Question 151:

  You have a class with a property.

  You need to ensure that consumers of the class can write to the value of the property.

  Which keyword should you use?

  A. value

  B. add

  C. get

  D. set

  Correct Answer: A

• Question 152:

  This question requires that you evaluate the underlined text to determine if it is correct.

  Internet Information Services (IIS) must be installed on the client computers in order to run a deployed ASP.NET application.

  Select the correct answer if the underlined text does not make the statement correct. Select "No change is needed" if the underlined text makes the statement correct.

  A. No change is needed

  B. computer that hosts the application

  C. computer that you plan to deploy from

  D. Application Layer Gateway Service

  Correct Answer: B

• Question 153:

  Which programming language is characterized as client-side, dynamic and weakly typed?

  A. JavaScript

  B. HTML

  C. ASP.NET

  D. C#

  Correct Answer: D

• Question 154:

  This question requires that you evaluate the underlined text to determine if it is correct.

  A piece of text that is 4096 bytes or smaller and is stored on and retrieved from the client computer to maintain state is known as a ViewState.

  Select the correct answer if the underlined text does not make the statement correct. Select "No change is needed'' if the underlined text makes the statement correct.

  A. No change is needed

  B. cookie

  C. form post

  D. QueryString

  Correct Answer: B

• Question 155:

  This question requires that you evaluate the underlined text to determine if it is correct.

  The benefit of using a transaction when updating multiple tables is that the update cannot fail.

  Select the correct answer if the underlined text does not make the statement correct. Select "No change is needed" if the underlined text makes the statement correct.

  A. No change is needed

  B. succeeds or fails as a unit

  C. finishes as quickly as possible

  D. can be completed concurrently with other transactions

  Correct Answer: B

• Question 156:

  What are two advantages of normalization in a database? (Choose two)

  A. prevents data inconsistencies

  B. reduces schema limitations

  C. minimizes impact of data corruption

  D. decreases space used on disk

  Correct Answer: AB

• Question 157:

  This question requires that you evaluate the underlined text to determine if it is correct.

  Unit testing is the final set of tests that must be completed before a feature or product can be considered finished.

  Select the correct answer if the underlined text does not make the statement correct. Select "No change is needed'' if the underlined text makes the statement correct.

  A. No change is needed

  B. User acceptance

  C. System

  D. Integration

  Correct Answer: B

• Question 158:

  You need to create a stored procedure that passes in a person's name and age.

  Which statement should you use to create the stored procedure?

  

  A. B. C. D.

  Correct Answer: A

• Question 159:

  You have a SQL Server database named MyDB that uses SQL Server Authentication.

  Which connection string should you use to connect to MyDB?

  A. Data Source=MyDB; UserID=username; Password=P@sswOrd; Initial Catalog=Sales

  B. Data Source=MyDB; Integrated Security=SSPI; Initial Catalog=Sales

  C. Data Source=MyDB; Integrated Security=True; Initial Catalog=Sales

  D. Data Source=MyDB; Trusted_Connection=True; MultipleActiveResultSets=True; Initial Catalog=Sales

  Correct Answer: A

• Question 160:

  You are developing a database that other programmers will query to display race results.

  You need to provide the ability to query race results without allowing access to other information in the database.

  What should you do?

  A. Disable implicit transactions.

  B. place the query jnt0 a stored procedure.

  C. Create an index on the result table.

  D. Add an AFTER UPDATE trigger on the result table to reject updates.

  Correct Answer: A