070-776 무료 덤프문제 온라인 액세스

You have a Microsoft Azure Stream Analytics job.
You are debugging event information manually.
You need to view the event data that is being collected.
Which monitoring data should you view for the Stream Analytics job?

• A.outputs
• B.query
• C.inputs
• D.scale

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 Native application type.
• B.Configure the application to use the OAuth 2.0 token endpoint.
• C.Register an Azure Active Directory app that uses the Web app/API application type.
• D.Assign the Azure Active Directory app permission to the Data Lake Store folder.
• E.Configure the application to use the application ID, authentication key, and tenant ID.
• F.Configure the application to use the application ID and redirect URI.

You need to load data from Microsoft Azure Data Lake Store to Azure SQL Data Warehouse by using Transact-SQL.
In which sequence should you perform the actions? To answer, move all actions from the list of actions to the answer area and arrange them 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.

정답:

Explanation

You have an extract, transformation, and load (ETL) process for a Microsoft Azure SQL data warehouse.
You run the following statements to create the logon and user for an account that will run the nightly data load for the data warehouse.
CREATE LOGIN LoaderLogin WITH PASSWORD = 'mypassword';
CREATE USER LoaderUser for LOGIN LoaderLogin;
You connect to the data warehouse.
You need to ensure that the user can access the highest resource class.
Which statement should you execute?

• A.EXEC sp_addrolemember 'xlargerc', 'LoaderUser'
• B.ALTER SERVER ROLE LargeRC ADD MEMBER LoaderUser;
• C.EXEC sp_addrolemember 'largerc', 'LoaderLogin'
• D.ALTER SERVER ROLE xLargeRC ADD MEMBER LoaderLogin;

Note: This question is part of a series of questions that present the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.
Start of repeated scenario
You are migrating an existing on-premises data warehouse named LocalDW to Microsoft Azure. You will use an Azure SQL data warehouse named AzureDW for data storage and an Azure Data Factory named AzureDF for extract, transformation, and load (ETL) functions.
For each table in LocalDW, you create a table in AzureDW.
On the on-premises network, you have a Data Management Gateway.
Some source data is stored in Azure Blob storage. Some source data is stored on an on-premises Microsoft SQL Server instance. The instance has a table named Table1.
After data is processed by using AzureDF, the data must be archived and accessible forever. The archived data must meet a Service Level Agreement (SLA) for availability of 99 percent. If an Azure region fails, the archived data must be available for reading always.
End of repeated scenario.
You need to connect AzureDF to the storage account.
What should you create?

• A.a linked service
• B.a dataset
• C.a gateway
• D.a pipeline