Microsoft 70-475 Online Practice Questions and Exam Preparation

Microsoft 70-475 Online Questions & Answers

• Question 1:

  You have an Apache Storm cluster.

  You need to ingest data from a Kafka queue.

  Which component should you use to consume data emitted from Kafka?

  A. a bolt
  B. a Microsoft Azure Service Bus queue
  C. a spout
  D. Flume
  C. a spout

  ---

  To perform real-time computation on Storm, we create "topologies." A topology is a graph of a computation, containing a network of nodes called "Spouts" and "Bolts." In a Storm topology, a Spout is the source of data streams and a Bolt holds the business logic for analyzing and processing those streams.

  The org.apache.storm.kafka.KafkaSpout component reads data from Kafka.

  Example:

  

  References: https://docs.microsoft.com/en-us/azure/hdinsight/hdinsight-apache-storm-with-kafka https://hortonworks.com/blog/storm-kafka-together-real-time-data-refinery/

• Question 2:

  You have a Microsoft Azure Data Factory pipeline that contains an input dataset.

  You need to ensure that the data from Azure Table Storage is copied only if the table contains 1,000 records or more.

  Which policy setting should you use in JSON?

  "policy":

  A. { "validation": { "minimum":1000 } }
  B. "policy": { "validation": { "sqlRows":1000 } }
  C. "policy": { "validation": { "minimumRows":1000 } } "policy":
  D. { "validation": { "sqlMinimumRows":1000 } }
  B. "policy": { "validation": { "sqlRows":1000 } }

  ---

  The following JSON defines a Linux-based on-demand HDInsight linked service. The Data Factory service automatically creates a Linux-based HDInsight cluster to process the required activity.

  {

  "name": "HDInsightOnDemandLinkedService",

  "properties": {

  "type": "HDInsightOnDemand",

  "typeProperties": {

  "clusterType": "hadoop",

  "clusterSize": 1,

  "timeToLive": "00:15:00",

  "hostSubscriptionId": "",

  "servicePrincipalId": "",

  "servicePrincipalKey": {

  "value": "",

  "type": "SecureString"

  },

  "tenant": "",

  "clusterResourceGroup": "",

  "version": "3.6",

  "osType": "Linux",

  "linkedServiceName": {

  "referenceName": "AzureStorageLinkedService",

  "type": "LinkedServiceReference"

  }

  },

  "connectVia": {

  "referenceName": "",

  "type": "IntegrationRuntimeReference"

  }

  }

  }

  References: https://docs.microsoft.com/en-us/azure/data-factory/compute-linked-services

• Question 3:

  A company named Fabrikam, Inc. plans to monitor financial markets and social networks, and then to correlate global stock movements to social network activity.

  You need to recommend a Microsoft Azure HDInsight cluster solution that meets the following requirements: Provides continuous availability Can process asynchronous feeds

  What is the best type of cluster to recommend to achieve the goal? More than one answer choice may achieve the goal. Select the BEST answer.

  A. Apache Hbase
  B. Apache Hadoop
  C. Apache Spark
  D. Apache Storm
  C. Apache Spark

• Question 4:

  You have a Microsoft Azure data factory.

  You assign administrative roles to the users in the following table.

  

  You discover that several new data factory instances were created.

  You need to ensure that only User5 can create a new data factory instance.

  Which two roles should you change? Each correct answer presents part of the solution.

  NOTE: Each correct selection is worth one point.

  A. User2 to Reader
  B. User3 to Contributor
  C. User1 to Reader
  D. User4 to Contributor
  E. User5 to Administrator
  A. User2 to Reader
  C. User1 to Reader

• Question 5:

  Your company supports multiple Microsoft Azure subscriptions.

  You plan to deploy several virtual machines to support the services in Azure.

  You need to automate the management of all the subscriptions. The solution must minimize administrative effort.

  Which two cmdlets should you run? Each correct answer presents part of the solution.

  NOTE: Each correct selection is worth one point.

  A. Clear-AzureProfile
  B. Add-AzureSubscription
  C. Add-AzureRMAccount
  D. Import-AzurePublishSettingsFile
  E. Get-AzurePublishSettingsFile
  D. Import-AzurePublishSettingsFile
  E. Get-AzurePublishSettingsFile

• Question 6:

  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.

  Relecloud has two main offices. The offices are located in San Francisco and New York City.

  The offices connect to each other by using a site-to-site VPN. Each office connects directly to the Internet.

  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.

  Relecloud wants to deliver reports to 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:

  Management at Relecloud must be able to view which topics are trending to adjust advertising rates in near real-time.

  Relecloud plans to implement a new streaming analytics platform that will report on trending topics.

  Relecloud plans to implement a data warehouse named DB2.

  Relecloud identifies the following technical requirements:

  Social media data must be analyzed to identify trending topics in real-time.

  The use of Infrastructure as a Service (IaaS) platforms must minimized, whenever possible.

  The real-time solution used to analyze the social media data must support scaling up and down without service interruption.

  Relecloud identifies the following technical requirements for the advertisers:

  The advertisers must be able to see only their own data in the Power BI reports.

  The advertisers must authenticate to Power BI by using Azure Active Directory (Azure AD) credentials.

  The advertisers must be able to leverage existing Transact-SQL language knowledge when developing the real-time streaming solution.

  Members of the internal advertising sales team at Relecloud must be able to see only the sales date of the advertisers to which they are assigned.

  The internal Relecloud advertising sales team must be prevented from inserting, updating, and deleting rows for the advertisers to which they are not assigned.

  The internal Relecloud advertising sales team must be able to use a text file to update the list of advertisers, and then to upload the file to Azure Blob storage.

  Relecloud identifies the following requirements for DB1:

  Data generated by the streaming analytics platform must be stored in DB1.

  The user names of the advertisers must be mapped to CustomerID in a table named Table2.

  The advertisers in DB1 must be stored in a table named Table1 and must be refreshed nightly.

  The user names of the employees at Relecloud must be mapped to EmployeeID in a table named Table3.

  Relecloud identifies the following requirements for DB2:

  DB2 must have minimal storage costs.

  DB2 must run load processes in parallel.

  DB2 must support massive parallel processing.

  DB2 must be able to store more than 40 TB of data.

  DB2 must support scaling up and down, as required.

  Data from DB1 must be archived in DB2 for long-term storage.

  All of the reports that are executed from DB2 must use aggregation.

  Users must be able to pause DB2 when the data warehouse is not in use.

  Users must be able to view previous versions of the data in DB2 by using aggregates.

  Relecloud identifies the following requirements for extract, transformation, and load (ETL):

  Data movement between DB1 and DB2 must occur each hour.

  An email alert must be generated when a failure of any type occurs during ETL processing.

  Sample code and data:

  You execute the following code for a table named rls_table1.

  

  You use the following code to create Table1.

  create table table1 (customerid int, salespersonid int ... ) Go

  The following is a sample of the streaming data.

  

  You need to design the data load process from DB1 to DB2. Which data import technique should you use in the design?

  A. PolyBase
  B. SQL Server Integration Services (SSIS)
  C. the Bulk Copy Program (BCP)
  D. the BULK INSERT statement
  B. SQL Server Integration Services (SSIS)

  ---

  Scenario: Data from DB1 must be archived in DB2 for long-term storage.

  Data movement between DB1 and DB2 must occur each hour. An email alert must be generated when a failure of any type occurs during ETL processing.

  Note: Microsoft Integration Services is a platform for building enterprise-level data integration and data transformations solutions. Use Integration Services to solve complex business problems by copying or downloading files, loading data

  warehouses, cleansing and mining data, and managing SQL Server objects and data.

  Integration Services can extract and transform data from a wide variety of sources such as XML data files, flat files, and relational data sources, and then load the data into one or more destinations.

  References:

  https://docs.microsoft.com/en-us/sql/integration-services/sql-server-integration-services

• Question 7:

  Your Microsoft Azure subscription contains several data sources that use the same XML schema.

  You plan to process the data sources in parallel.

  You need to recommend a compute strategy to minimize the cost of processing the data sources.

  What should you recommend including in the compute strategy?

  A. Microsoft SQL Server Integration Services (SSIS) on an Azure virtual machine
  B. Azure Batch
  C. a Linux HPC cluster in Azure
  D. a Windows HPC cluster in Azure
  B. Azure Batch

  ---

  By running more than one task simultaneously on each compute node in your Azure Batch pool, you can maximize resource usage on a smaller number of nodes in the pool. For some workloads, this can result in shorter job times and lower cost.

  References: https://docs.microsoft.com/en-us/azure/batch/batch-parallel-node-tasks

• Question 8:

  DRAG DROP

  You have data in an on-premises Microsoft SQL Server database.

  You must ingest the data in Microsoft Azure Blob Storage from the on-premises SQL Server database by using Azure Data Factory.

  You need to identify which tasks must be performed from Azure.

  In which sequence should you perform the actions? To answer, move all of the actions from the list of actions to the answer area and arrange then in the correct order.

  NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.

  Select and Place:

  

  

  ---

  Step 1: Configure a Microsoft Data Management Gateway

  Install and configure Azure Data Factory Integration Runtime.

  The Integration Runtime is a customer managed data integration infrastructure used by Azure Data Factory to provide data integration capabilities across different network environments. This runtime was formerly called "Data Management

  Gateway".

  Step 2: Create a linked service for Azure Blob storage

  Create an Azure Storage linked service (destination/sink). You link your Azure storage account to the data factory.

  Step 3: Create a linked service for SQL Server

  Create and encrypt a SQL Server linked service (source)

  In this step, you link your on-premises SQL Server instance to the data factory.

  Step 4: Create an input dataset and an output dataset.

  Create a dataset for the source SQL Server database. In this step, you create input and output datasets. They represent input and output data for the copy operation, which copies data from the on-premises SQL Server database to Azure

  Blob storage.

  Step 5: Create a pipeline..

  You create a pipeline with a copy activity. The copy activity uses SqlServerDataset as the input dataset and AzureBlobDataset as the output dataset. The source type is set to SqlSource and the sink type is set to BlobSink.

  References: https://docs.microsoft.com/en-us/azure/data-factory/tutorial-hybrid-copy-powershell

• Question 9:

  You have a data warehouse that contains the sales data of several customers.

  You plan to deploy a Microsoft Azure data factory to move additional sales data to the data warehouse.

  You need to develop a data factory job that reads reference data from a table in the source data.

  Which type of activity should you add to the control flow of the job?

  A. a ForEach activity
  B. a lookup activity
  C. a web activity
  D. a GetMetadata activity
  B. a lookup activity

  ---

  References: https://docs.microsoft.com/en-us/azure/data-factory/control-flow-lookup-activity

• Question 10:

  A company named Fabrikam, Inc. has a web app. Millions of users visit the app daily.

  Fabrikam performs a daily analysis of the previous day's logs by scheduling the following Hive query.

  

  You need to recommend a solution to gather the log collections from the web app. What should you recommend?

  A. Generate a single directory that has a single file for each day.
  B. Generate a single directory that contains multiple files for each day. Name the file by using the syntax of {date}_{randomsuffix}.txt.
  C. Generate a directory each day that has a single file.
  D. Generate a directory that is named by using the syntax of "LogDate={date}" and generate a set of files for that day.
  D. Generate a directory that is named by using the syntax of "LogDate={date}" and generate a set of files for that day.