Microsoft Analyzing and Visualizing Data with Microsoft Power BI 70-778 Exam Questions

Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is the same in each question in this series.

Start of repeated scenario

You have a Microsoft SQL Server database that contains the following tables.

The following columns contain date information:

* Date[Month] in the mmyyyy format

* Date[Date_ID] in the ddmmyyyy format

* Date[Date_name] in the mm/dd/yyyy format

* Monthly_returns[Month_ID] in the mmyyyy format

The Order table contains more than one million rows.

The Store table has a relationship to the Monthly_returns table on the StoreJD column. This is the only relationship between the tables.

You plan to use Power Bl Desktop to create an analytics solution for the data.

End of repeated scenario.

You are modeling the data in Power Bl.

You need to import only a sample of the data from the Order table.

What are two possible ways to achieve the goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

You have a service published to a website.

When you connect to the website, you receive the following data.

You need to create a query that retrieves the Categories data and the Customers data.

Which type of source 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 have a query for a table named Sales. Sales has a column named CustomerlD. The Data Type of CustomerlD 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 CustomerlD column are set to 0.

Solution: From Query Editor, select the CustomerlD column and click Remove Errors.

Does this meet the goal?

You have the following two queries in Power BI Desktop:

A query named Query1 that retrieves a table named SMB_Customers from a Microsoft SQL Server database

A query named Query2 that retrieves a table named Enterprise_Customers from an Oracle database

Both tables have the same columns.

You need to combine the data from SMB_Customers and Enterprise_Customers.

Which command 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 have a query for a table named Sales. Sales has a column named CustomerlD. The Data Type of CustomerlD 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 CustomerlD column are set to 0.

Solution: From Query Editor, open Advanced Editor and add the following query step.

#"Replaced Errors" - Table.ReplaceErrorValues(s"Changed Type", {{"CustomerlD", 0}})

Does this meet the goal?

You have a table in Power BI Desktop as shown in the following exhibit.

You pivot the columns as shown in the following exhibit.

You need to resolve the error in row 3. The solution must preserve all the data.

What should you do?

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 Power BI model that contains two tables named Sales and Date. Sales contains four columns named TotalCost, DueDate, ShipDate, and OrderDate. Date contains one column named Date.

The tables have the following relationships:

The active relationship is on Sales[DueDate].

You need to create measures to count the number of orders by [ShipDate] and the orders by [OrderDate]. You must meet the goal without duplicating data or loading additional data.

Solution: You create a calculated table. You create a measure that uses the new table.

Does this meet the goal?