[22-Feb-2019 Update] Exam 70-475 VCE Dumps and 70-475 PDF Dumps from PassLeader

Valid 70-475 Dumps shared by PassLeader for Helping Passing 70-475 Exam! PassLeader now offer the newest 70-475 VCE dumps and 70-475 PDF dumps, the PassLeader 70-475 exam questions have been updated and ANSWERS have been corrected, get the newest PassLeader 70-475 dumps with VCE and PDF here: https://www.passleader.com/70-475.html (103 Q&As Dumps)

BTW, DOWNLOAD part of PassLeader 70-475 dumps from Cloud Storage: https://drive.google.com/open?id=1q2V0jQVJHIBUpxMZlXa_WGStspUYOQF0

You plan to deploy a Microsoft Azure SQL data warehouse and a web application. The data warehouse will ingest 5 TB of data from an on-premises Microsoft SQL Server database daily. The web application will query the data warehouse. You need to design a solution to ingest data into the data warehouse.
Solution: You use AzCopy to transfer the data as text files from SQL Server to Azure Blob storage, and then you use PolyBase to run Transact-SQL statements that refresh the data warehouse database.
Does this meet the goal?

A.    Yes
B.    No

Answer: A
If you need the best performance, then use PolyBase to import data into Azure SQL warehouse.

You plan to deploy a Microsoft Azure SQL data warehouse and a web application. The data warehouse will ingest 5 TB of data from an on-premises Microsoft SQL Server database daily. The web application will query the data warehouse. You need to design a solution to ingest data into the data warehouse.
Solution: You use the bcp utility to export CSV files from SQL Server and then to import the files to Azure SQL Data Warehouse.
Does this meet the goal?

A.    Yes
B.    No

Answer: B
If you need the best performance, then use PolyBase to import data into Azure SQL warehouse.

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

Answer: C
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.

You plan to use Microsoft Azure IoT Hub to capture data from medical devices that contain sensors. You need to ensure that each device has its own credentials. The solution must minimize the number of required privileges. Which policy should you apply to the devices?

A.    iothubowner
B.    service
C.    registryReadWrite
D.    device

Answer: D
Per-Device Security Credentials. Each IoT Hub contains an identity registry For each device in this identity registry, you can configure security credentials that grant DeviceConnect permissions scoped to the corresponding device endpoints. By the way, for option A: an iothubowner would have all permissions.

You have a Microsoft Azure Data Factory that loads data to an analytics solution. You receive an alert that an error occurred during the last processing of a data stream. You debug the problem and solve an error. You need to process the data stream that caused the error. What should you do?

A.    From Azure Cloud Shell, run the az dla job command.
B.    From Azure Cloud Shell, run the az batch job enable command.
C.    From PowerShell, run the Resume-AzureRmDataFactoryPipeline cmdlet.
D.    From PowerShell, run the Set-AzureRmDataFactorySliceStatus cmdlet.

Answer: D
ADF operates on data in batches known as slices. Slices are obtained by querying data over a date-time window, for example, a slice may contain data for a specific hour, day, or week. Such a query would use a date-time column notionally representing an effective date or a last-modified date.

You have a Microsoft Azure Data Factory pipeline. You discover that the pipeline fails to execute because data is missing. You need to rerun the failure in the pipeline. Which cmdlet should you use?

A.    Set-AzureRmAutomationJob
B.    Set-AzureRmDataFactorySliceStatus
C.    Resume-AzureRmDataFactoryPipeline
D.    Resume-AzureRmAutomationJob

Answer: B
Use some PowerShell to inspect the ADF activity for the missing file error. Then simply set the dataset slice to either skipped or ready using the cmdlet to override the status.

You plan to analyze the execution logs of a pipeline to identify failures by using Microsoft power BI. You need to automate the collection of monitoring data for the planned analysis. What should you do from Microsoft Azure?

A.    Create a Data Factory Set
B.    Save a Data Factory Log
C.    Add a Log Profile
D.    Create an Alert Rule Email

Answer: A
You can import the results of a Log Analytics log search into a Power BI dataset so you can take advantage of its features such as combining data from different sources and sharing reports on the web and mobile devices. To import data from a Log Analytics workspace into Power BI, you create a dataset in Power BI based on a log search query in Log Analytics. The query is run each time the dataset is refreshed. You can then build Power BI reports that use data from the dataset.

You have an Apache Hive cluster in Microsoft Azure HDInsight. The cluster contains 10 million data files. You plan to archive the data. The data will be analyzed monthly. You need to recommend a solution to move and store the data. The solution must minimize how long it takes to move the data and must minimize costs. Which two services should you include in the recommendation? (Each correct answer presents part of the solution. Choose two.)

A.    Azure Queue storage
B.    Microsoft SQL Server Integration Services (SSIS)
C.    Azure Table Storage
D.    Azure Data Lake
E.    Azure Data Factory

Answer: DE
D: To analyze data in HDInsight cluster, you can store the data either in Azure Storage, Azure Data Lake Storage Gen 1/Azure Data Lake Storage Gen 2, or both. Both storage options enable you to safely delete HDInsight clusters that are used for computation without losing user data.
E: The Spark activity in a Data Factory pipeline executes a Spark program on your own or on-demand HDInsight cluster. It handles data transformation and the supported transformation activities.

You are building an Azure Analysis Services cube. The source data for the cube is located on premises in a Microsoft SQL Server database. You need to ensure that the Azure Analysis Services service can access the source data. What should you deploy to your Azure subscription?

A.    Azure Data Factory
B.    A network gateway in Azure
C.    A data gateway in Azure
D.    A site-to-site VPN

Answer: C
Connecting to on-premises data sources from and Azure AS server require an on-premises gateway.

You have a Microsoft Azure SQL database that contains Personally Identifiable Information (PII). To mitigate the PII risk, you need to ensure that data is encrypted while the data is at rest. The solution must minimize any changes to front-end applications. What should you use?

A.    Transport Layer Security (TLS)
B.    Transparent Data Encryption (TDE)
C.    A Shared Access Signature (SAS)

Answer: B
Transparent data encryption (TDE) helps protect Azure SQL Database, Azure SQL Managed Instance, and Azure Data Warehouse against the threat of malicious activity. It performs real-time encryption and decryption of the database, associated backups, and transaction log files at rest without requiring changes to the application.

A company named Fabricam, Inc. has a web app hosted in Microsoft Azure. Millions of users visit the app daily. All of the user visits are logged in Azure Blob storage. Data analysts at Fabrikam built a dashboard that processes the user visit logs. Fabrikam plans to use an Apache Hadoop cluster on Azure HDInsight to process queries. The queries will access the data only once. You need to recommend a query execution strategy. What is the best to recommend using to achieve the goal? (More than one answer choice may achieve the goal. Select the BEST answer.)

A.    Load the text files to ORC files, and then run dashboard queries on the ORC files.
B.    Load the text files to sequence files, and then run dashboard queries on the sequence files.
C.    Run the queries on the text files directly.
D.    Load the text files to parquet files, and then run dashboard queries on the parquet files.

Answer: B
File format versatility and Intelligent caching: Fast analytics on Hadoop have always come with one big catch: they require up-front conversion to a columnar format like ORCFile, Parquet or Avro, which is time-consuming, complex and limits your agility. With Interactive Query Dynamic Text Cache, which converts CSV or JSON data into optimized in-memory format on-the-fly, caching is dynamic, so the queries determine what data is cached. After text data is cached, analytics run just as fast as if you had converted it to specific file formats.

You plan to implement a Microsoft Azure Data Factory pipeline. The pipeline will have custom business logic that requires a custom processing step. You need to implement the custom processing step by using C#. Which interface and method should you use? (To answer, select the appropriate options in the answer area.)


Drag and Drop
You have an analytics solution in Microsoft Azure that must be operationalized. You have the relevant data in Azure Blob storage. You use an Azure HDInsight Cluster to process the data. You plan to process the raw data files by using Azure HDInsight. Azure Data Factory will operationalize the solution. You need to create a data factory to orchestrate the data movement. Output data must be written back to Azure Blob storage. Which four 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.)


Drag and Drop
You need to implement a security solution for Microsoft Azure SQL database. The solution must meet the following requirements:
– Ensure that users can see the data from their respective department only.
– Prevent administrators from viewing the data.
Which feature should you use for each requirement? (To answer, drag the appropriate features to the correct requirements. Each feature may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.)


You deploy a Microsoft Azure SQL database. You create a job to upload customer data to the database. You discover that the job cannot connect to the database and fails. You verify that the database runs successfully in Azure. You need to run the job successfully. What should you create?

A.    a virtual network rule
B.    a network security group (NSG)
C.    a firewall rule
D.    a virtual network

Answer: C
If the application persistently fails to connect to Azure SQL Database, it usually indicates an issue with one of the following:
– Firewall configuration. The Azure SQL database or client-side firewall is blocking connections to Azure SQL Database.
– Network reconfiguration on the client side: for example, a new IP address or a proxy server.
– User error: for example, mistyped connection parameters, such as the server name in the connection string.


Get the newest PassLeader 70-475 VCE dumps here: https://www.passleader.com/70-475.html (103 Q&As Dumps)

And, DOWNLOAD the newest PassLeader 70-475 PDF dumps from Cloud Storage for free: https://drive.google.com/open?id=1q2V0jQVJHIBUpxMZlXa_WGStspUYOQF0