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 query for a table named Sales. Sales has a column named CustomerID. The Data Type of CustomerID is Whole Number.
You refresh the data and find several errors. You discover that new entries in the Sales table contain nonnumeric values.
You need to ensure that nonnumeric values in the CustomerID column are set to 0.
Solution: From Query Editor, select the CustomerID column. Click Replace Errors... and enter a value of.
Does this meet the goal?

You have a large dataset that contains more than 1 million rows. The table has a datetime column named Date.
You need to reduce the size of the data model.
What should you do?

You have a Microsoft Power Bl dashboard.
You need to ensure that consumers of the dashboard can give you feedback that will be visible to the other consumers of the dashboard.
What should you use?

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 create a parameter named DataSourceExcel that holds the file name and location of a Microsoft Excel data source.
You need to update the query to reference the parameter instead of multiple hard-coded copies of the location within each query definition.
Solution: In the Power Query M code, you replace references to the Excel file with DataSourceExcel.
Does this meet the goal?

How should you distribute the reports to the board? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.