70-776 | Microsoft 70-776 Exam Questions 2021

It is more faster and easier to pass the 70-776 Study Guides by using 70-776 Exam Dumps. Immediate access to the 70-776 Exam Dumps and find the same core area 70-776 Dumps with professionally verified answers, then PASS your exam with a high score now.

Online Microsoft 70-776 free dumps demo Below:

NEW QUESTION 1
Note: This question is part of a series of questions that present the same scenario. Each question in
the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a table named Table1 that contains 3 billion rows. Table1 contains data from the last 36 months.
At the end of every month, the oldest month of data is removed based on a column named DateTime.
You need to minimize how long it takes to remove the oldest month of data. Solution: You specify DateTime as the hash distribution column.
Does this meet the goal?

  • A. Yes
  • B. No

Answer: B

NEW QUESTION 2
HOTSPOT
You have a Microsoft Azure Data Factory version 2 (V2) service.
You need to deploy a linked service to an existing database in Azure SQL Data Warehouse.
How should you complete the JSON snippet? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
70-776 dumps exhibit

    Answer:

    Explanation: 70-776 dumps exhibit

    NEW QUESTION 3
    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.

    Answer: B

    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

    NEW QUESTION 4
    DRAG DROP
    You have a Microsoft Azure SQL data warehouse.
    Users discover that reports running in the data warehouse take longer than expected to complete. You need to review the duration of the queries and which users are running the queries currently. Which dynamic management view should you review for each requirement? To answer, drag the appropriate dynamic management views to the correct requirements. Each dynamic management view 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.
    70-776 dumps exhibit

      Answer:

      Explanation:
      References:
      https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-pdw-exec-requests-transact-sql
      https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-pdw-exec-sessions-transact-sql

      NEW QUESTION 5
      Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
      After you answer a question in this sections, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
      You are monitoring user queries to a Microsoft Azure SQL data warehouse that has six compute nodes.
      You discover that compute node utilization is uneven. The rows_processed column from sys.dm_pdw_workers shows a significant variation in the number of rows being moved among the distributions for the same table for the same query.
      You need to ensure that the load is distributed evenly across the compute nodes. Solution: You change the table to use a column that is not skewed for hash distribution. Does this meet the goal?

      • A. Yes
      • B. No

      Answer: A

      NEW QUESTION 6
      You have a Microsoft Azure SQL data warehouse named DW1 that is used only from Monday to Friday.
      You need to minimize Data Warehouse Unit (DWU) usage during the weekend. What should you do?

      • A. From the Azure CLI, run the account set command.
      • B. Run the ALTER DATABASE statement.
      • C. Call the Create or Update Database REST API.
      • D. Run the Suspend-AzureRmSqlDatabase Azure PowerShell cmdlet.

      Answer: D

      NEW QUESTION 7
      DRAG DROP
      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.
      70-776 dumps exhibit

        Answer:

        Explanation: 70-776 dumps exhibit

        NEW QUESTION 8
        HOTSPOT
        You are creating a series of activities for a Microsoft Azure Data Factory. The first activity will copy an input dataset named Dataset1 to an output dataset named Dataset2. The second activity will copy a dataset named Dataset3 to an output dataset named Dataset4.
        Dataset1 is located in Azure Table Storage. Dataset2 is located in Azure Blob storage. Dataset3 is located in an Azure Data Lake store. Dataset4 is located in an Azure SQL data warehouse.
        You need to configure the inputs for the second activity. The solution must ensure that Dataset3 is copied after Dataset2 is created.
        How should you complete the JSON code for the second activity? To answer, select the appropriate options in the answer area.
        NOTE: Each correct selection is worth one point.
        70-776 dumps exhibit

          Answer:

          Explanation:
          References:
          https://github.com/aelij/azure-content/blob/master/articles/data-factory/data-factory-create- pipelines.md

          NEW QUESTION 9
          You are designing a solution that will use Microsoft Azure Data Lake Store.
          You need to recommend a solution to ensure that the storage service is available if a regional outage occurs. The solution must minimize costs.
          What should you recommend?

          • A. Create two Data Lake Store accounts and copy the data by using Azure Data Factory.
          • B. Create one Data Lake Store account that uses a monthly commitment package.
          • C. Create one read-access geo-redundant storage (RA-GRS) account and configure a Recovery Services vault.
          • D. Create one Data Lake Store account and create an Azure Resource Manager template that redeploys the services to a different region.

          Answer: D

          NEW QUESTION 10
          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.

          Answer: A

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

          NEW QUESTION 11
          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?
          70-776 dumps exhibit
          70-776 dumps exhibit
          70-776 dumps exhibit
          70-776 dumps exhibit

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

          Answer: A

          NEW QUESTION 12
          DRAG DROP
          You have IoT devices that produce the following output.
          70-776 dumps exhibit
          You need to use Microsoft Azure Stream Analytics to convert the output into the tabular format described in the following table.
          70-776 dumps exhibit
          How should you complete the Stream Analytics query? 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.
          70-776 dumps exhibit

            Answer:

            Explanation: 70-776 dumps exhibit

            NEW QUESTION 13
            DRAG DROP
            You need to create a dataset in Microsoft Azure Data Factory that meets the following requirements: How should you complete the JSON code? 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.
            70-776 dumps exhibit

              Answer:

              Explanation:
              References:
              https://github.com/aelij/azure-content/blob/master/articles/data-factory/data-factory-create-pipelines.md

              NEW QUESTION 14
              DRAG DROP
              You are monitoring a Microsoft Azure SQL data warehouse. You need to get the following information:
              - The top 10 longest running queries
              - The distributed query plan for a specific query
              Which dynamic management view should you use for each piece of information? To answer, drag the appropriate dynamic management views to the correct pieces of information. Each dynamic management view 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.
              70-776 dumps exhibit

                Answer:

                Explanation:
                References:
                https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-manage-monitor

                NEW QUESTION 15
                You need to define an input dataset for a Microsoft Azure Data Factory pipeline.
                Which properties should you include when you define the dataset?

                • A. name, type, typeProperties, and availability
                • B. name, typeProperties, structure, and availability
                • C. name, policy, structure, and external
                • D. name, type, policy, and structure

                Answer: A

                Explanation:
                References:
                https://docs.microsoft.com/en-us/azure/data-factory/v1/data-factory-create-datasets

                NEW QUESTION 16
                Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
                After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
                You are troubleshooting a slice in Microsoft Azure Data Factory for a dataset that has been in a waiting state for the last three days. The dataset should have been ready two days ago.
                The dataset is being produced outside the scope of Azure Data Factory. The dataset is defined by using the following JSON code.
                70-776 dumps exhibit
                You need to modify the JSON code to ensure that the dataset is marked as ready whenever there is data in the data store.
                Solution: You change the interval to 24.
                Does this meet the goal?

                • A. Yes
                • B. No

                Answer: B

                Explanation:
                References:
                https://docs.microsoft.com/en-us/azure/data-factory/v1/data-factory-create-datasets

                NEW QUESTION 17
                You plan to deploy a Microsoft Azure Stream Analytics job to filter multiple input streams from IoT devices that have a total data flow of 30 MB/s.
                You need to calculate how many streaming units you require for the job. The solution must prevent lag.
                What is the minimum number of streaming units required?

                • A. 3
                • B. 10
                • C. 30
                • D. 300

                Answer: C

                NEW QUESTION 18
                You have the following process:
                • A CSV file is ingested by Microsoft Azure Stream Analytics.
                • Scoring is performed by Azure Machine Learning.
                • Stream Analytics returns sentiment scoring through a web service endpoint.
                • Stream Analytics creates an output blob.
                You need to view the output of the scoring operation and to evaluate the throughput to the Machine Learning models.
                Which monitoring data should you evaluate from the Azure portal?

                • A. the request count of Stream Analytics
                • B. the request count of Machine Learning
                • C. the event count of Stream Analytics
                • D. the event count of Machine Learning

                Answer: C

                Recommend!! Get the Full 70-776 dumps in VCE and PDF From Simply pass, Welcome to Download: https://www.simply-pass.com/Microsoft-exam/70-776-dumps.html (New 91 Q&As Version)