Incredible CertsChief Microsoft 70-475 Exam
Case Study: 1
Relecloud
General Overview
Relecloud is a social media company that processes hundreds of millions of social media posts per day and sells advertisements to several hundred companies.
Relecloud has a Microsoft SQL Server database named DB1 that stores information about the advertisers. DB1 is hosted on a Microsoft Azure virtual machine.
Physical locations
Relecloud has two main offices. The offices we located in San Francisco and New York City.
The offices connected to each other by using a site-to-site VPN. Each office connects directly to the Internet.
Business model
Relecloud modifies the pricing of its advertisements based on trending topics. Topics are considered to be trending if they generate many mentions in a specific country during a 15-minute time frame. The highest trending topics generate the highest advertising revenue.
CTO statement
Relecloud wants to deliver reports lo the advertisers by using Microsoft Power BI. The reports will provide real-time data on trending topics, current advertising rates, and advertising costs for a given month.
Relecloud will analyze the trending topics data, and then store the data in a new data warehouse for ad-hoc analysis. The data warehouse is expected to grow at a rate of 1 GB per hour or 8.7 terabytes (TB) per year. The data will be retained for five years for the purpose of long term trending.
Requirements
Business goals
Management at Relecloud must be able to view which topics are trending to adjust advertising rates in near real-time.
Question: 1
Which technology should you recommend to meet the technical requirement for analyzing the social media data?
A. Azure Stream Analytics
B. Azure Data Lake Analytics
C. Azure Machine Learning
D. Azure HDInsight Storm clusters
Answer: A
Azure Stream Analytics is a fully managed event-processing engine that lets you set up real-time analytic computations on streaming data.
Scalability
Stream Analytics can handle up to 1 GB of incoming data per second. Integration with Azure Event Hubs and Azure IoT Hub allows jobs to ingest millions of events per second coming from connected devices, clickstreams, and log files, to name a few. Using the partition feature of event hubs, you can partition computations into logical steps, each with the ability to be further partitioned to increase scalability.
Question: 2
You need to recommend a permanent Azure Storage solution for the activity dat
a. The solution must meet the technical requirements.
What is the best recommendation to achieve the goal? More than one answer choice may achieve the goal. Select the BEST answer.
A. Azure SQL Database
B. Azure Queue storage
C. Azure Blob storage
D. Azure Event Hubs
Answer: A
Question: 3
Users report that when they access data that is more than one year old from a dashboard, the response time is slow.
You need to resolve the issue that causes the slow response when visualizing older dat
a. What should you do?
A. Process the event hub data first, and then process the older data on demand.
B. Process the older data on demand first, and then process the event hub data.
C. Aggregate the older data by time, and then save the aggregated data to reference data streams.
D. Store all of the data from the event hub in a single partition.
Answer: C
Question: 4
You extend the dashboard of the health tracking application to summarize fields across several users.
You need to recommend a file format for the activity data in Azure that meets the technical requirements.
What is the best recommendation to achieve the goal? More than one answer choice may achieve the goal. Select the BEST answer.
A. ORC
B. TSV
C. CSV
D. JSON
E. XML
Answer: E
Test Information:
Total Questions: 42
Test Number: 70-475
Vendor Name: Microsoft
Cert Name: Microsoft Specialist
Test Name: Designing and Implementing Big Data Analytics Solutions
Official Site: https://www.certschief.com/
For More Details: https://www.certschief.com/exam/70-475/