Power BI analysis and visualization.

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 ProductCategory value of Clothing. What should you do from Power BI Desktop?

Correct Answer: From Power BI Desktop, create a new role that has the following filters. [CountryRegionName]= "United States"

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?

Correct Answer: Share the dashboard, and then modify the Access settings of the dashboard.

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?

Correct Answer: Deploy an on-premises data gateway. Import the data by using the Import Data Connectivity mode.

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?

Correct Answer: Microsoft Azure SQL Database

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?

Correct Answer: From the Office 365 Admin center, click Users.

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 report will be published to the Power BI service. You need to ensure that the report published to the Power BI service will access the current data in SalesDB. What should you do?

Correct Answer: Deploy an on-premises data gateway and configure the connection to SalesDB to use the Connect live option.

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?

Correct Answer: Microsoft Azure Data Lake Store

You have a workspace that contains 10 dashboards. A dashboard named Sales Data displays data from two datasets. You discover that users are unable to find data on the dashboard by using natural language queries. You need to ensure that the users can find data by using natural language queries. What should you do?

Correct Answer: From the properties of the datasets, modify the Q&A and Cortana settings.

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 marked as a date table in the Power BI model. You need to create a measure to calculate the sales for the last 12 months. Which DAX formula should you use?

Correct Answer: SUM(sales[sales_amount])-CALCULATE(SUM(sales[sales_amount]), SAMEPERIODLASTYEAR(‘Date’[Date]))

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 should you provide to the application developers?

Correct Answer: The app workspace name and the access key

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

Correct Answer: Add the following filters in Query Editor. CountryRegionName is United States ProductCategory is Clothing

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 relationship. Date is marked as a date table in the Power BI model. You need to create a measure to calculate the percentage that the total assets value increased since one year ago. Which DAX formula should you use?

Correct Answer: CALCULATE(sum(Assets[Value]), SAMEPERIODLASTYEAR (Date [Date]))/

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 by country ✑ A line chart that displays the count of customers by year You need to receive an alert when the total number of customers reaches 10,000. What should you do first?

Correct Answer: Pin the KPI to a dashboard.

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?

Correct Answer: SAMEPERIODLAST YEAR

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 administrative effort. What should you do?

Correct Answer: From the Power BI Admin portal, click Tenant settings.

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. (Click the Exhibit button.) You need to ensure that all the users can access the Power BI service. What should you do first?

Correct Answer: From the properties of each dashboard, modify the Share dashboard settings.

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?

Correct Answer: From the Power BI tab in Excel, pin the table.

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 the fiscal dates of your company. You need to create a report that displays the total sales by fiscal month and calendar month. What should you do?

Correct Answer: Add Fiscal to the model and create a one-to-one relationship by using Date[Year] and Fiscal[Year].

You plan to create a Power BI report. You have the schema model shown in the exhibit. (Click the Exhibit button.) The model has the following relationships: ✑ Store to District based on DistrictID Sales to Store based on LocationID ✑ Sales to Date based on PeriodID ✑ Sales to Item based on ItemID You configure row-level security (RLS) so that the district managers of the stores only see the sales from the stores they manage. When the district managers view the Store by Items report, they see items for all the stores. You need to ensure that the district managers can see items for the stores they manage only. How should you configure the relationship from Sales to Item?

Correct Answer: Select Assume Referential Integrity.

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? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Correct Answer: Download and install Microsoft R Server.

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 relationship between Sales and Customer. You need to create a measure to rank the customers based on their total sales amount. Which DAX formula should you use?

Correct Answer: TOPN(ALL(customer), SUMX(RELATEDTABLE(Sales), [Sales_amount]))

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 Power BI service. You embed the report into a page on the Sales site by using the Power BI web part. You need to ensure that all the sales users can view the report from the Sales site. What should you do?

Correct Answer: Configure the Portal Site Connection for the Sales site.

You plan to deploy a Power BI app workspace that will be viewed by 10,000 users. You need to ensure that dashboard data can be updated every 30 minutes. What should you do?

Correct Answer: Store the dataset in Microsoft Azure Storage that uses the Premium storage tier.

You have a Microsoft Excel 2016 workbook that has a Power Pivot model. The model contains the following tables: ✑ Product (Product_id, Product_Name) ✑ Sales (Order_id, Order_Date, Product_id, Salesperson_id, Sales_Amount) ✑ Salesperson (Salesperson_id, Salesperson_name, address) The model has the following relationships: ✑ Sales to Product ✑ Sales to Salesperson You create a new Power BI file and import the Power Pivot model. You need to ensure that you can generate a report that displays the count of products sold by each salesperson. What should you do before you create the report?

Correct Answer: For each relationship, change the Cardinality to One to one (1:1).

You have a Power BI model that contains the following two tables: ✑ Sales (Sales_ID, DateID, sales_amount) ✑ Date(DateID, Date, Month, Week, Year) The tables have a relationship. You need to create a measure to calculate the sales for same period from the previous year. Which DAX formula should you use?

Correct Answer: SUM(sales[sales_amount]) - CALCULATE(SUM(sales[sales_amount]), DATESYID('Date'[Date]))

You plan to develop a Power BI report that has a bar chart to display the number of customers by location. You have a table named Customer that has the following columns: ✑ CustomerID ✑ CustomerName ✑ Address ✑ City ✑ ProvState ✑ Country You need to allow users to drill down by location. The report will display the number of each customer by Country, and drill down to ProvState, and then to City. How should you configure the drill down in the bar chart?

Correct Answer: In the Value field, add Country. In the Legend field, add ProvState at the top, followed by City.

You have a table named Sales that contains sales data for the United States. A sample of the data in Sales is shown in the following table. When you attempt to create a map that shows SalesAmount by Zone, you discover that the map shows a bubble based on cities instead of states. You need to ensure that the map shows bubbles based on states. What should you do?

Correct Answer: Add a column named Country that contains United States as the value.

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 the exhibit. (Click the Exhibit button.) You discover that the total number of customer visits was 60,000, and that there were only 5,000 customer visits in August. You need to fix the report to display the correct data for each month. What should you do?

Correct Answer: Modify the measure to use the CALCULATE DAX function.

You have the following tables. There is a many-to-one relationship from Subscriber to Date that uses Subscriber[StartDate] and Date[Date]. The Cross filter direction of the relationship is set to Single. You plan to create a column chart that displays the following two measures: ✑ Count of SubscriberID by Month based on the StartDate ✑ Count of SubscriberID by Month based on the EndDate What should you do before you create the measures?

Correct Answer: Change the Cross filter direction of the active relationship to Both.

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?

Correct Answer: Add a slicer to the page that uses the year column.

Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series. Start of repeated scenario. You have a Microsoft SQL Server database that has the tables shown in the Database Diagram exhibit. (Click the Exhibit button.) You plan to develop a Power BI model as shown in the Power BI Model exhibit. (Click the Exhibit button.) You plan to use Power BI to import data from 2013 to 2015. Product Subcategory[Subcategory] contains NULL values. End of Repeated Scenario. You implement the Power BI model. You need to add a measure to rank total sales by product. The results must appear as shown in the following table. Which DAX formula should you use?

Correct Answer: Product Ranking = RANKX(ALL('Product'), [SalesAmount],,DESC, Dense)

Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series. Start of repeated scenario. You have a Microsoft SQL Server database that has the tables shown in the Database Diagram exhibit. (Click the Exhibit button.) You plan to develop a Power BI model as shown in the Power BI Model exhibit. (Click the Exhibit button.) You plan to use Power BI to import data from 2013 to 2015. Product Subcategory[Subcategory] contains NULL values. End of Repeated Scenario. You implement the Power BI model. You plan to add a table named Date to the model. The table will have columns for the date, year, month, and end of the last month, and will include data from January 1, 2013 to December 31, 2015. The Date table and the Sales table will have a relationship. Which DAX functions should you use to create the columns?

Correct Answer: CALENDAR, YEAR, MONTH, and EOMONTH

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?

Correct Answer: Configure the Data source settings.

You have a Power BI model that has a date table. A sample of the data shown in the following table. You need to add a column to display the date in the format of December 01, 2014. Which DAX formula should you use in Power BI Desktop?

Correct Answer: FORMAT([Date], "MMMM DD, YYYY")

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?

Correct Answer: From the Split Column menu, click By Delimiter.

Welcome to awslagi.com – Sharing AWS, Google Cloud, Microsoft Azure IT Exams. It's free for all!

Analyzing and Visualizing Data with Microsoft Power BI

Analyze and visualize data with Microsoft Power BI effectively.

4.8★★★★★(342 ratings)

19,524 studentsIntermediate

Learn to transform data into dashboards and reports that support decision-making. The exam emphasizes analysis, modeling, and visualization skills needed to communicate insights clearly with Power BI. This certification is ideal for analysts who want to create business-facing reports. It helps you turn raw data into meaningful visuals that guide action and improve understanding.

What you'll learn

Build Power BI reports- Create dashboards- Model data for analysis- Visualize key metrics- Share insights effectively

70-778

Lectures2

Quizzes0

Duration30 week

Students19,524

$20.00

📢 Unlock Full Access to Success!

"The content displayed here is a promotional preview and contains only 50% of the actual exam database. To access the complete set of updated questions, please upgrade to the Full Version."

👉 Click the button and follow the instructions to secure your full access immediately!