A user creates a Power B1 report named ReportA that uses a custom theme
You create a dashboard named DashboardA.
You need to ensure that DashboardA uses the custom theme. The solution must minimize development effort.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
From DashboardA upload a JSON theme.
Publish ReportA to the Microsoft Power B1 Community theme gallery.
From DashboardA create a custom theme.
From ReportA save the current theme.
Publish ReportA to Power Bl.
You have a Microsoft Excel file on a file server.
You create a Power BI report and import a table from the Excel file.
You publish the report.
You need to ensure that the data refreshes every four hours.
What should you do first?
Upload the Excel file to a Power BI workspace.
Create a subscription to the report.
Deploy an on-premises data gateway.
Edit the data source credentials.
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. App1 appears in the My organization AppSource for your account.
You need to ensure that User sees App1 from the My organization AppSource.
What should you do?
From the app workspace, click Update app, configure the Content settings, and then click Update app.
From the app workspace settings, add a member.
From the app workspace, click Update app, configure the Access setting, and then click Update app.
From the app workspace, share the dashboard.
You have a Power B1 dataset that contains quarterly sales performance data.
You need to enable managers to review the data in a format that meets the following requirements:
• Is optimized for printing.
• Renders data in Microsoft Excel, Word, PowerPoint, and PDF formats.
What should you create?
a paginated report
a template app
an interactive report
a dashboard
You are building a Power Bl report that uses data from an Azure SQL database named erp1.
You Import the following tables.
You need to perform the following analyses:
• Orders sold over time that include a measure of the total order value
• Orders by attributes of products sold
The solution must minimize update times when interacting with visuals in the report. What should you do first?
From Power Query, merge the Orders query and the Order Line Hems query.
Calculate the count of orders per product by using a DAX function.
Create a calculated column that adds a list of product categories to the Orders table by using a DAX function.
From Power Query, merge the Order Line Items query and the Products query.
https://www.sqlbi.com/articles/header-detail-vs-star-schema-mode ls-in-tabular-and-power-bi/
You have a Power Bl report named Report1 and a dashboard named Dashboard1, Report1 contains a line chart named Sales by month.
You pin the Sales by month visual to Dashboard1.
In Report1, you change the Sales by month visual to a bar chart.
You need to ensure that bar chart displays on Dashboard1.
What should you do?
Edit the details for the dashboard tile of Dashboard1.
Select Refresh visuals for Dashboard1.
the Sales by month bar chart to Dashboard1
Refresh the dataset used by Report1 and Dashboard1.
You have a dataset that contains revenue data from the past year.
You need to use anomaly detection in Power Bl to show anomalies in the dataset.
What should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You have the Azure SQL databases shown in the following table.
You plan to build a single PBIX file to meet the following requirements:
• Data must be consumed from the database that corresponds to each stage of the development lifecycle.
• Power Bl deployment pipelines must NOT be used.
• The solution must minimize administrative effort.
What should you do? To answer, select the appropriate options in the answer area.
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 are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records.
During the development process, you need to import a sample of the data from the Order table.
Solution: You add a WHERE clause to the SQL statement.
Does this meet the goal?
Yes
No
The WHERE clause has its effects before the data is imported.
Your company has affiliates who help the company acquire customers.
You build a report for the affiliate managers at the company to assist them in understanding affiliate performance.
The managers request a visual showing the total sales value of the latest 50 transactions for each affiliate. You have a data model that contains the following tables.
You need to develop a measure to support the visual.
How should you complete the DAX expression? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Box 1: CALCULATE
Start with CALCULATE and use a SUMX.
CALCULATE evaluates an expression in a modified filter context.
Box 2: SUM
Box 3: TOPN
TOPN returns the top N rows of the specified table.
Box 4: [TransactionDate]
TOPN Syntax: TOPN( The orderBy_expression: Any DAX expression where the result value is used to sort the table and it is evaluated for each row of table. You have the tables shown in the following table. The Impressions table contains approximately 30 million records per month. You need to create an ad analytics system to meet the following requirements: Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point. Group the impressions by Ad_id, Site_name, and Impression_date. Aggregate by using the CountRows function. Create one-to-many relationships between the tables. Create a calculated measure that aggregates by using the COUNTROWS function. Create a calculated table that contains Ad_id, Site_name, and Impression_date. Grouping in power query reduces the number of rows in the impression table that is gonna be loaded in the model. Creating relationships doesn't increase the size of the model. You have the following three versions of an Azure SQL database: You have a dataset that uses the development database as a data source. You need to configure the dataset so that you can easily change the data source between the development, test, and production database servers from powerbi.com. Which should you do? Create a JSON file that contains the database server names. Import the JSON file to the dataset. Create a parameter and update the queries to use the parameter. Create a query for each database server and hide the development tables. Set the data source privacy level to Organizational and use the ReplaceValue Power Query M function. https://docs.microsoft.co m/en-us/learn/modules/create-manage-workspaces-power-bi/4-development-lifecycle-strategy You have the Power Bl model shown in the following exhibit. There are four departments in the Departments table. You need to ensure that users can see the data of their respective department only. What should you do? Create a row-level security (RLS) role for each department, and then define the membership of the role. Create a DepartmentID parameter to filter the Departments table. To the ConfidentialData table, add a calculated measure that uses the currentgroup DAX function. Create a slicer that filters Departments based on DepartmentID. You have a Power B1 model that contains a table named Date. The table has the following columns. see the expalanation for the answer below. Answer is below. You have the CSV file shown in the following table. You use Power Query Editor to preview the data in the file. You need to transform the data to meet the following requirements: • The first column must contain the month. • The second column must contain the year. • The third column must contain the order amount for the month and year. Which transformation should you use first? unpivot pivot transpose remove You have a Power Bl table named Customer that contains a field named Email Address. You discover that multiple records contain the same email address. You need to create a calculated column to identify which records have duplicate email addresses. How should you complete the OAX expression for the calculated column? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content NOTE: Each correct selection is worth one point. You are to count the number of rows having same email address. 1. Declare a variable and call it any name you prefer 2. Calculate the row count on the table 3. Apply filter to ALL of the values in the table under the column name email address and equate it to the variable. You may need to read up filter functions for a proper understanding of how it works. You plan to create a report that will display sales data from the last year for multiple regions You need to restrict access to individual rows of the data on a per region-basis by using roles. Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. You have a line chart that shows the number of employees in a department over time. You need to see the total salary costs of the employees when you hover over a data point. What is possible way to achieve this goal? Add a salary to the tooltips. Add a salary to the visual filters. Add salary to the drillthrough fields. A business intelligence (Bl) developer creates a dataflow in Power Bl that uses DirectQuery to access tables from an on premises Microsoft SQL server. The Enhanced Dataflows Compute Engine is turned on for the dataflow. You need to use the dataflow in a report. The solution must meet the following requirements: • Minimize online processing operations. • Minimize calculation times and render times for visuals. • include data from the current year, up to and including the previous day. What should you do? Create a dataflows connection that has Import mode selected and schedule a dairy refresh. Create a dataflows connection that has DirectQuery mode selected. Create a dataflows connection that has DirectQuery mode selected and configure a gateway connection for the dataset Create a dataflows connection that has Import mode selected and create a Microsoft Power Automate solution to refresh the data hourly. You have a Power Bl report that uses row-level security (RLS). You need to transfer RLS membership maintenance to an Azure network security team. The solution must NOT provide the Azure network security team with the ability to manage reports, datasets. or dashboards. What should you do? Add the Azure network security team as members of the RLS role. Instruct the Azure network security team to create security groups. Configure RLS to use the groups. Configure custom instructions for the Request access feature that instructs users to contact the Azure network security team. Grant the Read and Build permissions for the Power Bl datasets to the Azure network security team. It is common practice that the PBI developer creates RLS groups and instructs the network team to create the corresponding AD roles. Then the developer assigns the AD groups to the RLS groups. You are creating a Power 81 model to analyze inventory. You load data into three tables named Date Product, and Inventor/. The Inventor/ table relates to the Date and Product tables by using one-to-many relationships. Inventor)' data is recorded daily with no exceptions. The correct inventory quantity for a given product in a month is the last recorded value for that month You need to write a DAX measure that will show the correct inventory value when a user analyzes inventory by year, month, or date. How should you complete the measure? To answer select the appropriate options in the answer area. NOTE: Each correct selection is worth one point You have a Power BI report. You need to create a calculated table to return the 100 highest spending customers. How should you complete the DAX expression? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Box 1: TOPN TOPN returns the top N rows of the specified table. Box 2: SUMMARIZE SUMMARIZE returns a summary table for the requested totals over a set of groups. Box 3: DESC Sort in descending order. It is last in the TOPN command. TOPN syntax: TOPN( You have two Power Bl workspaces named WorkspaceA and Workspaces. WorkspaceA contains two datasets named Sales and HR. You need to provide a user named User1 with access to the workspaces. The solution must meet the following requirements: • Create reports that use the HR dataset. • Publish the reports to WorkspaceB. • Prevent the ability to modify the HR dataset. • Prevent the ability to add users to WorkspaceB. See the explanation for the answer. Answer is as below. Which two types of visualizations can be used in the balance sheet reports to meet the reporting goals? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point. a line chart that shows balances by quarter filtered to account categories that are long-term liabilities. a clustered column chart that shows balances by date (x-axis) and account category (legend) without filters. a clustered column chart that shows balances by quarter filtered to account categories that are long-term liabilities. a pie chart that shows balances by account category without filters. a ribbon chart that shows balances by quarter and accounts in the legend. https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-types-for-reports-and-q-and-a You need to grant access to the business unit analysts. What should you configure? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Box 1: The Viewer role to the workspace The Viewer role gives a read-only experience to its users. They can view dashboards, reports, or workbooks in the workspace, but can’t browse the datasets or dataflows. Use the Viewer role wherever you would previously use a classic workspace set to “Members can only view Power BI content”. Box 2: Build The analysts must be able to build new reports from the dataset that contains the profit and loss data. Scenario: The reports must be made available to the board from powerbi.com. The analysts responsible for each business unit must see all the data the board sees, except the profit and loss data, which must be restricted to only their business unit's data. The analysts must be able to build new reports from the dataset that contains the profit and loss data, but any reports that the analysts build must not be included in the quarterly reports for the board. The analysts must not be able to share the quarterly reports with anyone. You need to recommend a strategy to consistently define the business unit, department, and product category data and make the data usable across reports. What should you recommend? Create a shared dataset for each standardized entity. Create dataflows for the standardized data and make the dataflows available for use in all imported datasets. For every report, create and use a single shared dataset that contains the standardized data. For the three entities, create exports of the data from the Power Bl model to Excel and store the data in Microsoft OneDrive for others to use as a source. What is the minimum number of datasets and storage modes required to support the reports? two imported datasets a single DirectQuery dataset two DirectQuery datasets a single imported dataset "The analysts responsible for each business unit must see all the data the board sees, except the profit and loss data, which must be restricted to only their business unit's data. The analysts must be able to build new reports from the dataset that contains the profit and loss data" => one dataset and two separate workspaces Reason: All data can be imported into one dataset also if these are two logical models. Shared dimensions can be reconsumed in both models. Reports and additional materials can be shared to the board with an app. The "profit and loss" data model needs RLS for the analysts and the analysts must have just read access to the original workspace. In a separate workspace with contributer (or more rights) they can create new reports (with live connection to the dataset). It is also stated that the new reports mustn't be shared so therefore no need to include them into the app. Import vs. DirectQuery: Due to RLS requirements an imported dataset is needed. It is not possible with file sources and Sharepoint lists. Which DAX expression should you use to get the ending balances in the balance sheet reports? CALCULATE ( SUM( BalanceSheet [BalanceAmount] ), DATESQTD( 'Date'[Date] ) ) CALCULATE ( SUM( BalanceSheet [BalanceAmount] ), LASTDATE( 'Date'[Date] ) ) FIRSTNONBLANK ( 'Date' [Date] SUM( BalanceSheet[BalanceAmount] ) ) CALCULATE ( MAX( BalanceSheet[BalanceAmount] ), LASTDATE( 'Date' [Date] ) ) Scenario: At least one of the balance sheet reports in the quarterly reporting package must show the ending balances for the quarter, as well as for the previous quarter. DATESQTD returns a table that contains a column of the dates for the quarter to date, in the current context. Once the profit and loss dataset is created, which four actions should you perform in sequence to ensure that the business unit analysts see the appropriate profit and loss data? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. https://docs.microsoft .com/en-us/power-bi/admin/service-admin-rls https://docs.microsoft.com/en-us/power-bi/connect-data/service-datasets-build-permissions How should you distribute the reports to the board? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Box 1: Using a workspace membership Scenario: The company wants to provide a single package of reports to the board that contains custom navigation and links to supplementary information. Note: Workspace is a shared environment for a group of people. You can have multiple Power BI content in a workspace. One workspace can have hundreds of dashboards, reports, and datasets in it. Box 2: A mail-enabled security group Scenario: Security Requirements The reports must be made available to the board from powerbi.com. A mail-enabled security group will be used to share information with the board. You need to ensure that the data is updated to meet the report requirements. The solution must minimize configuration effort. What should you do? From each report in powerbi.com. select Refresh visuals From Power Bl Desktop, download the PBIX file and refresh the data. Configure a scheduled refresh without using an on-premises data gateway. Configure a scheduled refresh by using an on-premises data gateway You need to create a DAX measure in the data model that only allows users to see projections at the appropriate levels of granularity. How should you complete the measure? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point. Scenario: Revenue projections are set at the monthly level and summed to show projections for the quarter. Box 1: IF Box 2: ISFILTERED ISFILTERED returns TRUE when columnName is being filtered directly. If there is no filter on the column or if the filtering happens because a different column in the same table or in a related table is being filtered then the function returns FALSE. Box 3: SUM You need to create the relationship between the product list and the revenue results. The solution must minimize the time it takes to render visuals. What should you set as the relationship cardinality? One to one Many to one One to many Many to many You need to calculate the last day of the month in the balance sheet data to ensure that you can relate the balance sheet data to the Date table. Which type of calculation and which formula should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Box 1: A DAX Calculated measure Box 2: Date.EndofQuarter(#date([Year],[Mont],1)) ENDOFQUARTER returns the last date of the quarter in the current context for the specified column of dates. The following sample formula creates a measure that returns the end of the quarter, for the current context. = ENDOFQUARTER(DateTime[DateKey]) You need to create relationships to meet the reporting requirements of the customer service department. What should you create? an additional date table named ShipDate, a one-to-many relationship from Sales[sales_date_id] to Date[date_id], and a one-to-many relationship from Sales[sales_ship_date_id] to ShipDate[date_id] an additional date table named ShipDate, a many-to-many relationship from Sales[sales_date_id] to Date[date_id], and a many-to-many relationship from Sales[sales_ship_date_id] to ShipDate[date_id] a one-to-many relationship from Date[date_id] to Sales[sales_date_id] and another one-to-many relationship from Date[date_id] to Weekly_Returns[week_id] a one-to-many relationship from Sales[sales_date_id] to Date[date_id] and a one-to-many relationship from Sales[sales_ship_date_id] to Date[date_id] a one-to-many relationship from Date[date_id] to Sales[sales_date_id] and another one-to-many relationship from Date[date_id] to Sales[sales_ship_date_id] Scenario: The customer service department requires a visual that can be filtered by both sales month and ship month independently. What should you create to meet the reporting requirements of the sales department? a measure that uses a formula of SUM (Sales [sales_id]) a calculated column that use a formula of COUNTA(sales [sales_id]) a measure that uses a formula of COUNTROWS (Sales) a calculated column that uses a formula of SUM (Sales [sales_id]) The sale department requires reports that contain the number of sales transactions. The COUNTROWS function counts the number of rows in the specified table, or in a table defined by an expression. You need to create a calculated column to display the month based on the reporting requirements. Which DAX expression should you use? FORMAT('Date'[date], "MMM YYYY") FORMAT('Date' [date], "M YY") FORMAT('Date'[date_id], "MMM") & "" & FORMAT('Date'[year], "#") FORMAT('Date' [date_id], "MMM YYYY") You merge data from Sales.Region, Region_Manager, Sales_Manager, and Manager into a single table named Region. What should you do next to meet the reporting requirements of the executives? Apply row-level security (RLS) to the Region table based on the sales manager username. Configure a bi-directional relationship between Region and Sales.Region. Create a DAX calculated column that retrieves the region manager from the Weekly.Returns table based on the sales.regionjd column. In the Region table, create a hierarchy that has the manager name, and then the sales manager name. You need to get data from the Microsoft SQL Server tables. What should you use to configure the connection' import that uses a Microsoft account DirectQuery that uses the end-user s credentials DirectQuery that uses a database credential Import that uses a database credential You publish the dataset to powerbi.com. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. Graphical user interface, text, application, email
Description automatically generated You need to create a relationship between the Weekly_Returns table and the Date table to meet the reporting requirements of the regional managers. What should you do? In the Weekly.Returns table, create a new calculated column named date-id in a format of yyyymmdd and use the calculated column to create a relationship to the Date table. Add the Weekly_Returns data to the Sales table by using related DAX functions. Create a new table based on the Date table where date-id is unique, and then create a many-to-many relationship to Weekly_Return. Scenario: Region managers require a visual to analyze weekly sales and returns. To relate the two tables we need a common column. You need to address the data concerns before creating the data model. What should you do in Power Query Editor? Select Column distribution. Select the sales_amount column and apply a number filter. Select Column profile, and then select the sales_amount column. Transform the sales_amount column to replace negative values with 0. You need to create a visualization to meet the reporting requirements of the sales managers. How should you create the visualization? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Scenario: The sales managers require a visual to analyze sales performance versus sales targets. Box 1: KPI A Key Performance Indicator (KPI) is a visual cue that communicates the amount of progress made toward a measurable goal. Box 2: Sales[sales_amount] Box 3: Date[month] Time > FiscalMonth. This value will represent the trend. Box 4: Targets[sales_target] You need to create the required relationship for the executive's visual. What should you do before you can create the relationship? Change the data type of Sales[region_id] to Whole Number. In the Sales table, add a measure for sum(sales_amount). Change the data type of sales[sales_id] to Text. Change the data type of sales [region_id] to Decimal Number. Scenario: Executives require a visual that shows sales by region. Need to change the sales_id column from Varchar to Whole Number (Integer). You need to provide a solution to provide the sales managers with the required access. What should you include in the solution? Create a security role that has a table filter on the Sales_Manager table where username = UserName() Create a security role that has a table filter on the Region_Manager table where sales_manager_id = UserPrincipalName(). Create a security role that has a table filter on the Sales_Manager table where name = UserName(). Create a security role that has a table filter on the Sales_Manager table where username = sales_manager_id. https://powerbi.microsoft.com/en-us/blog/using-u sername-in-dax-with-row-level-security/ You need to minimize me size of the dataset. The solution must meet the report requirements What should you do? Change lite OrderlD column in the Orders table to the text data type. Filter out discontinued products while importing the Product table. Remove the QuantityPerUnit column from the Products table Group the Categories table by the CategorylD column. You need to create a measure that will return the percentage of late orders. How should you complete the DAX expression? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Graphical user interface, application
Description automatically generated Box 1: CALCULATE CALCULATE evaluates an expression in a modified filter context. Syntax: CALCULATE( Expression - The expression to be evaluated. filter1, filter2,… (Optional) Boolean expressions or table expressions that defines filters, or filter modifier functions. Box 2: FILTER FILTER returns a table that represents a subset of another table or expression. Syntax: FILTER( Table- The table to be filtered. The table can also be an expression that results in a table. Filter - A Boolean expression that is to be evaluated for each row of the table. For example, [Amount] > 0 or [Region] = "France" Box 3: Orders[ShippedDate]> Orders[RequiredDate] Northwind Traders defines late orders as those shipped after the required shipping date. You need to create a relationship in the dataset for RLS. What should you do? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Text
Description automatically generated Box 1: many-to-one Each employee in the Sales Employees table is assigned to one sales region. Multiple employees can be assigned to each region. The Suppliers table has a Region column. Box 2: Suppliers table You need to design the data model and the relationships for the Customer Details worksheet and the Orders table by using Power BI. The solution must meet the report requirements. For each of the following statement, select Yes if the statement is true, Otherwise, select No. NOTE: Each correct selection is worth one point. TESTED 04 May 2024 Copyright © 2014-2024 DumpsBuddy. All Rights Reserved,
Options:
Answer:
A, B
Explanation:
Options:
Answer:
B
Explanation:
Options:
Answer:
A
Options:
Answer:
Explanation:
Options:
Answer:
C
Options:
Answer:
Explanation:
Options:
Answer:
Options:
Answer:
A
Explanation:
Options:
Answer:
A
Options:
Answer:
B
Explanation:
Options:
Answer:
Options:
Answer:
Explanation:
,
Options:
Answer:
Explanation:
Options:
Answer:
A, E
Explanation:
Options:
Answer:
Explanation:
Options:
Answer:
B
Options:
Answer:
D
Explanation:
Options:
Answer:
A
Explanation:
Options:
Answer:
Explanation:
Options:
Answer:
Explanation:
Options:
Answer:
C
Options:
Answer:
Explanation:
Options:
Answer:
C
Options:
Answer:
Explanation:
Options:
Answer:
A
Explanation:
Options:
Answer:
C
Explanation:
Options:
Answer:
A
Options:
Answer:
C
Options:
Answer:
B
Options:
Answer:
Explanation:
Options:
Answer:
A
Explanation:
Options:
Answer:
C
Options:
Answer:
Explanation:
Options:
Answer:
A
Explanation:
Options:
Answer:
A
Explanation:
Options:
Answer:
C
Options:
Answer:
Explanation:
,
Options:
Answer:
Explanation:
Options:
Answer:
Quick Links
Why Us
Unlimited Packages
Site Secure
We Accept
DumpsBuddy. All Rights Reserved