What should you do?

You have a table in a Microsoft SQL Server database that has more than 5 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 10 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?
A. Load the data to the data model as three tables named Clients, Orders, and Products. Ensure that each table has only the relevant columns. Removeduplicate rows from Clients and Products.
B. Move the database to a Microsoft Azure SQL database. Load the table to the data model.
C. Load the data to one worksheet.
D. Load the data to three worksheets named Clients, Orders, and Products. Ensure that each worksheet has only the relevant columns. Remove duplicate rowsfrom Clients and Products.

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.