Power BI 70-778 - Exam Review | Questions & Answers (100% Verified)

Power BI 70-778 - Exam Review | Questions & Answers (100% Verified) Power BI 70-778 - Exam Review | Questions & Answers (100% Verified) 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? - ANSWER - DATESYTD 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 chart remains unchanged. What should you do? - ANSWER - Edit the interactions form the Format menu. 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? - ANSWER - Deploy an on-premises data gateway. Import the data by using the DirectQuery Data Connectivity mode. 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? - ANSWER - Dataset In the Power BI service, you create an app workplace that contains several dashboards. You need to provide a user named with the ability to edit and publish dashboards What should you do? - ANSWER - Modify the members of the app workspace. You plan to use Power BI Desktop optimized for Power BI Report Server to create a report. The report will be published to Power BI Report Server. You need to ensure that all the visualization in the report can be consumed by users. Which two types of visualizations should you exclude from the report? a) funnel charts b) custom visuals c) bubble maps d) breadcrumbs e) R visuals - ANSWER - d, e