70-776 시험 - Microsoft실제시험문제와 답 - 91문항

Question No : 1

HOTSPOT
You have a Microsoft Azure Data Lake Analytics service.
You have a tab-delimited file named UserActivity.tsv that contains logs of user sessions. The file does not have a header row. You need to create a table and to load the logs to the table. The solution must distribute the data
by a column named SessionId.
How should you complete the U-SQL statement? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

정답:

Explanation:
References: https://msdn.microsoft.com/en-us/library/mt706197.aspx

Question No : 2

You need to use the Cognition.Vision.FaceDetector() function in U-SQL to analyze images.
Which attribute can you detect by using the function?

A.gender
B.race
C.weight
D.hair color

정답:

Question No : 3

You are developing an application by using the Microsoft .NET SDK. The application will access data from a Microsoft Azure Data Lake folder.
You plan to authenticate the application by using service-to-service authentication.
You need to ensure that the application can access the Data Lake folder.
Which three actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

A.Register an Azure Active Directory app that uses the Web app/API application type.
B.Configure the application to use the application ID, authentication key, and tenant I
C.Assign the Azure Active Directory app permission to the Data Lake Store folder.
D.Configure the application to use the OAuth 2.0 token endpoint.
E.Register an Azure Active Directory app that uses the Native application type.
F.Configure the application to use the application ID and redirect UR

정답:
Explanation:
References: https://docs.microsoft.com/en-us/azure/data-lake-store/data-lake-store-service-to-serviceauthenticate-using-active-directory

Question No : 4

You have a file in a Microsoft Azure Data Lake Store that contains sales data. The file contains sales amounts by salesperson, by city, and by state.
You need to use U-SQL to calculate the percentage of sales that each city has for its respective state.
Which code should you use?

A.Option A
B.Option B
C.Option C
D.Option D

정답:

Question No : 5

You have a Microsoft Azure Data Lake Analytics service.
You need to write a U-SQL query to extract from a CSV file all the users who live in Boston, and then to save the results in a new CSV file.
Which U-SQL script should you use?

A.Option A
B.Option B
C.Option C
D.Option D

정답:

Question No : 6

You ingest data into a Microsoft Azure event hub.
You need to export the data from the event hub to Azure Storage and to prepare the data for batch processing tasks in Azure Data Lake Analytics.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

A.Run the Avro extractor from a U-SQL script.
B.Create an Azure Storage account.
C.Add a shared access policy.
D.Enable Event Hubs Archive.
E.Run the CSV extractor from a U-SQL script.

정답:

Question No : 7

You plan to use Microsoft Azure Data factory to copy data daily from an Azure SQL data warehouse to an Azure Data Lake Store.
You need to define a linked service for the Data Lake Store. The solution must prevent the access token from expiring.
Which type of authentication should you use?

A.OAuth
B.service-to-service
C.Basic
D.service principal

정답:
Explanation:
References: https://docs.microsoft.com/en-gb/azure/data-factory/v1/data-factory-azure-datalakeconnector#azure-data-lake-store-linked-service-properties

Question No : 8

You have a Microsoft Azure Data Lake Analytics service. You plan to configure diagnostic logging. You need to use Microsoft Operations Management Suite (OMS) to monitor the IP addresses that
are used to access the Data Lake Store.
What should you do?

A.Stream the request logs to an event hub.
B.Send the audit logs to Log Analytics.
C.Send the request logs to Log Analytics.
D.Stream the audit logs to an event hub.

정답:
Explanation:
References: https://docs.microsoft.com/en-us/azure/data-lake-analytics/data-lake-analytics-diagnostic-logs https://docs.microsoft.com/en-us/azure/security/azure-log-audit

Question No : 9

You have a Microsoft Azure Data Lake Analytics service. You have a CSV file that contains employee salaries. You need to write a U-SQL query to load the file and to extract all the employees who earn
salaries that are greater than $100,000. You must encapsulate the data for reuse.
What should you use?

A.a table-valued function
B.a view
C.the extract command
D.the output command

정답:
Explanation:
References: https://docs.microsoft.com/en-au/azure/data-lake-analytics/data-lake-analytics-u-sql-catalog

Question No : 10

You plan to add a file from Microsoft Azure Data Lake Store to Azure Data Catalog.
You run the Data Catalog tool and select Data Lake Store as the data source.
Which information should you enter in the Store Account field to connect to the Data Lake Store?

A.an email alias
B.a server name
C.a URL
D.a subscription ID

정답:

Question No : 11

You plan to use Microsoft Azure Event Hubs to ingest data. You plan to use Azure Stream Analytics to analyze the data in real time and to send the output directly to Azure Data Lake Store.
You discover duplicate records in the output data.
What is a possible cause of the duplicate records?

A.There are connectivity issues with the output adapter.
B.There is a connectivity issue between the data source and the event hub.
C.There are multiple deliveries to the output adapter that writes the output events.
D.The Stream Analytics output adapter writes the output events transactionally.

정답:
Explanation:
References: https://msdn.microsoft.com/en-us/library/azure/mt721300.aspx

Question No : 12

You have a Microsoft Azure SQL data warehouse that contains information about community events.
An Azure Data Factory job writes an updated CSV file in Azure Blob storage to Community/{date}/events.csv daily.
You plan to consume a Twitter feed by using Azure Stream Analytics and to correlate the feed to the community events.
You plan to use Stream Analytics to retrieve the latest community events data and to correlate the data to the Twitter feed data.
You need to ensure that when updates to the community events data is written to the CSV files, the Stream Analytics job can access the latest community events data.
What should you configure?

A.an output that uses a blob storage sink and has a path pattern of Community/{date}
B.an output that uses an event hub sink and the CSV event serialization format
C.an input that uses a reference data source and has a path pattern of Community/{date}/events.csv
D.an input that uses a reference data source and has a path pattern of Community/{date}

정답:

Question No : 13

DRAG DROP
You have a Microsoft Azure Stream Analytics solution that captures website visits and user interactions on the website.
You have the sample input data described in the following table.

You have the sample output described in the following table.

How should you complete the script? To answer, drag the appropriate values to the correct targets. Each value 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.
NOTE: Each correct selection is worth one point.

정답:

Explanation:
References: https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-stream-analytics-querypatterns

Question No : 14

You plan to use Microsoft Azure Event Hubs to ingest sensor data. You plan to use Azure Stream Analytics to analyze the data in real time and to send the output directly to Azure Data Lake Store.
You need to write events to the Data Lake Store in batches.
What should you use?

A.Apache Storm in Azure HDInsight
B.Stream Analytics
C.Microsoft SQL Server Integration Services (SSIS)
D.the Azure CLI

정답:
Explanation:
References: https://docs.microsoft.com/en-us/azure/data-lake-store/data-lake-store-data-scenarios

Question No : 15

You are developing an application that uses Microsoft Azure Stream Analytics. You have data structures that are defined dynamically. You want to enable consistency between the logical methods used by stream processing and
batch processing. You need to ensure that the data can be integrated by using consistent data points.
What should you use to process the data?

A.a vectorized Microsoft SQL Server Database Engine
B.directed acyclic graph (DAG)
C.Apache Spark queries that use updateStateByKey operators
D.Apache Spark queries that use mapWithState operators

정답:

Microsoft 70-776 시험