Note This question is part of a series of questions that present the same

Note this question is part of a series of questions

This preview shows page 3 - 6 out of 15 pages.

4.Note: This question is part of a series of questions that present thesame scenario. Each question in the series contains a unique solutionthat might meet the stated goals. Some question sets might have morethan one correct solution, while others might not have a correctsolution.After you answer a question in this section, you will NOT be able toreturn to it. As a result, these questions will not appear in the reviewscreen.You have a table named Table1 that contains 3 billion rows. Table1contains data from the last 36 months.At the end of every month, the oldest month of data is removed basedon a column named DateTime.You need to minimize how long it takes to remove the oldest month ofdata.Solution: You implement round robin for table distribution.Does this meet the goal? A. YesB. NoAnswer: A 5.You are developing an application by using the Microsoft .Net SDK. The application will access data from a Microsoft Azure Data lakefolder.You plan to authenticate the application by using service to serviceauthentication. page 3 / 15
Image of page 3
You need to ensure that the application can access the Data lakefolder.Which three actions should you perform? Each correct answerpresents part of the solution. 6.Note: This question is part of a series of questions that present thesame scenario. Each question in the series contains a unique solutionthat might meet the stated goals. Some question sets might have morethan one correct solution, while others might not have a correctsolution.You are monitoring user queries to a Microsoft Azure SQL datawarehouse that has six compute nodes.You discover that compute node utilization is uneven. Therows_processed column from sys.dm_pdw_dms_workers shows asignificant variation in the number of rows being moved among thedistributions for the same table for the same query.You need to ensure that the load is distributed evenly across thecompute nodes. page 4 / 15
Image of page 4
Image of page 5
Image of page 6

You've reached the end of your free preview.

Want to read all 15 pages?

  • Spring '18
  • E. J Janet Smith
  • .NET Framework, Microsoft SQL Server, Microsoft Visual Studio, Microsoft Azure

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture