High value MCSA 70-778 exam

Q4. Note: This question is a 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.

Your company has 1,000 users in a Microsoft Office 365 subscription.

A Power BI administrator named Admin1 creates 20 dashboards and shares them with 50 users.

You discover that a use name User1 can access all the dashboards. You need to prevent User1 from accessing all the dashboards.

Solution: From the properties of each dashboard, you modify the Share settings. Does this meet the goal?

A. Yes

B. No

View Answer

Q5. Note: This question is a part of a series of questions that present 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 exactly the same in each question in this series.

Start of repeated scenario

You have a Microsoft SQL Server database that has the tables shown in the Database Diagram exhibit. (Click the Exhibit.)

You plan to develop a Power BI model as shown in the Power BI Model exhibit. (Click the Exhibit).

You plan to use Power BI to import data from 2013 to 2015. Product Subcategory [Subcategory] contains NULL values. End of repeated scenario.

You implement the Power BI model.

You need to add a measure to rank total sales by product. The results must appear as shown in the following table.

Which DAX formula should you use?

A. Product Ranking= RANKX (Product, [SalesAmount], , DESC, Skip)

B. Product Ranking= RANKX (ALL, (u2021Productu2021), [SalesAmount], , DESC, Dense)

C. Product Ranking= RANKX (ALL, (u2021Productu2021), [SalesAmount], , DESC, Skip)

D. Product Ranking= RANKX (ALL (u2021Productu2021), [SalesAmount], , Asc, Dense

View Answer

Q6. Note: This question is a part of a series of questions that present 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 exactly 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 data information:

u2711 Date[Month] in the mmyyyy format

u2711 Date[Date_ID] in the ddmmyyyy format

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

u2711 Monthly_returns[Month_ID] in the mmyyyy format

The Order table contains more than one million rows.

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

You plan to use Power BI desktop to create an analytics solution for the data. End of repeated scenario.

You are modifying the model to report on the number of order.

You need to calculate the number of orders. What should you do?

A. Create a calculated measure that uses the COUNTA(Order_ID) DAX formula.

B. Create a calculated measure that uses the SUM (Order_ID) DAX formula.

C. Create a calculated column that uses the SUM (Order_ID) DAX formula.

D. Create a calculated column that uses the COUNTA (Order_ID) DAX formula.

View Answer

Q7. You have two tables named CustomerVisits and Date in a Power BI model.

You create a measure to calculate the number of customer visits. You use the measure in the report shown in the exhibit. (Click the Exhibit.)

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?

A. Create a relationship between the CustomerVisits table and the Date table.

B. Create a hierarchy in the Date table.

C. Modify the n=measure to use the CALCULATE DAX function.

D. Modify the measure to use the SUM DAX function.

View Answer

Q8. Your organization has a team of power users who recently created 20 Power BI dashboards.

The power users share the dashboards with other users in the organization.

When the users attempt to access the dashboards, they receive the error message shown in the exhibit. (Click the Exhibit.)

You need to ensure that all the users can access the dashboards. What should you do first?

A. From the Microsoft Office 365 Admin center, and the Power BI (free) subscription, and then assign a license to each user.

B. From the Power BI Admin portal, modify the Privacy Settings.

C. From the properties of each dashboard, modify the Share dashboard settings.

D. Instruct each user to install Microsoft Office 2021.

View Answer

Q9. You have a Power BI dashboard that displays different visualizations of company sales.

You enable Q&A on the dashboard.

You need to provide users with sample questions that they can ask when using Q&A.

Which settings should you modify from the Power BI Settings?

A. Subscriptions

B. Dashboards

C. Datasets

D. Workbooks

View Answer

Q10. You plan to create a dashboard in the Power BI service that retrieves data from a Microsoft SQL Server database. The dashboard will be shared between the users in your organization.

You need to ensure that the users will see the current data when they view the dashboard. How should you configure the connection to the data source?

A. Deploy an on-premises data gateway (personal mode). Import the data by using the Import Data Connectivity mode.

B. Deploy an on-premises data gateway. Import the data by using the Import Data Connectivity mode.

C. Deploy an on-premises data gateway. Import the data by using the DirectQuery Data Connectivity mode.

D. Deploy an on-premises data gateway (personal mode). Import the data by using the DirectQuery Data Connectivity mode.

View Answer

Q11. 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?

A. From the Extract menu, click Last Characters.

B. From the Extract menu, click Text After Delimiter.

C. From the Format menu, click Trim.

D. From the Split Column menu, click BY Delimiter.

View Answer

Q12. You have a Power BI app named App1. The privacy for the App1 workspace is set to Private.

A user named User1 reports that App1 does not appear in the My organization AppSource. App1 appears in the My organization AppSource for your account.

You need to ensure that User sees App1 from the My organization AppSource.

What should you do?

A. From the app workspace, click Update app, configure the Content settings, and then click Update app.

B. From the app workspace settings, add a member.

C. From the app workspace, click Update app, configure the Access setting, and then click Update app.

D. From the app workspace, share the dashboard.

View Answer

Q13. You embed a Power BI report in a Microsoft SharePoint Online page.

A user name User1 can access the SharePoint Online page, but the Power BI web part displays the following error message: u201cThis content isnu2021t availableu201d.

User1 is unable to view the report.

You verify that you can access the SharePoint Online page and that the Power BI report displays as expected.

You need to ensure that User1 can view the report form SharePoint Online. What should you do?

A. Publish the app workspace.

B. Edit the settings of the Power BI web part.

C. Modify the members of the app workplace.

D. Share the dashboards in the app workspace.

View Answer