70-778 Exam Questions

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...

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...

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...

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...

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...

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...

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...

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...

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 dif...

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 dif...

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 dif...

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 ProductCatego...

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 a...

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 m...

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 dis...

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...

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. App...

You plan to embed multiple visualization in a public website. Your Power BI infrastructure contains the visualizations configured as shown in the following table. Which two visuali...

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 ca...

You have an app workspace named Retail Analysis in the Power BI service. You need manage the members that have access to the app workspace. What should you do?

You have a workspace that contains 10 dashboards. A dashboard named Sales Data from two datasets. You discover that users are unable to find data on the dashboard by using natural...

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 dif...

You plan to use Power BI Desktop to create a report. The report will consume data from an on- premises tabular named SalesDB in Microsoft SQL Server Analysis Services (SSAS). The r...

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?

You plan to create several datasets by using the Power BI service. You have the files configured as shown in the following table. You need to identify which files can be used as da...

You have the following two queries in Power BI Desktop: - A query named Query1 that retrieves a table named SMB_Customers from a Microsoft SQL Server database - A query named Query...

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...

You have a Microsoft SharePoint Online site named Sales. Your company has 1,000 sales users. All the sales users can access Sales. You create a report in an app workspace in the Po...

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?

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: Store the District based on Di...

You have a Microsoft Excel 2016 workbook that has a Power Pivot model. The model contains the following tables: Product (Product_id, Producct_Name) Sales (Order_id, Order_Date, Pro...

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 cat...

You have a Power BI model that contains the following tables: Sales (Sales_ID, DateID, sales_amount) Date (DateID, Date, Month, week, Year) The tables have a relationship. Date is...

You have two tables named CustomerVisits and Date in a Power BI model. You create a measure to calculate the number of customer visits. You use the measure in the report shown in t...

You have a Power BI report that is configured to use row-level security (RLS). You have the following roles: - A manager role that limits managers to see only the sales data from t...

You have a Power BI report in an app workspace. You plan to embed a report from the app workspace into a line-of-business application by using Power BI Embedded. Which information...

You have a power BI model that contains the following tables: Assets( AssetsID, AssetName, Purchase_DateID, Value) Date( DateID, Date, Month, Week, Year) The tables have relationsh...

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 q...

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 q...

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 q...

You create a report in the Power BI service that displays the following visualizations: - A KPI that displays the count of customers - A table that displays the count of customers...

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 ca...

You have an app workspace named Retail Store Analysis in the Power BI service. You need to manage the members that have access to the app workspace using the least amount of admini...

Your organization has a Microsoft Office 365 subscription. When the users attempt to access the Power BI Service, they receive the error message shown in the exhibit. You need to e...

You have a Microsoft Excel spreadsheet that contains a table named Sales. You need to add the Sales table to a Power BI dashboard as a tile. How should you configure the tile?

You are creating a report in Power BI Desktop. You are consuming the following tables. Date[Date] is in the mm/dd/yyyy format. Date[DateKey] is in the ddmmyyyy format. Date[MonthNu...

You are creating a report in Power BI Desktop. You are consuming the following tables. You have a new table named Fiscal that has the same schema as the Date table, but contains th...

You use Power BI Desktop to create a visualization for a Microsoft SQL Server data source. You need to ensure that you can use R visualization. Which two actions should you perform...

You have a Power BI model that contains the following two tables: Sales(Sales_ID, sales_date, sales_amount, CustomerID) Customer(CustomerID, First_name, Last_name) There is a relat...

You have a Microsoft SharePoint Online site named Sales. Your company has 1,000 sales users. All the sales users can access Sales. You create a report in an app workspace in the Po...