Download Microsoft.70-483.PracticeTest.2019-02-10.180q.tqb
| Vendor: | Microsoft |
| Exam Code: | 70-483 |
| Exam Name: | Programming in C# |
| Date: | Feb 10, 2019 |
| File Size: | 19 MB |
Demo Questions
Question 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?
- Option A
- Option B
- Option C
- Option D
Correct answer: C
Question 2
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?
- Where order.OrderDate.Value != null && order.OrderDate.Value.Year >= year
- Where order.OrderDate.Value == null && order.OrderDate.Value.Year == year
- Where order.OrderDate.HasValue && order.OrderDate.Value.Year == year
- Where order.OrderDate.Value.Year == year
Correct answer: A
Explanation:
* 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 * 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 3
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?
- var fs = File.Open(Filename, FileMode.OpenOrCreate, FileAccess.Read,FileShare.ReadWrite);
- var fs = File.Open(Filename, FileMode.Open, FileAccess.Read,FileShare.ReadWrite);
- var fs = File.Open(Filename, FileMode.OpenOrCreate, FileAccess.Read,FileShare.Write);
- var fs = File.ReadAllLines(Filename);
- var fs = File.ReadAllBytes(Filename);
Correct 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. 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. References: http://msdn.microsoft.com/pl-pl/library/system.io.fileshare.aspxhttp://msdn.microsoft.com/en-us/library/system.io.filemode.aspx 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.
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.
References:
http://msdn.microsoft.com/pl-pl/library/system.io.fileshare.aspx
http://msdn.microsoft.com/en-us/library/system.io.filemode.aspx
