Microsoft Power BI 70-778 Certification Exam | Questions & Answers (Rated A+)

Microsoft Power BI 70-778 Certification Exam | Questions & Answers (Rated A+) Microsoft Power BI 70-778 Certification Exam | Questions & Answers (Rated A+) 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) PARALELLPERIOD b) SAMEPERIODLASTYEAR c) DATESYTD d) PREVIOUSYEAR - ANSWER - c) 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? 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) 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? 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) Deploy an on-premises data gateway (personal mode). 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? a) Subscriptions b) Dashboards c) Dataset d) Workbooks - ANSWER - c) Dataset