Microsoft
70-779 · Question #43
70-779 Question #43: Real Exam Question with Answer & Explanation
The correct answer is B. Load the data to the data model as three tables named Clients, Orders, and Products. Ensure. See the full explanation below for the reasoning.
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
Community Discussion
No community discussion yet for this question.