70-778 exam

HOTSPOT You have a query that retrieves data from a Microsoft Azure SQL database. You discover that a column named Error Code has several values starting with a space character, and a column named SubStatus contains several non-printable characters. You need to remove all the leading whit spaces form Error...

You have a Microsoft SharePoint Online site named Sales. You company has 1.000 sales users. All the sales users can access Sales. You create a report in an app workspace in the Power BI service You embed the report into a page on the Sales site by using the Power...

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

DRAG DROP You have a column named phone_number. The values in the columns are in one of the following formats: The values after x in the phone_number column indicate the phone extension. How should you complete the query? To answer, drag the appropriate value to the correct targets. Each value...

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

You have a Power BI app named App1. The privacy for the App1 app 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...

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 CharactersB . From the Extract menu, click Text After DelimiterC . From...

DRAG DROP You have a Microsoft Exert workbook that contains two tables From Power BI you create a dashboard that displays data from the tables. You update the tables each day. You need to ensure that the visualizations in the dashboard are updated daily. Which three actions should you perform...

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 . PARALLELPERIOOB . SAMPERIOOLASTYEARC . DATESYTDD . PREVIOUSYEARView AnswerAnswer: C

You plan to use Power BI Embedded to deliver reports in a web application. You need to ensure that the reports display live data Which data source you should use?A . Microsoft Azure Data Lake StoreB . Microsoft Azure Table StorageC . Microsoft Azure HD lnsightD . Microsoft Azure SQL...