Download Microsoft.70-483.PassGuide.2019-05-29.183q.tqb
| Vendor: | Microsoft |
| Exam Code: | 70-483 |
| Exam Name: | Programming in C# |
| Date: | May 29, 2019 |
| File Size: | 20 MB |
Demo Questions
Question 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?
- Queue<T>
- SortedList
- LinkedList<T>
- HashTable
- Array<T>
Correct answer: A
Explanation:
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 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
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?
- Option A
- Option B
- Option C
- Option D
Correct answer: C
Question 3
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.)
- Insert the following code segment at line 16: while(sqlDataReader.NextResult())
- Insert the following code segment at line 13: sqlConnection.Open();
- Insert the following code segment at line 13: sqlConnection.BeginTransaction();
- Insert the following code segment at line 16: while(sqlDataReader.Read())
- Insert the following code segment at line 16: while(sqlDataReader.GetValues())
Correct answer: BD
Explanation:
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.aspxhttp://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader.read.aspx - 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
