Exam 70-776 Perform Big Data Engineering on Microsoft Cloud Services (beta)

Published: July 5, 2017
Languages: English
Audiences: Data engineers
Technology: Microsoft Azure SQL Data Warehouse, Azure Data Lake Analytics, Azure Data Factory, Azure Stream Analytics
Credit toward certification: MCSA

Skills measured
This exam measures your ability to accomplish the technical tasks listed below. View video tutorials about the variety of question types on Microsoft exams.

Please note that the questions may test on, but will not be limited to, the topics described in the bulleted text.

Do you have feedback about the relevance of the skills measured on this exam? Please send Microsoft your comments. All feedback will be reviewed and incorporated as appropriate while still maintaining the validity and reliability of the certification process. Note that Microsoft will not respond directly to your feedback. We appreciate your input in ensuring the quality of the Microsoft Certification program.

If you have concerns about specific questions on this exam, please submit an exam challenge.

If you have other questions or feedback about Microsoft Certification exams or about the certification program, registration, or promotions, please contact your Regional Service Center.

Design and Implement Complex Event Processing By Using Azure Stream Analytics (15-20%)
Ingest data for real-time processing
Select appropriate data ingestion technology based on specific constraints; design partitioning scheme and select mechanism for partitioning; ingest and process data from a Twitter stream; connect to stream processing entities; estimate throughput, latency needs, and job footprint; design reference data streams
Design and implement Azure Stream Analytics
Configure thresholds, use the Azure Machine Learning UDF, create alerts based on conditions, use a machine learning model for scoring, train a model for continuous learning, use common stream processing scenarios
Implement and manage the streaming pipeline
Stream data to a live dashboard, archive data as a storage artifact for batch processing, enable consistency between stream processing and batch processing logic
Query real-time data by using the Azure Stream Analytics query language
Use built-in functions, use data types, identify query language elements, control query windowing by using Time Management, guarantee event delivery

Design and Implement Analytics by Using Azure Data Lake (25-30%)
Ingest data into Azure Data Lake Store
Create an Azure Data Lake Store (ADLS) account, copy data to ADLS, secure data within ADLS by using access control, leverage end-user or service-to-service authentication appropriately, tune the performance of ADLS, access diagnostic logs
Manage Azure Data Lake Analytics
Create an Azure Data Lake Analytics (ADLA) account, manage users, manage data sources, manage, monitor, and troubleshoot jobs, access diagnostic logs, optimize jobs by using the vertex view, identify historical job information
Extract and transform data by using U-SQL
Schematize data on read at scale; generate outputter files; use the U-SQL data types, use C# and U-SQL expression language; identify major differences between T-SQL and U-SQL; perform JOINS, PIVOT, UNPIVOT, CROSS APPLY, and Windowing functions in U-SQL; share data and code through U-SQL catalog; define benefits and use of structured data in U-SQL; manage and secure the Catalog
Extend U-SQL programmability
Use user-defined functions, aggregators, and operators, scale out user-defined operators, call Python, R, and Cognitive capabilities, use U-SQL user-defined types, perform federated queries, share data and code across ADLA and ADLS
Integrate Azure Data Lake Analytics with other services
Integrate with Azure Data Factory, Azure HDInsight, Azure Data Catalog, and Azure Event Hubs, ingest data from Azure SQL Data Warehouse

Design and Implement Azure SQL Data Warehouse Solutions (15-20%)
Design tables in Azure SQL Data Warehouse
Choose the optimal type of distribution column to optimize workflows, select a table geometry, limit data skew and process skew through the appropriate selection of distributed columns, design columnstore indexes, identify when to scale compute nodes, calculate the number of distributions for a given workload
Query data in Azure SQL Data Warehouse
Implement query labels, aggregate functions, create and manage statistics in distributed tables, monitor user queries to identify performance issues, change a user resource class
Integrate Azure SQL Data Warehouse with other services
Ingest data into Azure SQL Data Warehouse by using AZCopy, Polybase, Bulk Copy Program (BCP), Azure Data Factory, SQL Server Integration Services (SSIS), Create-Table-As-Select (CTAS), and Create-External-Table-As-Select (CETAS); export data from Azure SQL Data Warehouse; provide connection information to access Azure SQL Data Warehouse from Azure Machine Learning; leverage Polybase to access a different distributed store; migrate data to Azure SQL Data Warehouse; select the appropriate ingestion method based on business needs

Design and Implement Cloud-Based Integration by using Azure Data Factory (15-20%)
Implement datasets and linked services
Implement availability for the slice, create dataset policies, configure the appropriate linked service based on the activity and the dataset
Move, transform, and analyze data by using Azure Data Factory activities
Copy data between on-premises and the cloud, create different activity types, extend the data factory by using custom processing steps, move data to and from Azure SQL Data Warehouse
Orchestrate data processing by using Azure Data Factory pipelines
Identify data dependencies and chain multiple activities, model schedules based on data dependencies, provision and run data pipelines, design a data flow
Monitor and manage Azure Data Factory
Identify failures and root causes, create alerts for specified conditions, perform a redeploy, use the Microsoft Azure Portal monitoring tool

Manage and Maintain Azure SQL Data Warehouse, Azure Data Lake, Azure Data Factory, and Azure Stream Analytics (20-25%)
Provision Azure SQL Data Warehouse, Azure Data Lake, Azure Data Factory, and Azure Stream Analytics
Provision Azure SQL Data Warehouse, Azure Data Lake, and Azure Data Factory, implement Azure Stream Analytics
Implement authentication, authorization, and auditing
Integrate services with Azure Active Directory (Azure AD), use the local security model in Azure SQL Data Warehouse, configure firewalls, implement auditing, integrate services with Azure Data Factory
Manage data recovery for Azure SQL Data Warehouse, Azure Data Lake, and Azure Data Factory, Azure Stream Analytics
Backup and recover services, plan and implement geo-redundancy for Azure Storage, migrate from an on-premises data warehouse to Azure SQL Data Warehouse
Monitor Azure SQL Data Warehouse, Azure Data Lake, and Azure Stream Analytics
Manage concurrency, manage elastic scale for Azure SQL Data Warehouse, monitor workloads by using Dynamic Management Views (DMVs) for Azure SQL Data Warehouse, troubleshoot Azure Data Lake performance by using the Vertex Execution View
Design and implement storage solutions for big data implementations
Optimize storage to meet performance needs, select appropriate storage types based on business requirements, use AZCopy, Storage Explorer and Redgate Azure Explorer to migrate data, design cloud solutions that integrate with on-premises data

Click here to view complete Q&A of 70-776 exam
Certkingdom Review, Certkingdom PDF Torrents

Best Microsoft 70-776 Certification, Microsoft 70-776 Training at certkingdom.com

70-357 Developing Mobile Apps

Published: July 22, 2016
Languages: English, Spanish, Chinese (Simplified), Chinese (Traditional), French, German, Japanese, Portuguese (Brazil), Russian
Audiences: Developers
Technology: Visual Studio Community
Credit toward certification: MCP, MCSA

Skills measured
This exam measures your ability to accomplish the technical tasks listed below. The percentages indicate the relative weight of each major topic area on the exam. The higher the percentage, the more questions you are likely to see on that content area on the exam. View video tutorials about the variety of question types on Microsoft exams.

Please note that the questions may test on, but will not be limited to, the topics described in the bulleted text.

Do you have feedback about the relevance of the skills measured on this exam? Please send Microsoft your comments. All feedback will be reviewed and incorporated as appropriate while still maintaining the validity and reliability of the certification process. Note that Microsoft will not respond directly to your feedback. We appreciate your input in ensuring the quality of the Microsoft Certification program.

If you have concerns about specific questions on this exam, please submit an exam challenge.

If you have other questions or feedback about Microsoft Certification exams or about the certification program, registration, or promotions, please contact your Regional Service Center.

Develop a XAML page layout for an adaptive UI (10–15%)
Construct a page layout
Configure a RelativePanel layout; select the appropriate XAML layout panel based on the UI requirement; configure a grid with appropriate column and row properties; configure alignment, margins, and padding
Implement responsive and adaptive UI behaviors
Differentiate between responsive and adaptive UI behaviors, create responsive and adaptive UIs by using VisualStateManager and AdaptiveTriggers, implement settings syntax for element properties and attached properties
Create and use custom controls within an adaptive UI
Evaluate when to create a custom control; create a custom control; implement styles, themes, and resource dictionaries; apply styles to custom controls by using Generic.xaml
Optimize a page layout
Reduce complexity for performance gains, reduce unnecessary nesting

Implement page navigation and lifecycle events (10–15%)
Choose the appropriate navigation structure for an app
Evaluate when to implement the Hub, Master/Details, Tabs and Pivot, and Nav Pane navigation patterns; evaluate when to implement a custom navigation pattern
Implement Nav Pane navigation
Load page content by using Frame.Navigate, implement page navigation by using the Nav Pane pattern; implement a SplitView control for use as a navigation pane; support accessibility requirements within navigation by implementing key based navigation, UI automation, and narrator; handle Back button behavior for different Windows 10 device families
Manage app activation
Launch an app, activate an app on Startup, implement activation from a deep link, implement activation based on Search integration, implement activation from a secondary tile
Manage app suspension and resuming
Prepare an app for suspension, resume from suspension or termination, extend execution and monitor suspension errors

Implement data access and data binding (20–25%)
Access data by using Entity Framework (EF)
Access data by using EFCore with SQLite, implement a local SQLite database
Implement the {Binding} extension
Implement the {x:Bind} extension
Implement MVVM classes and class interactions
Implement event binding by applying command patterns, implement a Dispatcher to update the UI thread with async return data
Implement app-to-app communications
Integrate a Share contract to share content with another app, integrate drag-and-drop, launch an app for results, implement app extensions, implement App Services
Implement REST Web Services
Implement JSON and data serialization, access cloud data and Web APIs by using HttpClient
Implement file system access
Manage storage by using StorageFile, StorageFolder, and StorageItem; access a file location by using FilePickers; implement data roaming and roaming folders

Implement feature detection for adaptive coding (10–15%)
Implement API detection within adaptive code
Implement Type detection within adaptive code
Implement supported capabilities
Implement support for a microphone, implement support for a webcam, implement support for location, implement support for enterprise authentication

Manage user input and custom user interactions (10–15%)
Implement command bars, flyouts, and dialogs
Implement command bars and AppBarButton buttons, implement context menus and menu flyouts, implement content dialogs, display a tooltip by using ToolTipService, display a pop-up menu, implement control over app settings
Implement support for traditional and touch input devices
Support touch input, support mouse input, support keyboard and virtual keyboard input
Implement speech and voice commands
Support speech synthesis, support speech recognition, support Cortana integration, support Personal Assistant Launch capability, support voice commands
Implement alternative forms of input
Implement inking, implement camera input, implement location services and GPS input

Manage authentication and identity management (10–15%)
Implement authentication using Web Authentication Broker
Implement web service authentication, implement OAuth, implement Azure Active Directory authentication
Manage credentials securely with Credential Locker
Implement two-factor authentication
Implement two-factor authentication using Microsoft Passport, implement two-factor authentication using Windows Hello

Implement notifications, background tasks, and reusable components (15–20%)
Create and consume class libraries and Windows Runtime components
Develop Windows Runtime components, develop class libraries, integrate class libraries and Windows Runtime components
Implement tile and toast notifications
Implement adaptive and interactive toast notifications, implement local tile notifications
Create and register a background task
Create a background task project and reference the background task within a project, implement background task event triggers and conditions
Implement and manage a background task
Monitor background task progress and completion, manage task lifecycle, share data and events between an app and its background tasks, call a background task directly
Create and consume a Universal Windows Platform (UWP) app service
Specify the AppService extension, implement app service as a background task, deploy the app service provider, call app services

---

QUESTION 1 - (Topic 1)
You need to configure the app to meet the load time requirements.
What should you do?

A. Set the value of the CacheSize to 0.
B. Set the value of the CacheMode property to BitmapCache.
C. Set the value of the NavigationCacheMode property to Enabled.
D. Set the value of the NavigationCacheMode property to Disabled.

Answer: C

Explanation:
Scenario: You must optimize the app using the following guidelines:
? You must minimize the time it takes to display content when an item on the timeline is selected.
? The app must respect memory and resource constraints for all devices.
You use the NavigationCacheMode property to specify whether a new instance of the page is created for each visit to the page or if a previously constructed instance of the page that has been saved in the cache is used for each visit.
The default value for the NavigationCacheMode property is Disabled. Set the
NavigationCacheMode property to Enabled or Required when a new instance of the page is not essential for each visit. By using a cached instance of the page, you can improve the performance of your application and reduce the load on your server.

---

QUESTION 2 - (Topic 1)
Note: This question is part of a series of questions that present the same scenario. Each
question in the series contains n unique solution. Determine whether the solution meets the stated goals.
You need to implement the appropriate XAML layout (or the Timeline app.
Solution: You create an instance of a RelativePanel class.
Does this meet the goal?

A. Yes
B. No

Answer: A

Explanation: RelativePanel lets you layout UI elements by specifying where they go in relation to other elements and in relation to the panel. By default, an element is positioned in the upper left corner of the panel.

---

QUESTION 3 - (Topic 1)
You need to design the navigation tor the timeline.
What navigation should you use?

A. hierarchy
B. peer
C. hub
D. master/details

Answer: A

Explanation:
From scenario:
Here we can use a hierarchy with each parent node having only one single child node.
Hierarchical structures are good for organizing complex content that spans lots of pages or when pages should be viewed in a particular order. The downside is that hierarchical pages introduce some navigation overhead: the deeper the structure, the more clicks it takes for users to get from page to page.
We recommend a hiearchical structure when:
You expect the user to traverse the pages in a specific order. Arrange the hierarchy to
enforce that order.
There is a clear parent-child relationship between one of the pages and the other pages in the group.
There are more than 7 pages in the group.
When there are more than 7 pages in the group, it might be difficult for users to understand how the pages are unique or to understand their current location within the group. If you don't think that's an issue for your app, go ahead and make the pages peers

Click here to view complete Q&A of 70-357 exam
Certkingdom Review, Certkingdom PDF Torrents

Best Microsoft 70-357 Certification, Microsoft 70-357 Training at certkingdom.com