Practice Microsoft MCSA 70-778 FREE Dumps Questions

1. Note: This question it 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.


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

The Oder table contains more than one million rows.
The Store table has a relationship to the Monthy_returns table on the StoreID column. This is the only relationship between the tables.
You plan to use Power BI Desktop to create an analytics solution for the data.


You are modifying the model to report on the number of orders.
You need to calculate the number of orders.
What should you do?

2. Note: This question it 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.


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

The Oder table contains more than one million rows.
The Store table has a relationship to the Monthy_returns table on the StoreID column. This is the only relationship between the tables.
You plan to use Power BI Desktop to create an analytics solution for the data.


You plan to create a chart that displays total Order [Order_amount] by Store [Name].
You need to modify the model to ensure that you can create the chart.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

3. You plan to use Power BI Desktop to create a report. The report will consume data from an on-premises tabular database named SalesDB in Microsoft SQL Server Analysis Service (SSAS). The report will be published to the Power BI service.
You need to ensure that the report published to the Power BI service will access the current data in Sales DB.
What should you do?

4. from Power BI Desktop, you create a query that imports the following table.


You need to configure the table to appear as shown in the following table.


What should you do?

5. You plan to create several datasets by using the Power BI service.
You have the files configured as shown in the following table.


You need to identify which files can be used as datasets,
Which two files should you identify? Each correct answer presents pact of the solution
NOTE: Each correct selection is worth one point.

6. You have the following two queries in Power BI Desktop:
• A Query named Query 1 that retrieves a table named SM8_ 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?

7. You have a table in Power B1 Desktop as shown m 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?

8. You have a Microsoft SharePoint Online site named Sales.
You company has 1.000 sales users. All the sales users can access Sales.
You create a report in an app workspace in the Power BI service You embed the report into a page on the Sales site by using the Power BI web part.
You need to ensure that all the sales users can view the report from the Sales site.
What should you do?

9. You plan to use Power BI Embedded to deliver reports in a web application. You need to ensure that the reports display live data Which data source you should use?

10. You have a table named Sales. A sample of the data in Sales is shown in the following table.


You create a stacked column chart visualization mat displays Product Name by Date.
You discover that the axis for the visualization displays all the individual dates.
You need to ensure that the visualization displays Product Name by year and that you can drill down to see Product Name by week and day.
What should you do first?

11. You plan to create a Power BI report You have the schema model shown m the exhibit. (Click the exhibit. button.) The model has the following relationships:


You configure row-level security (RLS) so that the district managers of the stores only see the sales from the stores they manage.
When the district managers view the sales report, they see Sales by Items for all the stores.
You need to ensure that the district managers cart see Sales by Hems for the stores they manage only.
How should you configure the relationship from Sales to Item?

12. You have a Microsoft Excel 2016 workbook that has Power Pivot model. The model contains the following tables:


The model has the following relationships:


You create a new Power 61 file and import the Power Pivot model.
You need to ensure that you can generate a report that displays the count of products sold by each salesperson.
What should you do before you create the report?

13. You have a Power 61 report that displays a bar chart and a donut chart on the same page. The bar chart shows the total sales by year and the donut chart shows the total sale by category.
You need to ensure that when you select a year on the bar chart, the donut chart remains unchanged
What should you do?

14. You have a Power BI model that contains the following two tables:


The tables have a relationship. Date is marked as a date table in the Power B1 model.
You need to create a measure to calculate the sales for the last 12 months.
Which DAX formula should you use?
A)


B)


C)


D)

15. You have two tables named Customer Visits and Date m a Power BI model.
You create a measure to calculate the number of customer visits. You use the measure m the report shown in the exhibit. (Click the Exhibit button.)


You discover that the total number of customer visits was 60,000, and that there were only 5,000 customer visits in August.
You need to fix the report to display the correct data for each month.
What should you do?

16. You have a Power BI report that is configured to use row-level security (RLS).
You have the following roles:
• A manager role that limits managers to see only the sales data from the stores they manage.
• A region role that limits users to see only the data from their respective region
You plan to use Power BI Embedded to embed the report into an application. The application will authenticate the users. You need to ensure that RIS is enforced when accessing the embedded report.
What should you do?

17. You have a Power BI report in an app workspace.
You plan to embed a report from the app workspace into a line-of-business application by using Power BI Embedded.
Which information should you provide to the application developers?

18. You have a Power BI model that contains the following two tablets:


A)


B)


C)


D)

19. You have a Power BI model for sales data.
You need to create a measure to calculate the year-to-date sales and to compare those sales to the previous year for the same time period.
Which DAX function should you use?

20. You are create a report in Power BI Desktop.
You are consuming the following tables.


Date [Date] is in the mm/dd/yyy format. Date[DateKey] is in the ddmmyyy format. Date[MonthNumber] is in the mm formate[MonthName] is in the mmm format.
You create the report shown in the exhibit. (Click the Exhibit button.)
You need to ensure that the months appear in the order of the calendar.
How should you sort the MonthName column?