Free Analyzing and Visualizing Data with Microsoft Power BI 70-778 Exam Practice Test

You manage a Power BI model has a table named Sales and product.You need to ensure that a sales team can view only data that has a CountryRegionName value of United States and a ProductCategory value of Clothing.What should you do from Power BI Desktop?

• From Power BI Desktop, create a new role that has the following filter.[countryRegionName]= ''United States'' && [ProductCategory]= ''Clothing''
• Add the following filters in Query Editor.CountryRegionName is United StatesProductCategory is Clothing
• From Power BI Desktop, create a new role that has the following filters.[CountryRegionName]= ''United States''
• Add the following filters to a report.CountryRegionName is United SatesProductCategory is Clothing

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 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 Power BI model that contains two tables named Sales and Date. Sales contains four columns named TotalCost, DueDate, ShipDate, and OrderDate. Date contains one column named Date.The tables have the following relationships:The active relationship is on Sales[DueDate].You need to create measures to count the number of orders by [ShipDate] and the orders by [OrderDate]. You must meet the goal without duplicating data or loading additional data.Solution: You create measures that use the CALCULATE, COUNT, and FILTER DAX functions.Does this meet the goal?

• Yes
• No

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?

• Subscriptions
• Dashboards
• Datasets
• Workbooks

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 Remove Errors.Does this meet the goal?

• Yes
• No

In the Power BI service, you create an app workplace that contains several dashboards.You need to provide a user named user1@contoso.com with the ability to edit and publish dashboards.What should you do?

• Modify the members of the app workspace.
• Configure security for the dataset used by the app.
• Share the dashboard, and then modify the Access settings of the dashboard.
• From the app workspace, click Update app, and then configure the Access settings.

A data analyst publishes several Power BI visualizations to a blog.You discover that some of the visualizations contain data that is considered private by your company.You need to prevent the visualizations from being published to the blog.What should you do?

• From the Power BI Admin portal, disable the Publish to web setting.
• From the Power BI settings, delete the embedded codes.
• From the Power BI Admin portal, disable the Share content with external users setting.
• From the dashboard settings, modify the Share dashboard settings.

You have two Microsoft SQL Server database servers named SQLProd and SQLDev. SQLDev contains the same tables as SQLProd, but only a subset of the data in SQLProd.You create a new Power BI Desktop model that uses 120 tables from SQLDev.You plan to publish the Power BI file to the Power BI service.You need to connect the model to the tables in SQLProd. The solution must minimize administrative effort.What should you do from Query Editor before you publish the model?

• Create a new connection to SQLProd, and then import the tables from SQLProd.
• Delete the existing queries, and then add new data sources.
• Configure the Data source settings.
• Edit the source of each table query.

Your company has several developers who plan to create custom solutions that will interact with the API for the Power BI service.Which three operations can the developers achieve by using the API? Each correct answer presents a complete solution.NOTE: Each correct selection is worth one point.

• Retrieve rows from a dataset
• Create a dataset
• Add rows to a dataset
• Refresh an imported dataset
• Add a member to a row-level security role

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 three types of visualizations should you include in the report? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.

• bubble maps
• custom visuals
• R visuals
• breadcrumbs
• funnel charts

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 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.Your company has 1,000 users in a Microsoft Office 365 subscription.A Power BI administrator named Admin1 creates 20 dashboards and shares them with 50 users.You discover that a user named User1 can access all the dashboards.You need to prevent User1 from accessing all the dashboards.Solution: From the Office 365 Admin center, you remove the Power BI license from User1.Does this meet the goal?

• Yes
• No