P.S. Pinpoint 70-778 prep are available on Google Drive, GET MORE: https://drive.google.com/open?id=1B1-cc80N9I92n0MN9aRLFZj3h3SJUCGh
New Microsoft 70-778 Exam Dumps Collection (Question 1 - Question 10)
Q1. You have a Power BI 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 remains unchanged.
What should you do?
A. Set a visual level filter on the bar chart.
B. Edit the interactions form the Format menu.
C. Set a visual level filter on the donut chart.
D. Add a slicer to the page that uses the year column.
Answer: B
Explanation:
References: https://www.excelguru.ca/blog/2021/11/23/visual-interactions-in-power-bi/
Q2. 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.
Answer: B
Explanation:
References: https://msdn.microsoft.com/en-us/library/mt798301.aspx
Q3. You have an on-premises Power BI Report Server.
You plan to create a report in Power BI Desktop and publish the report to the report server. Which data source should the report use?
A. Microsoft Azure SQL Database
B. a Microsoft SQL Server database
C. a Microsoft SQL Server Analysis Services (SSAS) database
D. Microsoft Excel
Answer: C
Explanation:
References:
https://docs.microsoft.com/en-us/power-bi/report-server/quickstart-create-powerbi-report https://docs.microsoft.com/en-us/power-bi/report-server/connect-data-sources
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.
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 and click Replace Errors. Does this meet the goal?
A. Yes
B. No
Answer: A
Explanation:
References: https://docs.microsoft.com/en-us/power-bi/desktop-shape-and-combine-data
Q5. HOTSPOT
You have the following tables.
You need to create a measure to calculate a running total of TransactionQuantity.
How should you complete the DAX formula? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
References: http://www.daxpatterns.com/cumulative-total/
Q6. 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.
Answer: C
Explanation:
References: https://docs.microsoft.com/en-us/power-bi/service-organizational-content-pack-introduction#what-is-appsource
Q7. 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?
A. PARALLELPERIOD
B. SAMEPERIODLAST YEAR
C. DATESYTD
D. PREVIOUSYEAR
Answer: A
Explanation:
References: https://msdn.microsoft.com/en-us/library/ee634873.aspx
Q8. 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 new column to the Product Subcategory table that uses the following formula.
=if [Subcategory] =null then u201cNAu201d else [Subcategory] Which command should you use in Query Editor?
A. Column From Examples
B. Custom Column
C. Invoke Custom Function
D. Conditional Column
Answer: D
Explanation:
References: http://community.powerbi.com/t5/Desktop/if-then-else/td-p/117999
Q9. 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 row3. The solution must preserve all the data. What should you do?
A. Change the Data Type of the Value column.
B. Select the Score column, and then click Remove Errors.
C. Select the Key column, and then click Remove Duplicates
D. Change the Aggregate Value Function of the pivot.
Answer: D
Explanation:
References: https://docs.microsoft.com/en-us/power-bi/desktop-common-query-tasks
Q10. You have a Power BI report that is configured to use row-level security (RLS).
You have the following roles:
u2711 A manager role that limits managers to see only the sales data from the stores they manage.
u2711 A region role that limits users to see only the data from their respective region
You plan to use Power BU Embedded to embed the report into an application. The application will authenticate the users.
You need to ensure that RLS is enforced when accessing the embedded report. What should you do?
A. In the access token for the application, include the user name and the role name.
B. In the access token for the application, include the report URL and the Microsoft Azure Active Directory Domain name.
C. From dev.powerbi.com/apps, register the new application and enable the Read All Reports API access.
D. From dev.powerbi.com/apps, register the new application and enable the Read All Groups API access.
Answer: A
Explanation:
References: https://docs.microsoft.com/en-us/power-bi/developer/embedded-row-level- security
P.S. Easily pass 70-778 Exam with Examcollection Pinpoint Dumps & pdf vce, Try Free: http://www.examcollectionuk.com/70-778-vce-download.html (58 New Questions)