Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.

Microsoft 70-483 Exam Actual Questions

The questions for 70-483 were last updated at Aug. 2, 2022.
  • Viewing page 1 out of 55 pages.
  • Viewing questions 1-5 out of 280 questions

Topic 1 - Volume A

Question #1 Topic 1

You are developing an application that includes a class named Order. The application will store a collection of Order objects.
The collection must meet the following requirements:
✑ Use strongly typed members.
✑ Process Order objects in first-in-first-out order.
✑ Store values for each Order object.
✑ Use zero-based indices.
You need to use a collection type that meets the requirements.
Which collection type should you use?

  • A. Queue<T>
  • B. SortedList
  • C. LinkedList<T>
  • D. HashTable
  • E. Array<T>
Reveal Solution Hide Solution   Discussion   14

Correct Answer: A 🗳️
Queues are useful for storing messages in the order they were received for sequential processing. Objects stored in a Queue<T> are inserted at one end and removed from the other.
References: http://msdn.microsoft.com/en-us/library/7977ey2c.aspx

Question #2 Topic 1

You are developing an application. The application calls a method that returns an array of integers named employeeIds. You define an integer variable named employeeIdToRemove and assign a value to it. You declare an array named filteredEmployeeIds.
You have the following requirements:
✑ Remove duplicate integers from the employeeIds array.
✑ Sort the array in order from the highest value to the lowest value.
Remove the integer value stored in the employeeIdToRemove variable from the employeeIds array.

You need to create a LINQ query to meet the requirements.
Which code segment should you use?

  • A. Option A
  • B. Option B
  • C. Option C
  • D. Option D
Reveal Solution Hide Solution   Discussion   6

Correct Answer: C 🗳️

Question #3 Topic 1

You are developing an application that includes the following code segment. (Line numbers are included for reference only.)

The GetAnimals() method must meet the following requirements:
✑ Connect to a Microsoft SQL Server database.
✑ Create Animal objects and populate them with data from the database.
✑ Return a sequence of populated Animal objects.
You need to meet the requirements.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

  • A. Insert the following code segment at line 16: while(sqlDataReader.NextResult())
  • B. Insert the following code segment at line 13: sqlConnection.Open();
  • C. Insert the following code segment at line 13: sqlConnection.BeginTransaction();
  • D. Insert the following code segment at line 16: while(sqlDataReader.Read())
  • E. Insert the following code segment at line 16: while(sqlDataReader.GetValues())
Reveal Solution Hide Solution   Discussion   8

Correct Answer: BD 🗳️
✑ SqlConnection.Open - Opens a database connection with the property settings specified by the ConnectionString.
✑ SqlDataReader.Read - Advances the SqlDataReader to the next record.
References:
http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.open.aspx http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader.read.aspx

Question #4 Topic 1

DRAG DROP -
You are developing a custom collection named LoanCollection for a class named Loan class.
You need to ensure that you can process each Loan object in the LoanCollection collection by using a foreach loop.
How should you complete the relevant code? (To answer, drag the appropriate code segments to the correct locations in the answer area. Each code segment may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.)
Select and Place:

Reveal Solution Hide Solution   Discussion   7

Correct Answer:

Question #5 Topic 1

You are developing an application that uses the Microsoft ADO.NET Entity Framework to retrieve order information from a Microsoft SQL Server database. The application includes the following code. (Line numbers are included for reference only.)

The application must meet the following requirements:
✑ Return only orders that have an OrderDate value other than null.
✑ Return only orders that were placed in the year specified in the OrderDate property or in a later year.
You need to ensure that the application meets the requirements.
Which code segment should you insert at line 08?

  • A. Where order.OrderDate.Value != null && order.OrderDate.Value.Year >= year
  • B. Where order.OrderDate.Value == null && order.OrderDate.Value.Year == year
  • C. Where order.OrderDate.HasValue && order.OrderDate.Value.Year == year
  • D. Where order.OrderDate.Value.Year == year
Reveal Solution Hide Solution   Discussion   23

Correct Answer: A 🗳️
✑ For the requirement to use an OrderDate value other than null use:

OrderDate.Value != null -
✑ For the requirement to use an OrderDate value for this year or a later year use:
OrderDate.Value>= year

Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...