Buying study material should not feel like a gamble: at GuideTorrent the 070-776 demo lets you evaluate the real value without any extra cost, helping you avoid the useless dumps that waste both money and weeks of preparation.
Microsoft 070-776 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Design and Implement Cloud-Based Integration Using Azure Data Factory | 20% | - Create linked services and datasets - Build and schedule pipelines - Monitor and manage data movement |
| Design and Implement Azure SQL Data Warehouse Solutions | 25% | - Design and implement data distribution - Implement loading and transformation - Manage security and performance |
| Design and Implement Analytics Using Azure Data Lake | 30% | - Implement Data Lake Store - Develop U-SQL scripts - Process data with Data Lake Analytics |
| Design and Implement Complex Event Processing Using Azure Stream Analytics | 25% | - Manage and monitor jobs - Develop Stream Analytics queries - Configure input/output sources |
Preparing for 070-776 Without Wasting Money
- Design and Implement Cloud-Based Integration Using Azure Data Factory (20%)
- Design and Implement Analytics Using Azure Data Lake (30%)
- Design and Implement Complex Event Processing Using Azure Stream Analytics (25%)
Microsoft Engineering Data with Microsoft Cloud Services Sample Questions:
You have an on-premises deployment of Active Directory named contoso.com.
You plan to deploy a Microsoft Azure SQL data warehouse.
You need to ensure that the data warehouse can be accessed by contoso.com users.
Which two components should you deploy? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
- A. Azure Active Directory
- B. Azure Active Directory B2C
- C. Cloud App Discovery
- D. Azure AD Connect
- E. Azure AD Privileged Identity Management
- F. Azure Information Protection
Correct Answer: A,D π³οΈ
You are using a Microsoft Azure Stream Analytics query language.
You are outputting data from an input click stream.
You need to ensure that when you consecutively receive two rows from the same IP address within one minute, only the first row is outputted.
Which functions should you use in the WHERE statement?
- A. LAG and HoppingWindow
- B. LAG and Duration
- C. Last and HoppingWindow
- D. Last and SlidingWindow
Correct Answer: D π³οΈ
You plan to deploy a Microsoft Azure Stream Analytics job to filter multiple input streams from IoT devices that have a total data flow of 30 MB/s.
You need to calculate how many streaming units you require for the job. The solution must prevent lag.
What is the minimum number of streaming units required?
- A. 3
- B. 10
- C. 30
- D. 300
Correct Answer: C π³οΈ
You need to copy data from Microsoft Azure SQL Database to Azure Data Lake Store by using Azure Data Factory.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Correct Answer:

Explanation
References:
https://docs.microsoft.com/en-us/azure/data-factory/copy-activity-overview
You are designing a solution that will use Microsoft Azure Data Lake Store.
You need to recommend a solution to ensure that the storage service is available if a regional outage occurs.
The solution must minimize costs.
What should you recommend?
- A. Create one read-access geo-redundant storage (RA-GRS) account and configure a Recovery Services vault.
- B. Create one Data Lake Store account and create an Azure Resource Manager template that redeploys the services to a different region.
- C. Create one Data Lake Store account that uses a monthly commitment package.
- D. Create two Data Lake Store accounts and copy the data by using Azure Data Factory.
Correct Answer: B π³οΈ
Viewing page 1 out of 19 pages.
Viewing questions 1-5 out of 92 questions.


