Q1. DRAG DROP - (Topic 4)
You are developing an ASP.NET MVC Web API image management application.
The application must meet the following requirements:
It must send or receive image data without the use of a buffer.
It must allow up to 4 MB of image data to be received.
It must allow up to 3 MB of image data to be sent.
You need to complete the code to meet the requirements.
What should you do? (To answer, drag the appropriate code segments to the correct location or 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:
Q2. - (Topic 4)
You are developing an ASP.NET MVC application. The application has a page that updates an image stored in a database. Members of the EntityClient namespace are used to access an ADO.NET Entity Framework data model. Images and associated metadata are stored in a single database table.
You need to run a single query that updates an image and associated metadata in the
database while returning only the number of affected rows.
Which method of the EntityCommand type should you use?
A. ExecuteNonQuery()
B. ExecutcScalar()
C. ExecuteDbDataReader()
D. ExecuteReader()
Answer: A
Q3. - (Topic 1)
Errors occasionally occur when saving data using the FlightInfoContext ADO.NET Entity Framework context. Updates to the data are being lost when an error occurs.
You need to ensure that data is still saved when an error occurs by retrying the operation. No more than five retries should be performed.
Which code segment should you use as the body of the SaveChanges() method in the FlightInfoContext.es file?
A. Option A
B. Option B
C. Option C
D. Option D
Answer: A
Q4. - (Topic 4)
You are developing an ASP.NET MVC application. The application is a loan processing system that uses the ADO.NET Entity Framework against a SQL Server database. It has a controller that loads a page that displays all loans along with rate information. Lazy loading has been disabled.
The Loan class is shown below.
You need to return the loans and rate information in a single round trip to the database. Which code segment should you use?
A. Option A
B. Option B
C. Option C
D. Option D
Answer: B
Q5. - (Topic 4)
You are building an ADO.NET Entity Framework application.
You need to validate the conceptual schema definition language (CSDL), store schema definition language (SSDL), and mapping specification language (MSL) files.
Which Entity Data Model tool can you use? (Each correct answer presents a complete solution. Choose all that apply.)
A. EDM Generator (EdmGen.exe)
B. ADO.NET Entity Data Model Designer
C. Entity Data Model Wizard
D. Update Model Wizard
Answer: A,B
Q6. HOTSPOT - (Topic 4)
You are updating an existing multitenant ASP.NET MVC application for medical clinics. The application aggressively uses output caching to improve performance by caching content for 36 hours. The application uses a query string parameter named "clinicID" that contains the clinic that the user is currently viewing.
Users report that they are occasionally seeing data for the wrong clinic. Users also report that sensitive data is stored in the browser cache folder on their computers.
You need to configure web.config to resolve the reported problems.
You have the following markup: Which markup segments should you include in Target 1, Target 2 and Target 3 to complete the markup? (To answer, select the correct markup segment from each drop-down list in the answer area.)
Answer:
Q7. - (Topic 3)
You need to update the CreateMonthlyTotalsReports() method to use database transactions.
Which code segment should you use?
A. SqlConnection.BeginTransaction(IsolationLevel.ReadCommitted);
B. SqlConnection.BeginTransaction(IsolationLevel.ReadUnconwited);
C. SqlConnection.BeginTransaction(IsolationLevel.Chaos);
D. SqlConnection.BeginTransaction(IsolationLevel.Serializable);
Answer: D
Explanation: * Scenario: The Create MonthlyTotalsReport() method must lock the data and prevent others from updating or inserting new rows until complete.
* Serializable:
A range lock is placed on the DataSet, preventing other users from updating or inserting
rows into the dataset until the transaction is complete.
Q8. DRAG DROP - (Topic 4)
You are developing an ASP.NET MVC Web API application.
The application must meet the following requirements:
It must send or receive data without the use of a buffer.
It must allow up to 1 MB of data to be received.
It must allow up to 2 MB of data to be sent.
You need to complete the code to meet the requirements.
What should you do? (To answer, drag the appropriate code segments to the correct location or 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:
Q9. DRAG DROP - (Topic 1)
Historical flight information data will be stored in Windows Azure Table Storage using the FlightInfo class as the table entity.
There are millions of entries in the table. Queries for historical flight information specify a set of airlines to search and whether the query should return only late flights. Results should be ordered by flight name.
You need to specify which properties of the FlightInfo class should be used at the partition and row keys to ensure that query results are returned as quickly as possible.
What should you do? (To answer, drag the appropriate properties to the correct location or locations in the answer area. Each property 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:
Q10. - (Topic 2)
You need to modify the ExecuteCommandProcedure() method to meet the technical requirements.
Which code segment should you use?
A. Option A
B. Option B
C. Option C
D. Option D
Answer: A