http://https://www.lead1pass.com/Microsoft/70-776-practice-exam-dumps.html (70 Q&As Dumps, 30%OFF Special Discount: 30free )

NEW QUESTION NO: 7
You manage an on-premises data warehouse that uses Microsoft SQL Server. The data warehouse contains 100 TB of data. The data is partitioned by month. One TB of data is added to the data warehouse each month.
You create A Microsoft Azure SQL data warehouse and copy the on-premises data to the data warehouse.
You need to implement a process to replicate the on-premises data warehouse to the Azure SQL data warehouse. The solution must support daily incremental updates and must provide error handling.
What should you use?
A. the export and import of BACPAC files
B. SQL Server Integration Services (SSIS)
C. SQL Server backup and restore
D. SQL Server snapshot replication
Answer: B
Explanation/Reference:
SQL Data Warehouse supports many loading methods, including SSIS, BCP, the SQLBulkCopy API, and Azure Data Factory (ADF).
References: https://docs.microsoft.com/en-us/sql/integration-services/data-flow/error-handling-in-data

NEW 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. Stream the audit logs to an event hub
C. Send the audit logs to Log Analytics
D. Send the request logs to Log Analytics
Answer: C
Explanation/Reference:
Explanation:
A request log captures every API request. An audit log records all operations that are triggered by that API request.
You can analyze the logs with OMS Log Analytics.
References: https://docs.microsoft.com/en-us/azure/security/azure-log-audit

NEW QUESTION NO: 9
You have a Microsoft Azure SQL data warehouse.
You need to configure Data Warehouse Units (DWUs) to ensure that you have six compute nodes. The solution must minimize costs.
Which value should set for the DWUs?
A. DW200
B. DW400
C. DW600
D. DW1000
Answer: C
Explanation/Reference:
Explanation:
The following table shows how the number of distributions per Compute node changes as the data warehouse units change. DWU6000 provides 60 Compute nodes and achieves much higher query performance than DWU100.

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

NEW QUESTION NO: 10
You plan to use Microsoft Azure Event Hubs in Azure Stream Analytics to consume time-series aggregations from several published data sources, such as IoT data, reference data, and social media.
You expect TB of data to be consumed daily. All the consumed data will be retained for one week.
You need to recommend a storage solution for the data. The solution must minimize costs.
What should you recommend?
A. Azure Table Storage
B. Azure Blob Storage
C. Azure DocumentDB
D. Azure Data Lake
Answer: C
Explanation/Reference:
Explanation:
Azure Cosmos DB is beneficial in web, mobile, gaming, and IoT applications that need low response times and need to handle massive amounts of reads and writes.
Note: Azure Cosmos DB is Microsoft's proprietary globally-distributed, multi-model database service "for managing data at planet-scale" launched in May 2017. It builds upon and extends the earlier Azure DocumentDB, which was released in 2014.
References:
https://azure.microsoft.com/en-us/services/cosmos-db/?v=17.45b
https://en.wikipedia.org/wiki/Cosmos_DB

NEW QUESTION NO: 11
You plan to deploy a Microsoft Azure virtual machine that will a host data warehouse. The data warehouse will contain a 10-TB database.
You need to provide the fastest read and writes times for the database.
Which disk configuration should you use?
A. stripped volumes
B. storage pools with striped disks
C. spanned volumes
D. storage pools with mirrored disks
E. RAID 5 volumes
Answer: B

NEW QUESTION NO: 12
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.

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. ALTER SERVER ROLE LargeRC ADD MEMBER LoaderUser;
B. EXEC sp_addrolemember 'largerc', 'LoaderLogin'
C. ALTER SERVER ROLE xLargeRC ADD MEMBER LoaderLogin;
D. EXEC sp_addrolemember 'xlargerc', 'LoaderUser'
Answer: D
Explanation/Reference:
Explanation:
Dynamic Resource Classes (smallrc, mediumrc, largerc, xlargerc) allocate a variable amount of memory depending on the current DWU. This means that when you scale up to a larger DWU, your queries automatically get more memory.
Memory allocations per distribution for dynamic resource classes (MB)

References: https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-develop- concurrency

NEW QUESTION NO: 13
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. Stream Analytics
B. the EventHubSender class
C. the Azure CLI
D. Apache Storm in Azure HDInsight
Answer: A
Explanation/Reference:
Explanation:
Streamed data represents data that can be generated by various sources such as applications, devices, sensors, etc. This data can be ingested into a Data Lake Store by variety tools. These tools will usually capture and process the data on an event-by-event basis in real-time, and then write the events in batches into Data Lake Store so that they can be further processed.
References: https://docs.microsoft.com/en-us/azure/data-lake-store/data-lake-store-data-scenarios

NEW QUESTION NO: 14
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:

B:

C:

D:

A. Option D
B. Option A
C. Option C
D. Option B
Answer: D

NEW QUESTION NO: 15
You plan to capture the output from a group of 500 IoT devices that produce approximately 10 GB of data per hour by using Microsoft Azure Stream Analytics. The data will be retained for one year.
Once the data is processed, it will be stored in Azure, and then analyzed by using an Azure HDInsight cluster.
You need to select where to store the output data from Stream Analytics. The solution must minimize costs.
What should you select?
A. Azure SQL Data Warehouse
B. Azure Table Storage
C. Azure SQL Database
D. Azure Blob storage
Answer: D
Explanation/Reference:
Explanation:
Example: With an Azure Storage container as a custom endpoint, IoT Hub will write messages to a blob based on the batch frequency and block size specified by the customer. After either the batch size or the batch frequency are hit, whichever happens first, IoT Hub will then write the enqueued messages to the storage container as a blob. You can also specify the naming convention you want to use for your blobs, as shown below.

Incorrect Answers:
A: Azure Stream Analytics data source outputs: A streaming job can have multiple outputs. Supported outputs are Azure Event Hubs, Azure Blob storage, Azure Table storage, Azure SQL DB, and Power BI.
References: https://azure.microsoft.com/en-us/blog/route-iot-device-messages-to-azure-storage-with- azure-iot-hub/

NEW QUESTION NO: 16
You need to connect to a Microsoft Azure SQL data warehouse from an Azure Machine Learning experiment.
Which data source should you use?
A. Azure Table
B. SQL Database
C. Web URL via HTTP
D. Data Feed Provider
Answer: B
Explanation/Reference:
Explanation:
Use Azure SQL Database as the Data Source.
References: https://docs.microsoft.com/en-us/azure/machine-learning/studio-module-reference/import- from-azure-sql-database