P.S. Virtual 70-778 braindump are available on Google Drive, GET MORE: https://drive.google.com/open?id=1DsY4MrMrQbFhmpjP8lcA3sh-CLMy30N3
New Microsoft 70-778 Exam Dumps Collection (Question 3 - Question 12)
Q1. You manage a Power BI model has a table named Sales.
You need to ensure that a sales team can view only data that has a CountryRegionName value of United States and a ProductCategory value of Clothing.
What should you do from Power BI Desktop?
A. From Power BI Desktop, create a new role that has the following filter.[countryRegionName]= u201cUnited Statesu201d && [ProductCategory]= u201cClothingu201d
B. Add the following filters in Query Editor.CountryRegionName is United StatesProductCategory is Clothing
C. From Power BI Desktop, create a new role that has the following filters.[CountryRegionName]= u201cUnited Statesu201d
D. Add the following filters to a report.CountryRegionName is United SatesProductCategory is Clothing
Answer: D
Explanation:
References: https://docs.microsoft.com/en-us/power-bi/power-bi-how-to-report-filter
Q2. 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
Answer: B
Explanation:
References: https://docs.microsoft.com/en-us/power-bi/service-admin-administering-power-bi-in-your-organization#how-do-i-remove-power-bi-for-users-that-already-signed-up
Q3. 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.
Answer: A
Explanation:
References: http://www.nubo.eu/en/blog/2021/12/Enable-PowerBI-On-Office-365/
Q4. You plan to create a Power BI report. You have the schema model shown in the exhibit. (Click the exhibit).
The model has the following relationships:
u2711 Store the District based on DistrictID
u2711 Sales to Store based on LocationID
u2711 Sales to Date based on PeriodID
u2711 Sales to Item based on ItemID
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 stores. You need to ensure that the district managers can see Sales by items for the stores they
manage only.
How should you configure the relationship from Sales to Item?
A. Change the Cardinality to One to one (1:1).
B. Change the Cardinality to One to Many (1.*).
C. Select Assume Referential Integrity.
D. Change the Cross filter direction to Both.
Answer: D
Explanation:
References: https://powerbi.microsoft.com/en-us/guided-learning/powerbi-admin-rls/
Q5. You have a Power BI model that contains the following tables:
u2711 Sales (Sales_ID, DateID, sales_amount)
u2711 Date (DateID, Date, Month, week, Year)
The tables have a relationship. Date is marked as a date table in the Power BI model. You need to create a measure to calculate the sales for the last 12 months.
Which DAX formula should you use?
A. CALCULATEx(SUM(sales[sales_amount]) DATESYTD (u2021Dateu2021 [Date]))
B. CALCULATE(SUM(sales[sales_amount]), SAMEPERIODLASTYEAR (u2021Dateu2021 [Date]))
C. SUM(sales[sales_amount])-CALCULATE(SUM(sales[sales_amount]), SAMEPERIODLASTYEAR(u2021Dateu2021[Date]))
D. SUM(sales[sales_amount])- CALCULATE(SUM(sales[sales_amount]),DATESYTD(u2021Dateu2021[Date]))
Answer: C
Explanation:
References:
https://msdn.microsoft.com/en-us/library/ee634825.aspx https://docs.microsoft.com/en-us/power-bi/desktop-quickstart-learn-dax-basics https://msdn.microsoft.com/en-us/library/ee634972.aspx
Q6. You have a table named Sales. A sample of the data in Sales is shown in the following table.
You created a stacked column chart visualization that displays ProductName by Date. You discover that the axis for the visualization displays all the individual dates.
You need to ensure that the visualization displays ProductName by year and that you can drill down to see ProductName by week and day.
What should you do first?
A. Configure a visual filter for the Date column that uses an advanced filter.
B. Create a new table that has columns for the date, year, week, and day.
C. Create a new hierarchy in the Sales table.
D. Format the virtualization and set the type of the X-Axis to Categorical.
Answer: A
Explanation:
References: https://docs.microsoft.com/en-us/power-bi/power-bi-report-add-filter#add-a-filter-to-a-specific-visualization-aka-visual-filter
Q7. 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.
Answer: C
Explanation:
References: https://docs.microsoft.com/en-us/power-bi/service-embed-report-spo
Q8. You have an app workspace that contains a dashboard and four reports. All the reports are generated from a single dataset that contains sales data for your company.
The reports display the data configured as shown in the following table.
You need to ensure that the users of the reports can locate the correct report by using natural language queries.
What should you do?
A. From the properties of the dataset, create four Featured Q&A Questions.
B. From the Format settings of the reports, modify the Page Information.
C. From the properties of the dataset, modify the Q&A and Cortana settings.
D. From the properties of the workspace, modify the Language Settings.
Answer: C
Explanation:
References: https://docs.microsoft.com/en-us/power-bi/service-q-and-a-direct-query#limitations-during-public-preview
Q9. 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 Microsoft Azure Active Directory, you remove the Power BI license from User1.
Does this meet the goal?
A. Yes
B. No
Answer: A
Explanation:
References: https://docs.microsoft.com/en-us/power-bi/service-admin-administering-power-bi-in-your-organization#how-do-i-remove-power-bi-for-users-that-already-signed-up
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.
Answer: D
Explanation:
References: https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about#power-bi-connectivity-modes
P.S. Easily pass 70-778 Exam with Surepassexam Virtual Dumps & pdf vce, Try Free: https://www.surepassexam.com/70-778-exam-dumps.html (58 New Questions)