2020 Latest Microsoft 70-483 Exam Questions
                     Micros oft
70-48 3
Programming in C#
 
 
https://www.realexamcollection.com/microsoft/70-483-dumps.htm
 
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? 
 
A. Queue 
B. SortedList 
C. LinkedList 
D. HashTable 
E. Array 
 
Answer: A     
 
Explanation: 
Queues are useful for storing messages in the order they were received for sequential processing. 
Objects stored in a Queue are inserted at one end and removed from the other. 
Reference: 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? 
 
 
 
A. Option A 
B. Option B 
C. Option C 
D. Option D 
 
Answer: C     
 
The Distinct keyword avoids duplicates, and OrderByDescending provides the proper ordering from 
highest to lowest. 
 
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.) 
 
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()) 
 
Answer: B, D     
 
Explanation: 
B: SqlConnection.Open - Opens a database connection with the property settings specified by the 
ConnectionString. 
Reference: http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.open.aspx 
D: SqlDataReader.Read - Advances the SqlDataReader to the next record. Reference: 
http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader.read.aspx 
 
Question: 4 
   
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.) 
 
 
 
Answer:      
 
 
 
 
Question: 5 
   
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 
 
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 
 
Question: 6 
   
DRAG DROP 
You are developing an application by using C#. The application includes an array of decimal values 
named loanAmounts. You are developing a LINQ query to return the values from the array. 
The query must return decimal values that are evenly divisible by two. The values must be sorted from 
the lowest value to the highest value. 
You need to ensure that the query correctly returns the decimal values. 
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.) 
 
 
 
Answer:      
 
Box 1: from 
Box 2: where 
Box 3: orderby 
Box 4: ascending 
Box 5: select 
Note: In a query expression, the orderby clause causes the returned sequence or subsequence (group) 
to be sorted in either ascending or descending order. 
Examples: 
// Query for ascending sort. 
        IEnumerable sortAscendingQuery = 
            from fruit in fruits 
            orderby fruit //"ascending" is default 
            select fruit; 
        // Query for descending sort. 
        IEnumerable sortDescendingQuery = 
            from w in fruits 
            orderby w descending 
            select w;         
 
Question: 7 
   
You are developing an application. The application includes a method named ReadFile that reads data 
from a file. 
The ReadFile() method must meet the following requirements: 
It must not make changes to the data file. 
It must allow other processes to access the data file. 
It must not throw an exception if the application attempts to open a data file that does not exist. 
You need to implement the ReadFile() method. 
Which code segment should you use? 
 
 
A. var fs = File.Open(Filename, FileMode.OpenOrCreate, FileAccess.Read, 
FileShare.ReadWrite); 
B. var fs = File.Open(Filename, FileMode.Open, FileAccess.Read, 
FileShare.ReadWrite); 
C. var fs = File.Open(Filename, FileMode.OpenOrCreate, FileAccess.Read, 
FileShare.Write); 
D. var fs = File.ReadAllLines(Filename); 
E. var fs = File.ReadAllBytes(Filename); 
 
Answer: A     
 
Explanation: 
FileMode.OpenOrCreate - Specifies that the operating system should open a file if it exists; otherwise, a 
new file should be created. If the file is opened with FileAccess.Read, FileIOPermissionAccess.Read 
permission is required. If the file access is FileAccess.Write, FileIOPermissionAccess.Write permission is 
required. If the file is opened with FileAccess.ReadWrite, both FileIOPermissionAccess.Read and 
FileIOPermissionAccess.Write permissions are required. 
http://msdn.microsoft.com/en-us/library/system.io.filemode.aspx 
FileShare.ReadWrite - Allows subsequent opening of the file for reading or writing.If this flag is not 
specified, any request to open the file for reading or writing (by this process or another process) will fail 
until the file is closed.However, even if this flag is specified, additional permissions might still be needed 
to access the file. 
http://msdn.microsoft.com/pl-pl/library/system.io.fileshare.aspx 
 
Question: 8 
   
An application receives JSON data in the following format: 
 
The application includes the following code segment. (Line numbers are included for reference only.) 
 
You need to ensure that the ConvertToName() method returns the JSON input string as a Name object. 
Which code segment should you insert at line 10? 
 
 
A. Return ser.ConvertToType(json); 
B. Return ser.DeserializeObject(json); 
C. Return ser.Deserialize(json); 
D. Return (Name)ser.Serialize(json); 
 
Answer: C     
 
Explanation: 
JavaScriptSerializer.Deserialize - Converts the specified JSON string to an object of type T. 
http://msdn.microsoft.com/en-us/library/bb355316.aspx 
 
Question: 9 
   
DRAG DROP 
An application serializes and deserializes XML from streams. The XML streams are in the following 
format: 
 
The application reads the XML streams by using a DataContractSerializer object that is declared by the 
following code segment: 
var ser = new DataContractSerializer(typeof(Name)); 
You need to ensure that the application preserves the element ordering as provided in the XML stream. 
How should you complete the relevant code? (To answer, drag the appropriate attributes to the correct 
locations in the answer area-Each attribute 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.) 
 
 
Answer:  
 
 
Explanation: 
Target 1: The DataContractAttribute.Namespace Property gets or sets the namespace for the data 
contract for the type. Use this property to specify a particular namespace if your type must return data 
that complies with a specific data contract. 
Target2, target3: We put Order=10 on FirstName to ensure that LastName is ordered first. 
Note: 
The basic rules for data ordering include: 
* If a data contract type is a part of an inheritance hierarchy, data members of its base types are always 
first in the order. 
* Next in order are the current type’s data members that do not have the Order property of the 
DataMemberAttribute attribute set, in alphabetical order. 
* Next are any data members that have the Order property of the DataMemberAttribute attribute set. 
These are ordered by the value of the Order property first and then alphabetically if there is more than 
one member of a certain Order value. Order values may be skipped. 
Reference: Data Member Order 
https://msdn.microsoft.com/en-us/library/ms729813(v=vs.110).aspx 
Reference: DataContractAttribute.Namespace Property 
https://msdn.microsoft.com/en-
us/library/system.runtime.serialization.datacontractattribute.namespace(v=vs.110).aspx 
 
 
Question: 10 
You are developing an application. The application converts a Location object to a string by using a 
method named WriteObject. The WriteObject() method accepts two parameters, a Location object and 
an XmlObjectSerializer object. 
The application includes the following code. (Line numbers are included for reference only.) 
 
You need to serialize the Location object as a JSON object. 
Which code segment should you insert at line 20? 
 
A. New DataContractSerializer(typeof(Location)) 
B. New XmlSerializer(typeof(Location)) 
C. New NetDataContractSenalizer() 
D. New DataContractJsonSerializer(typeof(Location)) 
 
Answer: D     
 
https://www.realexamcollection.com/microsoft/70-483-dumps.html