Mon. Nov 18th, 2019

Samir Daoudi's Technical Blog

SharePoint, Office 365, C#, .Net, SQL Server News, Tips, Ebooks, Events, Webinars ….etc

Exam preparation 70-486 covering all the exam topics

  Implement data storage in Windows Azure Create and implement a WCF Data Services service Query data by using LINQ to Entities. Create a WCF service Configure WCF services by using the API                

Description

This is my own preparation guide for MCSD – Exam 70-487 – Developing Windows Azure and Web Services. I have compiled materials and guides from other people such as Chris Myers and Tobias Nilsson (their websites are on bottom of this document)and also googled the content of the exam and organized it by the topics of the exam that are in Microsoft learning website.

I’m sharing this document because it can be useful for someone else.

Any Tips or Feedbacks are welcome.

 

If you haven’t taken the MCSD – Exam 70-486: Developing ASP.NET MVC 4 Web Applications exam yet, check out My 70-486 Guide .

Summary

Description

Summary

Skills Being Measured

Accessing Data (24%)

Choose data access technologies

Implement caching

Implement transactions

Implement data storage in Windows Azure

Study Resource

Create and implement a WCF Data Services service

Manipulate XML data structures

Querying and Manipulating Data by Using the Entity Framework (20%)

Query and manipulate data by using the Entity Framework.

Query and manipulate data by using Data Provider for Entity Framework

Query data by using LINQ to Entities.

Query and manipulate data by using ADO.NET

Create an Entity Framework data model.

Designing and Implementing WCF Services (19%)

Study resource

WCF Links resource

Create a WCF service

Servicecontract and mainly properties

Operation Contract and mainly properties*

Examples

Configure WCF services by using configuration settings

Configure WCF services by using the API

Secure a WCF service

Consume WCF services

Version a WCF service

Create and configure a WCF service on Windows Azure

Implement messaging patterns

Host and manage services

Creating and Consuming Web API-based services (18%)

Study Resource

Design a Web API

Implement a Web API

Secure a Web API

Host and manage Web API

Consume Web API web services

Deploying Web Applications and Services (19%)

Design a deployment strategy

Choose a deployment strategy for a Windows Azure web application

Configure a web application for deployment

Manage packages by using NuGet

Create, configure, and publish a web package

Share assemblies between multiple applications and servers

Other Sites

PDFS/Ebooks

Document Created By Victor Hugo do V C Mello

 

Skills Being Measured

Accessing Data (24%)

●       Choose data access technologies

  • This objective may include but is not limited to: Choose a technology (ADO.NET, Entity Framework, WCF Data Services) based on application requirements

●       Implement caching

  • This objective may include but is not limited to: Cache static data, apply cache policy (including expirations); Use CacheDependency to refresh cache data; query notifications

 

●       Implement transactions

  • This objective may include but is not limited to: manage transactions by using the API from System.Transactions namespace; implement distributed transactions; specify transaction isolation level

 

●       Implement data storage in Windows Azure

○      Study Resource

 

  • This objective may include but is not limited to: access data storage in Windows Azure; Choose data storage mechanism in Windows Azure (blobs, tables, queues, SQL Database); Distribute data by using the Content delivery network (CDN); Handle exceptions by using retries (SQL Database); manage Windows Azure Caching

 

●       Create and implement a WCF Data Services service

  • This objective may include but is not limited to: Address resources; implement filtering; create a query expression; access payload formats (including JSON); use data service interceptors and service operators

Retrieve All Customers

http://localhost:65363/NorthwindService.svc/Customers

 

Retrieve All Products

http://localhost:65363/NorthwindService.svc/Products

 

Retrieve the Customer Whose CustomerID (primary key) is WOLZA

http://localhost:65363/NorthwindService.svc/Customers(‘WOLZA’)

 

Retrieve the Products Whose ProductID (primary key) is 10

http://localhost:65363/NorthwindService.svc/Products(10)

 

Retrieve the CompanyName from the Customer Whose CustomerID (primary key) is QUICK

http://localhost:57087/NorthwindService.svc/Customers(‘QUICK’)/CompanyName

 

Retrieve the Orders (navigation property) for the Customer Whose CustomerID (primary key) is QUICK

http://localhost:57087/NorthwindService.svc/Customers(‘QUICK’)/Orders

 

Retrieve the Supplier’s CompanyName from the Supplier (navigation property) of Product 1 (primary key)

http://localhost:57087/NorthwindService.svc/Products(1)/Supplier/CompanyName

 

Retrieve the Count of Orders for the Customer Whose CustomerID (primary key) is QUICK

http://localhost:57087/NorthwindService.svc/Customers(‘QUICK’)/Orders/$count

 

Retrieve the CompanyName Value from the Customer Whose CustomerID (primary key) is QUICK

http://localhost:57087/NorthwindService.svc/Customers(‘QUICK’)/CompanyName/$value

 

Retrieve the ProductID, ProductName, and UnitPrice for the Product Whose ProductID is 1(primary key)

http://localhost:57087/NorthwindService.svc/Products(1)?$select=ProductID,ProductName,UnitPrice

 

Retrieve the CustomerID and CompanyName for all Customers

http://localhost:57087/NorthwindService.svc/Customers?$select=CustomerID,CompanyName

 

Retrieve Customers Ordered By ContactName

http://localhost:57087/NorthwindService.svc/Customers?$orderby=ContactName

 

Retrieve Employees Ordered By LastName, FirstName

http://localhost:57087/NorthwindService.svc/Employees?$orderby=LastName,FirstName

 

Retrieve Products Ordered By UnitPrice Descending

http://localhost:57087/NorthwindService.svc/Products?$orderby=UnitPrice desc

 

Retrieve First 3 Customers

http://localhost:57087/NorthwindService.svc/Customers?$top=3

 

Retrieve Top 3 of Highest Priced Products

http://localhost:57087/NorthwindService.svc/Products?$orderby=UnitPrice desc&$top=3

 

Retrieve 3 Customers after Skipping 18 Customers

http://localhost:57087/NorthwindService.svc/Customers?$orderby=CustomerID&$skip=18&$top=3

 

Retrieve Products Whose Unit Price Is Greater than 10

http://localhost:65363/NorthwindService.svc/Products?$filter=UnitPrice gt 10

 

Retrieve Orders Where the CustomerID Equals ALFKI

http://localhost:65363/NorthwindService.svc/Orders?$filter=CustomerID eq ‘ALFKI’

 

Retrieve Products Whose UnitsInStock Is Less than or Equal to 2

http://localhost:65363/NorthwindService.svc/Products?$filter=UnitsInStock le 2

 

Retrieve Discontinued Product Whose UnitPrice Is Greater than or Equal to 50

http://localhost:65363/NorthwindService.svc/Products?$filter=Discontinued eq true and UnitPrice ge 50

 

Retrieve Products Whose ProductName Starts with C

http://localhost:65363/NorthwindService.svc/Products?$filter=startswith(ProductName,’C’)

 

Retrieve Customers Whose CompanyName Contains restaurant

http://localhost:65363/NorthwindService.svc/Customers?$filter=substringof(‘restaurant’,CompanyName)

 

Retrieve Orders Placed in 1998

http://localhost:65363/NorthwindService.svc/Orders?$filter=year(OrderDate) eq 1998

 

Retrieve Orders Placed in February of 1998

http://localhost:65363/NorthwindService.svc/Orders?$filter=year(OrderDate) eq 1998 and month(OrderDate) eq 2

 

Retrieve Products Whose UnitPrice Floor Is 19

http://localhost:65363/NorthwindService.svc/Products?$filter=floor(UnitPrice) eq 19

 

Retrieve Products Whose UnitPrice Rounds to 29

http://localhost:65363/NorthwindService.svc/Products?$filter=round(UnitPrice) eq 29

 

Retrieve Products Whose UnitPrice Ends with .5

http://localhost:65363/NorthwindService.svc/Products?$filter=UnitPrice sub floor(UnitPrice) eq 0.5

 

Retrieve the Customer Whose CustomerID Is QUICK and the Orders for QUICK

http://localhost:57087/NorthwindService.svc/Customers(‘QUICK’)?$expand=Orders

 

Retrieve the Customer Whose CustomerID Is ALFKI and the Orders and Order_Details for ALFKI

http://localhost:57087/NorthwindService.svc/Customers(‘ALFKI’)?$expand=Orders/Order_Details

 

●       Manipulate XML data structures

 

Querying and Manipulating Data by Using the Entity Framework (20%)

●       Query and manipulate data by using the Entity Framework.

  • This objective may include but is not limited to: Query, update, and delete data by using DbContext; build a query that uses deferred execution; implement lazy loading and eager loading; create and run compiled queries; query data by using Entity SQL

 

●       Query and manipulate data by using Data Provider for Entity Framework

  • This objective may include but is not limited to: Query and manipulate data by using Connection, DataReader, Command from the System.Data.EntityClient namespace; perform synchronous and asynchronous operations; manage transactions (API)

 

●       Query data by using LINQ to Entities.

  • This objective may include but is not limited to: query data by using LINQ operators (for example, project, skip, aggregate, filter, and join); log queries; implement query boundaries (IQueryable vs. IEnumerable)

 

●       Query and manipulate data by using ADO.NET

  • This objective may include but is not limited to: Query and manipulate data by using Connection, DataReader, Command, DataAdapter, DataSet; Perform synchronous and asynchronous operations; Manage transactions (API)

 

●       Create an Entity Framework data model.

  • This objective may include but is not limited to: Structure the data model using Table per type, table per class, table per hierarchy; Choose and implement an approach to manage a data model (code first vs. model first vs. database first); implement POCO objects; Describe a data model by using conceptual schema definitions, storage schema definition, and mapping language (CSDL, SSDL, MSL)
  • General (http://msdn.microsoft.com/en-us/data/ee712907 )
  • Whats new: http://msdn.microsoft.com/en-us/library/ex6y04yf.aspx )
  • EF 5

 

Designing and Implementing WCF Services (19%)

●       Study resource

●       WCF Links resource

●       Create a WCF service

○      Servicecontract and mainly properties
○      Operation Contract and mainly properties
Examples
  • Contract
  • Service Implementation

 

●       Configure WCF services by using configuration settings

 

●       Configure WCF services by using the API

●       Secure a WCF service

  • This objective may include but is not limited to: Implement message level security, implement transport level security; implement certificates
  • Segurança Overview (Portuguese)

●       Consume WCF services

  • This objective may include but is not limited to: Generate proxies by using SvcUtil; generate proxies by creating a service reference; create and implement channel factories
  • Roteamento de Mensagens(portuguese)

●       Version a WCF service

●       Create and configure a WCF service on Windows Azure

  • This objective may include but is not limited to: Create and configure bindings for WCF services (Azure SDK– extensions to WCF); Relay bindings to Azure using service bus endpoints; integrate with the Azure service bus relay
  • Create on Azure (.net4: http://www.dotnetcurry.com/ShowArticle.aspx?ID=819)

●       Implement messaging patterns

●       Host and manage services

 

Creating and Consuming Web API-based services (18%)

●       Study Resource

●       Design a Web API

  • This objective may include but is not limited to: define HTTP resources with HTTP actions; plan appropriate URI space, and map URI space using routing; choose appropriate HTTP method (get, put, post, delete) to meet requirements; choose appropriate format (Web API formats) for responses to meet requirements; plan when to make HTTP actions asynchronous
  • http://www.developer.com/net/asp/introduction-to-asp.net-web-api.html

●       Implement a Web API

  • This objective may include but is not limited to: accept data in JSON format (in JavaScript, in an AJAX callback); use content negotiation to deliver different data formats to clients; define actions and parameters to handle data binding; use HttpMessageHandler to process client requests and server responses; implement dependency injection, along with the dependency resolver, to create more flexible applications; implement action filters and exception filters to manage controller execution; implement asynchronous and synchronous actions; implement streaming actions
  • Content negotiation and response types
  • HttpMessageHandler
  • Dependency injection with dependency resolver
  • Action and exception filters

●       Secure a Web API

●       Host and manage Web API

 

●       Consume Web API web services

 

Deploying Web Applications and Services (19%)

●       Design a deployment strategy

  • This objective may include but is not limited to: Create an IIS install package; deploy to web farms; deploy a web application by using XCopy; automate a deployment from TFS or Build Server
  • Strategies (automated build from TFS, XCopy, IIS install package, VIP swap, sets of configs) (Basics and Source control sections in http://pluralsight.com/training/Courses/TableOfContents/azure-websites)

●       Choose a deployment strategy for a Windows Azure web application

  • This objective may include but is not limited to: Perform an in-place upgrade and VIP swap; configure an upgrade domain; create and configure input and internal endpoints; specify operating system configuration

●       Configure a web application for deployment

  • This objective may include but is not limited to: switch from production/release mode to debug mode; use SetParameters to set up an IIS app pool, set permissions and passwords); configure WCF endpoints, bindings, and behaviors; transform web.config by using XSLT (for example, across development, test, and production/release environments); configure Azure configuration settings
  • config transformations

●       Manage packages by using NuGet

●       Create, configure, and publish a web package

  • This objective may include but is not limited to: Create an IIS InstallPackage; configure the build process to output a web package; apply pre- and post- condition actions to ensure that transformations are correctly applied; include appropriate assets (web content, certificates)
  • SetParameters to setup IIS app pool

●       Share assemblies between multiple applications and servers

Other Sites

PDFS/Ebooks

  • Programming.WCF.Services.3rd.Edition.Aug.2010
  • Press.Windows.Communication.Foundation.4.Step.by.Step.Nov.2010.pdf

Document Created By Victor Hugo do V C Mello

 

Leave a comment

Show Buttons
Hide Buttons
%d bloggers like this: