70-779 · Question #43
You have a table in a Microsoft SQL Server database that has more than 50 columns. A sample of the data and some of the columns are shown in the following table. The table contains more than two…
Sign in or unlock 70-779 to reveal the answer and full explanation for question #43. The question stem and answer options stay visible for context.
Question
You have a table in a Microsoft SQL Server database that has more than 50 columns. A sample of the data and some of the columns are shown in the following table. The table contains more than two million rows. You have 100 clients and 100 products. You need to load the data to Excel. The solution must minimize the amount of memory used by the model. What should you do?
Exhibit
Options
- AMove the database to a Microsoft Azure SQL database. Load the table to the data model.
- BLoad the data to the data model as three tables named Clients, Orders, and Products. Ensure
- CLoad the data to one worksheet.
- DLoad the data to three worksheets named Clients, Orders, and Products. Ensure that each
Unlock 70-779 to see the answer
You've previewed enough free 70-779 questions. Unlock 70-779 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.