Prerequisite
MCSA Microsoft Certified Solutions Associate-Web Applications
Exam 70-487: Developing Microsoft Azure and Web Services
Accessing
Data
choose
a data access technology, including ADO.NET, Entity Framework, WCF Data
Services,
and Azure Cosmos DB, based on application requirements
cache
static data, apply cache policies, including policy expirations; use
CacheDependency
to refresh cache data; query notifications; implement caching using
Redis
manage
transactions by using the API from System.Transactions namespace; implement
distributed
transactions including distributed transaction on SQL Azure; specify a
transaction
isolation level
access
data storage in Windows Azure; choose a data storage mechanism in Microsoft
Azure.
including blobs, tables, queues, Azure SQL, and Cosmos DB; distribute data by
using
the Content Delivery Network (CDN) and Azure File Sync; handle exceptions by
using
retries; use Elastic client library with Azure SQL
address
resources; implement filtering; create a query expression; access payload
formats,
including JSON; use data service interceptors and service operators; version a
data
service; implement data services providers; host the dataservice; use actions
to
implement
server-side behavior
Querying
and Manipulating Data by Using the Entity Framework
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; create global query filters
query
and manipulate data by using Connection, DataReader, and Command objects
from
the System.Data.EntityClient namespace; perform synchronous and asynchronous
operations;
manage transactions (API)
query
data by using LINQ operators, including project, skip, aggregate, filter, and
join;
log
queries; implement query boundaries
query
and manipulate data by using Connection, DataReader, and Command objects;
perform
synchronous and asynchronous operations; manage transactions
structure
a data model using Table per type, table per class, and table per hierarchy;
select
and implement an approach to manage a data model, including code first, model
first,
and database first; implement POCO objects; describe a data model by using
conceptual
schema definitions, storage schema definitions, and mapping languages,
including
CSDL, SSDL, and MSL
implement
Entity Framework using MySQL and SQLite databases; design a strategy to
manage
differences between database capabilities; leverage database specific
technologies,
including ON DUPLICATE KEY using Entity Framework
Creating
and Consuming Web API-based services
define
HTTP resources with HTTP actions; plan appropriate URI space, and map URI
space
using routing; choose appropriate HTTP method to meet requirements; choose
appropriate
Web API formats for responses to meet requirements; plan when to make
HTTP
actions asynchronous
accept
data in JSON format; use content negotiation to deliver different data formats
to
clients;
define actions and parameters to handle data binding; implement dependency
injection
to create more flexible applications; implement action filters and exception
filters
to manage controller execution; implement asynchronous and synchronous
actions;
implement streaming actions; implement middleware
implement
Identity for authentication; implement authorization using roles, claims, and
custom
authorization; implement Data Protection APIs; enable cross-domain requests
(CORS);
prevent cross-site request forgery (XSRF); implement and extend authorization
filters
to control access to applications
host
Web API in IIS; self-host a Web API in your own process; host Web API in
Kestrel;
host
services in a Windows Azure Web App; host services in Docker containers;
configure
the
host server for streaming; work with a hosting environment
consume
Web API services by using HttpClient; send and receive requests in different
formats;
handle retry logic; implement content negotiation; use Swagger to construct
Uris
and payloads; use AutoRest to build clients
Designing
and Implementing Web Services
generate
proxies by using SvcUtil; generate proxies by creating a service reference;
create
and implement channel factories; configure WCF services by using configuration
settings;
create and configure bindings for WCF services; relay bindings to Azure using
service
bus endpoints; integrate with the Azure service bus relay
host
web services using App Services, including Logic Apps and API Apps; design and
implement
Azure Function based services; design and implement Azure Web Jobs;
design
and implement Service Fabric based web services; implement schedule-based
processing
in a serverless environment
implement
Azure Load Balancer, including scaling; implement Azure Application
Gateway;
implement Azure Traffic Manager; design for multiple regions; leverage Azure
CDN
for caching web services; implement Log Analytics
secure
Web Services using certificates, Azure Active Directory, and OAuth; define and
implement
policies, including secrets, caching, external services, monitoring and
throttling;
define API interface using the Azure Portal and Swagger; manage running
services
using logging, disaster recovery, and multiple regions
collect
logs and metrics using Azure Event Hubs; process logs and metrics using Azure
Event
Hubs, Stream Analytics, and Machine Learning; use Azure App Insights to monitor
and
troubleshoot web services
Deploying
Web Applications and Services
deploy
using Web Deploy; deploy using Web Publishing in Visual Studio; deploy a web
application
by using XCopy; automate a deployment from VSTS or TFS Build Server;
deploy
a web application to a Docker container; design a continuous deployment
pipeline;
deploy using cloud sync
determine
appropriate service; perform an in-place upgrade and deployment slot swap;
create
staging environments; configure an upgrade domain; create and configure input
and
internal endpoints; specify operating system configuration; implement ARM
templates
to customize deployment; deploy to Service Fabric; deploy to Azure Stack
switch
from production or release mode to debug mode; transform configuration files ;
configure
Azure configuration settings; configure Azure Key Vault for application
secrets;
configure
deployment credentials for Azure App Service
create
and configure a NuGet package; install and update an existing NuGet package;
resolve
versioning conflict issues; connect to a local repository cache for NuGet, set
up
your
own package repository; manage NuGet dependencies
prepare
the environment for use of assemblies across multiple servers; sign assemblies
by
using a strong name; deploy assemblies to the global assembly cache; implement
assembly
versioning; create an assembly manifest; configure assembly binding redirects;
target
netstandard for cross platform libraries
