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/

Certschief offers Implementing Cisco Network Security certification real exam questions answers with money back pass guarantee.