http://https://www.examslabs.com/Microsoft/Microsoft-Azure-SQL-Data-Warehous/best-70-776-exam-dumps.html (70 Q&As Dumps, 30%OFF Special Discount: bmzblwH7 )
NEW QUESTION NO: 7
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 implement round robin for table distribution.
Does this meet the goal?
A. Yes
B. No
Answer: B
NEW QUESTION NO: 8
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. storage pools with striped disks
B. spanned volumes
C. storage pools with mirrored disks
D. RAID 5 volumes
E. stripped volumes
Answer: A
NEW QUESTION NO: 9
You have a Microsoft Azure Data Factory that recently ran several activities in parallel. You receive alerts indicating that there are insufficient resources.
From the Activity Windows list in the Monitoring and Management app, you discover the statuses described in the following table.
Which activity cannot complete because of insufficient resources?
A. Activity2
B. Activity5
C. Activity4
D. Activity7
Answer: B
NEW QUESTION NO: 10
DRAG DROP
You have an Apache Hive database in a Microsoft Azure HDInsight cluster. You create an Azure Data Factory named DF1.
You need to transform the data in the Hive database and to output the data to Azure Blob storage.
Which three cmdlets should you run in sequence? To answer, move the appropriate cmdlets from the list of cmdlets to the answer area and arrange them in the correct order.
Answer:
Explanation:
References:
https://docs.microsoft.com/en-us/powershell/module/azurerm.datafactories/new-azurermdatafactorypipelin e?view=azurermps-4.4.0
https://github.com/aelij/azure-content/blob/master/articles/data-factory/data-factory-build-your-first-pipeline
-using-powershell.md
NEW QUESTION NO: 11
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. a URL
B. an email alias
C. a server name
D. a subscription ID
Answer: A
NEW QUESTION NO: 12
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 D
B. Option B
C. Option C
D. Option A
Answer: D
NEW QUESTION NO: 13
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. SQL Server log shipping
B. the AzCopy utility
C. Azure Data Factory
D. the Azure Import/Export service
Answer: C
NEW QUESTION NO: 14
DRAG DROP
You plan to create for an alert for a Microsoft Azure Data Factory pipeline.
You need to configure the alert to trigger when the total number of failed runs exceeds five within a three-hour period.
How should you configure the window size and the threshold in the JSON file? 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.
Answer:
Explanation:
References:
https://docs.microsoft.com/en-us/azure/data-factory/v1/data-factory-monitor-manage-pipelines?view=powe rbiapi-1.1.10
NEW QUESTION NO: 15
You have a Microsoft Azure SQL data warehouse that has 10 compute nodes.
You need to export 10 TB of data from a data warehouse table to several new flat files in Azure Blob storage. The solution must maximize the use of the available compute nodes.
What should you do?
A. Use the bcp utility.
B. Create a Microsoft SQL Server Integration Services (SSIS) package that has an SSIS Azure Blob Storage task.
C. Create a Microsoft SQL Server Integration Services (SSIS) package that has a data flow task.
D. Execute the CREATE EXTERNAL TABLE AS SELECT statement.
Answer: B
NEW QUESTION NO: 16
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. Run the Suspend-AzureRmSqlDatabase Azure PowerShell cmdlet.
B. From the Azure CLI, run the account set command.
C. Run the ALTER DATABASE statement.
D. Call the Create or Update Database REST API.
Answer: A
NEW QUESTION NO: 17
HOTSPOT
You are designing a fact table that has 100 million rows and 1,800 partitions. The partitions are defined based on a column named OrderDayKey. The fact table will contain:
✑ Data from the last five years
✑ A clustered columnstore index
✑ A column named YearMonthKey that stores the year and the month
Multiple transformations will be performed on the fact table during the loading process. The fact table will be hash distributed on a column named OrderId.
You plan to load the data to a staging table and to perform transformations on the staging table. You will then load the data from the staging table to the final fact table.
You need to design a solution to load the data to the fact table. The solution must minimize how long it takes to perform the following tasks:
✑ Load the staging table.
✑ Transfer the data from the staging table to the fact table.
✑ Remove data that is older than five years.
✑ Query the data in the fact table
How should you configure the tables? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
