Question # 4
You are configuring a Microsoft Power Bl data model to enable users to ask natural language questions by using Q&A. You have a table named Customer that has the following measure.
Customer Count = DISTINCTCOUNT(Customer[CustomerID])
Users frequently refer to customers as subscribers.
You need to ensure that the users can get a useful result for "subscriber count" by using Q&A. The solution must minimize the size of the model.
What should you do?
A.
Add a description of "subscriber count" to the Customer Count measure.
B.
Set Summarize By to None for the CustomerlD column.
C.
Add a description of "Subscriber" to the Customer table.
D.
Add a synonym of "subscriber" to the Customer table.
Full Access
Answer:
B
Explanation:
You can add synonyms to tables and columns.
Note: This step applies specifically to Q&A (and not to Power BI reports in general). Users often have a variety of terms they use to refer to the same thing, such as total sales, net sales, total net sales. You can add these synonyms to tables and columns in the Power BI model.
This step applies specifically to Q&A (and not to Power BI reports in general). Users often have a variety of terms they use to refer to the same thing, such as total sales, net sales, total net sales. You can add these synonyms to tables and columns in the Power BI model.
[Reference:, https://docs.microsoft.com/en-us/power-bi/natural-language/q-and-a-best-practices, , , ]
Question # 5
You are creating a query to be used as a Country dimension in a star schema.
A snapshot of the source data is shown in the following table.
You need to create the dimension. The dimension must contain a list of unique countries.
Which two actions should you perform? Each correct answer presents part of the solution.
A.
Remove duplicates from the Country column.
B.
Remove duplicates from the City column.
C.
|Remove duplicates from the table.
D.
Delete the City column.
E.
Delete the Country column.
Full Access
Answer:
A, D
Explanation:
To create a dimension table for Country from your source data, you need to perform these two actions34:
Delete the City column. You don’t need this column for your Country dimension, as it is not a descriptive attribute of Country. You can create another dimension table for City if you want to use it in your analysis.
Remove duplicates from the Country column. You want to have a list of unique countries in your dimension table, so you need to remove any duplicate values from this column.
Question # 6
The Sales table contains records of sales by day from the last five years up until today's date.
You plan to create a measure to return the total sales Of March 2021 when March 2022 is selected.
Which DAX expression should you use?
A.
Option A
B.
Option B
C.
option C
D.
Option D
Full Access
Answer:
B
Question # 7
You have a Microsoft Power Bl workspace.
You need to grant the user capabilities shown in the following table.
The solution must use the principle of least privilege.
Which user role should you assign to each user? To answer, drag the appropriate roles to the correct users. Each role 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.
Full Access
Answer:
Answer: 
Explanation:
User 1 = Member
User 2 = Contributor
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-new-workspaces
Question # 8
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.
Full Access
Answer:
Answer: 
Explanation:
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 a Power B1 dataset named Finance that is hosted in a Power B1 workspace. The finance team at your company is NOT currently a member of any Power B1 workspace roles. You need to enable the finance team to use Microsoft Excel to analyze the Finance dataset. What should you do? Create a row-level security (RLS) role and add the finance team to the role as members. Provide an Excel workbook that is connected to the Finance dataset. Grant the finance team write permissions to the Finance dataset. Grant the finance team build permissions to the Finance dataset. Your company has training videos that are published to Microsoft Stream. You need to surface the videos directly in a Microsoft Power BI dashboard. Which type of tile should you add? video custom streaming data text box web content https://do cs.microsoft.com/en-us/stream/portal-embed-video https://docs.microsoft.com/en-us/power-bi/create-reports/service-dashboard-add-widget#add-web-content You are creating a visual to show the ranking of product categories by sales revenue. Your company's security policy states that you cannot send data outside of your Microsoft Power Bl tenant Which approach provides the widest variety of visuals while adhering to the security policy? Use default visuals or custom visuals uploaded from a .pbiviz file. Use only default visuals. Use default or any custom visuals from the marketplace. Use default or certified custom visuals. You have a Microsoft Power BI report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com. The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is scheduled to refresh twice a day at 08:00 and 17:00. The report is a single page that contains 15 AppSource visuals and 10 default visuals. Users say that the report is slow to load the visuals when they access and interact with the report. You need to recommend a solution to improve the performance of the report. What should you recommend? Change any DAX measures to use iterator functions. Replace the default visuals with AppSource visuals. Change the imported dataset to DirectQuery. Remove unused columns from tables in the data model. DirectQuery: No data is imported or copied into Power BI Desktop. Import: The selected tables and columns are imported into Power BI Desktop. As you create or interact with a visualization, Power BI Desktop uses the imported data. Benefits of using DirectQuery There are a few benefits to using DirectQuery: DirectQuery lets you build visualizations over very large datasets, where it would otherwise be unfeasible to first import all the data with pre-aggregation. Underlying data changes can require a refresh of data. For some reports, the need to display current data can require large data transfers, making reimporting data unfeasible. By contrast, DirectQuery reports always use current data. The 1-GB dataset limitation doesn't apply to DirectQuery. You are creating an analytics report that will consume data from the tables shown in the following table. There is a relationship between the tables. There are no reporting requirements on employeejd and employee_photo. You need to optimize the data model What should you configure for employeejd and employee.photo? To answer, select the appropriate options in the answer area. Box 1: Hide Optimize data by hiding fields and sorting visualization data Box 2: Delete The fastest way to optimize your Power BI report is to limit the number of columns to only the ones you need in your data model. Go through your tables in Power Query and determine what fields are being used. Delete these columns if they are not being used in any of your reports or calculations. You have a Power BI data model that contains a table named Employees. The table has the following columns: • Employee Name • Email Address • Start Date • Job Title You are implementing dynamic row-level security (RLS). You need to create a table filter to meet the following requirements: • Users must see only their own employee data • The DAX expression must work in both Power 81 Desktop and the Power BI service. Which expression should you use? Option A Option B Option C Option D You use Power BI Desktop to import two tables named Customer and Contacts. The Customer table contains the following columns: • Customer_Name • Customer ID • Website The Contacts table contains the following columns: • Contact ID • Contact Email • Contact Name • Customer Name A web-based contact form is used to fill the Contacts table. The data is not sanitized. You need to create a merge for the Customer and Contacts tables. What should you do? Disable fuzzy matching. Enable fuzzy matching. Set Join Kind to Left Outer. Set Join Kind to Full Outer You have a Power Bl report for the marketing department. The report reports on web traffic to a blog and contains data from the following tables. There is a one-to-many relationship from Posts to Traffic that uses the URL and URL Visited columns. The report contains the visuals shown in the following table. The dataset takes a long time to refresh. You need to modify Posts and Traffic queries to reduce toad times. Which two actions will reduce the toad times? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point. Remove the rows in Traffic in which Traffic [Referring URL] does not start with "/" Remove the rows in Posts in which Post [Publish Date] is in the last seven days. Remove Traffic [IP Address], Traffic (Browser Agent], and Traffic [Referring URL). Remove Posts [Full Text] and Posts [Summary]. Remove the rows in Traffic in which Traffic [URL visited] does not contain "blog'' You have a report in Power BI Desktop as shown in the following exhibit. Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. Note: Each correct selection is worth one point. You have a Power BI report that uses a dataset based on an Azure Analysis Services live connection. You need to ensure that users can use Q&A from the Power BI service for the dataset. What should you do? From the Power BI service, add an enterprise gateway to the dataset. From Power BI Desktop, add synonyms and suggested questions. From Power BI Desktop, add a Q&A visual to the report. From the Power Bi service, select Turn on Q& A for this dataset. You have a Microsoft SharePoint Online site that contains several document libraries. One of the document libraries contains manufactunng reports saved as Microsoft Excel files. All the manufacturing reports have the same data structure. You need to use Power Bl Desktop to load only the manufacturing reports to a table for analysis. What should you do? Get data from a SharePoint folder, enter the site URL and then select Combine & Load Get data from a SharePoint list and enter the site URL Select Combine & Transform, then filter by the folder path to the manufacturing reports library. Get data from a SharePoint list enter the site URL and then select Combine & Load Get data from a SharePoint folder and enter the site URL. Select Transform, then filter by the folder path to the manufacturing reports library, You have multiple dashboards. You need to ensure that when users browse the available dashboards from powerbi.com, they can see which dashboards contain Personally Identifiable Information (PII). The solution must minimize configuration effort and impact on the dashboard design. What should you use? comments tiles Microsoft Information Protection sensitivity labels Active Directory groups Microsoft Information Protection sensitivity labels provide a simple way for your users to classify critical content in Power BI without compromising productivity or the ability to collaborate. Sensitivity labels can be applied to datasets, reports, dashboards, and dataflows. You have a semantic model. You need to configure row level security (RLS) to restrict data access for users that have the Viewer permissions. Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to tie answer area and arrange them in the correct order. You attempt to open a PBiX file in Microsoft Power Bl Desktop and receive the following error message in Power Query Editor. DataSource. Error: Could of not find file D:\Data.txt. How should you resolve the issue? Change the file format to CSV. Use an on-premises data gateway. Change the file path of DataM Update the Microsoft OLE OS Provider client libraries on your client computer. 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. You have a query named Customer that imports CSV files from a data lake. The query contains 500 rows as shown in the exhibit. (Click the Exhibit tab.) Each file contains deltas of any new or modified rows from each load to the data lake. Multiple files can have the same customer ID. You need to keep only the last modified row for each customer ID. Which three 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. 1) Duplicate Customer query 2) Group by CustId by Max ModifiedDate (only 2 columns to keep) 3) Merge two queries on CustId and ModifiedDate inner join (to retreive other customer informations related to latest 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. See the answer as below in explanation. Answer as below 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. 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. From Power Query Editor, you profile the data shown in the following exhibit. The IoT GUID and IoT ID columns are unique to each row in query. You need to analyze IoT events by the hour and day of the year. The solution must improve dataset performance. Solution: You split the loT DateTime column into a column named Date and a column named Time. Does this meet the goal? Yes No You have a data model that contains many complex DAX expressions. The expressions contain frequent references to the RELATED and RELATEDTABLE functions. You need to recommend a solution to minimize the use of the RELATED and RELATEDTABLE functions. What should you recommend? Merge tables by using Power Query. Hide unused columns in the model. Split the model into multiple models. Transpose. Combining data means connecting to two or more data sources, shaping them as needed, then consolidating them into a useful query. When you have one or more columns that you’d like to add to another query, you merge the queries. Note: The RELATEDTABLE function is a shortcut for CALCULATETABLE function with no logical expression. CALCULATETABLE evaluates a table expression in a modified filter context and returns A table of values. You have a Fabric workspace that contains the items shown in the following table. You need to make content available to the management department and the accounting department at your company. The solution must meet the following requirements: * The management department must have view access to the Headcount and Department Expenses reports. • The management department must NOT be able to view any other current or future reports. You need to create a Power Bl report. The first page or the report must contain the following two views: * Sales By Postal Code * Sales by Month Both views must display a slicer to select a value for a field named Chain. The Sales By Postal Code view must display a map visual as shown in the following exhibit. You have a table that contains sales data and approximately 1,000 rows. You need to identify outliers in the table. Which type of visualization should you use? area chart donut chart scatter plot pie chart Outliers are those data points that lie outside the overall pattern of distribution & the easiest way to detect outliers is though graphs. Box plots, Scatter plots can help detect them easily. You build a report to analyze customer transactions from a database that contains the tables shown in the following table. You import the tables. Which relationship should you use to link the tables? one-to-many from Customer to Transaction one-to-one between Customer and Transaction one-to-many from Transaction to Customer many-to-many between Customer and Transaction Each customer can have many transactions. For each transaction there is exactly one customer. You plan to use Power Query Editor to get data from an API. The API returns a JSON response. You have a username and password tor the API. Which data source and authentication method should you use to connect to the API? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. 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 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. 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. 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 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 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 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. 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. 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 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 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 configure access for the sales department users. The solution must me meet the security requirements. What should you do? Add the sales department as a member of the reports workspace Add the Azure Active Directory group of the sales department as an Admin of the reports workspace. Distribute an app to the users in the Azure Active Directory group of the sales department. Share each report to the Azure Active Directory group of the sales department. 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. You need to design the data model to meet the report requirements. What should you do in Power BI Desktop? From Power Query, use a DAX expression to add columns to the Orders table to calculate the calendar quarter of the OrderDate column, the calendar month of the OrderDate column, the calendar quarter of the ShippedDate column, and the calendar month of the ShippedDate column. From Power Query, add columns to the Orders table to calculate the calendar quarter and the calendar month of the OrderDate column. From Power Bl Desktop, use the Auto date/time option when creating the reports. From Power Query, add a date table. Create an active relationship to the OrderDate column in the Orders table and an inactive relationship to the ShippedDate column in the Orders table. Use Power Query to calculate calendar quarter and calendar month. Scenario: A single dataset must support all three reports: - The Top Customers report will show the top 20 customers based on the highest sales amounts in a selected order month or quarter, product category, and sales region. - The Top Products report will show the top 20 products based on the highest sales amounts sold in a selected order month or quarter, sales region, and product category. The data model must minimize the size of the dataset as much as possible, while meeting the report requirements and the technical requirements. 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. 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 the On-Time Shipping report. The report must include a visualization that shows the percentage of late orders. Which type of visualization should you create? bar chart scatterplot pie chart Scenario: The On-Time Shipping report will show the following metrics for a selected shipping month or quarter: The percentage of orders that were shipped late by country and shipping region Customers that had multiple late shipments during the last quarter Note: Bar and column charts are some of the most widely used visualization charts in Power BI. They can be used for one or multiple categories. Both these chart types represent data with rectangular bars, where the size of the bar is proportional to the magnitude of data values. The difference between the two is that if the rectangles are stacked horizontally, it is called a bar chart. If the rectangles are vertically aligned, it is called a column chart. You need to create the semantic model. Which storage mode should you use for the tables in the semantic model? live connection Dual Import DirectQuery You need to create the Top Customers report. Which type of filter should you use, and at which level should you apply the filter? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Box 1: Top N Scenario: The Top Customers report will show the top 20 customers based on the highest sales amounts in a selected order month or quarter, product category, and sales region. Once you drag to SKU to Visual level filter you should get Top N option Note: The two most common filter types: automatic and manual. Then there are more advanced filters. Box 2: Visual Once you drag to SKU to Visual level filter you should get Top N option. You need to minimize the size of the semantic model. The solution must meet the report requirements. What should you do? Filter out discontinued products while importing the Products table. Group the Categories table by the CategorylD column. Change the OrderlD column in the Orders table to the Text data type. Remove the QuantityPerUnit column from the Products table. 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 solution to meet the notification requirements of the warehouse shipping department. What should you do? To answer, select the appropriate options in the answer area. NOTE: Each correct select is worth one point: You need to create the dataset. Which dataset mode should you use? DirectQuery Import Live connection Composite Composite Model means now you can have a model, that very large tables of that are coming from the DirectQuery connection, without the need for importing, and small tables to be imported to be accessible quickly. You use Power Query to import two tables named Order Header and Order Details from an Azure SQL database. The Order Header table relates to the Order Details table by using a column named Order ID in each table. You need to combine the tables into a single query that contains the unique columns of each table. What should you select in Power Query Editor? Merge queries Append queries Combine files 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. 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 create a relationship in the data model for RLS. What should you do? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. 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 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 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 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 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 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. 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. TESTED 01 Jul 2025,
[Reference:, https://docs.microsoft.com/en-us/dax/topn-function-dax, , , , ]
Question # 9
A.
B.
C.
D.
Full Access
Answer:
D
Question # 10
A.
B.
C.
D.
Full Access
Answer:
D
Explanation:
Question # 11
A.
B.
C.
D.
Full Access
Answer:
C
Question # 12
A.
B.
C.
D.
Full Access
Answer:
D
Explanation:
[Reference:, https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery, , ]
Question # 13
Full Access
Answer:
Answer:
Explanation:
[Reference:, https://tessellationtech.io/optimizing-power-bi-reports/, , , , , ]
Question # 14
A.
B.
C.
D.
Full Access
Answer:
B
Question # 15
A.
B.
C.
D.
Full Access
Answer:
B
Question # 16
A.
B.
C.
D.
E.
Full Access
Answer:
D, E
Question # 17
Full Access
Answer:
Answer:
Question # 18
A.
B.
C.
D.
Full Access
Answer:
D
Question # 19
A.
B.
C.
D.
Full Access
Answer:
D
Question # 20
A.
B.
C.
D.
Full Access
Answer:
C
Explanation:
[Reference:, https://docs.microsoft.com/en-us/power-bi/admin/service-security-sensitivity-label-overview, , ]
Question # 21
Full Access
Answer:
Answer:
Question # 22
A.
B.
C.
D.
Full Access
Answer:
C
Question # 23
A.
B.
C.
Full Access
Answer:
A
Explanation:
[Reference:, https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-custom-tooltips, , https://technovids.com/power-bi-filters/, , ]
Question # 24
Full Access
Answer:
Answer:
Explanation:
Question # 25
Full Access
Answer:
Answer:
Explanation:
Question # 26
A.
B.
Full Access
Answer:
A
Explanation:
[Reference:, https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-sql-tutorial, ]
Question # 27
A.
B.
Full Access
Answer:
B
Question # 28
A.
B.
C.
D.
Full Access
Answer:
A
Explanation:
[Reference:, https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data, ]
Question # 29
Full Access
Answer:
Answer:
Question # 30
Full Access
Answer:
Answer:
Question # 31
A.
B.
C.
D.
Full Access
Answer:
C
Explanation:
[Reference:, https://towardsdatascience.com/this-article-is-about-identifying-outliers-through-funnel-plots-using-the-microsoft-power-bi-d7ad16ac9ccc, ]
Question # 32
A.
B.
C.
D.
Full Access
Answer:
A
Explanation:
Question # 33
Full Access
Answer:
Answer:
Question # 34
A.
B.
C.
D.
E.
Full Access
Answer:
A, E
Explanation:
Question # 35
A.
B.
C.
D.
Full Access
Answer:
B
Question # 36
A.
B.
C.
D.
Full Access
Answer:
A
Explanation:
[rence:, https://docs.microsoft.com/en-us/dax/datesqtd-function-dax, , ]
Question # 37
Full Access
Answer:
Answer:
Explanation:
Question # 38
Full Access
Answer:
Answer:
Explanation:
[Reference:, https://docs.microsoft.com/en-us/dax/endofquarter-function-dax, , ]
Question # 39
Full Access
Answer:
Answer:
Explanation:
[Reference:, https://docs.microsoft.com/en-us/dax/isfiltered-function-dax, , ]
Question # 40
Full Access
Answer:
Answer:
Explanation:
[Reference:, https://www.nickyvv.com/2019/08/the-new-power-bi-workspace-viewer-role-explained.html, , , ]
Question # 41
A.
B.
C.
D.
Full Access
Answer:
D
Explanation:
Question # 42
Full Access
Answer:
Answer:
Explanation:
Question # 43
A.
B.
C.
D.
Full Access
Answer:
C
Question # 44
A.
B.
C.
D.
Full Access
Answer:
C
Question # 45
A.
B.
C.
D.
Full Access
Answer:
B
Question # 46
Full Access
Answer:
Answer:
Question # 47
A.
B.
C.
D.
Full Access
Answer:
B
Explanation:
Question # 48
Full Access
Answer:
Answer:
Explanation:
,
[Reference:, https://docs.microsoft.com/en-us/dax/calculate-function-dax, , https://docs.microsoft.com/en-us/dax/filter-function-dax, , ]
Question # 49
A.
B.
C.
Full Access
Answer:
A
Explanation:
[Reference:, https://www.pluralsight.com/guides/bar-and-column-charts-in-power-bi, , ]
Question # 50
A.
B.
C.
D.
Full Access
Answer:
C
Question # 51
Full Access
Answer:
Answer:
Explanation:
[Reference:, https://powerbidocs.com/2020/01/21/power-bi-top-n-filters/, , ]
Question # 52
A.
B.
C.
D.
Full Access
Answer:
D
Question # 53
A.
B.
C.
D.
Full Access
Answer:
C
Question # 54
Full Access
Answer:
Answer:
Question # 55
A.
B.
C.
D.
Full Access
Answer:
D
Explanation:
Question # 56
A.
B.
C.
Full Access
Answer:
A
Question # 57
Full Access
Answer:
Answer:
Explanation:
Question # 58
Full Access
Answer:
Answer:
Question # 59
Full Access
Answer:
Answer:
Explanation:
[Reference:, https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-kpi, , , ]
Question # 60
A.
B.
C.
D.
Full Access
Answer:
A
Explanation:
Question # 61
A.
B.
C.
D.
Full Access
Answer:
B
Question # 62
A.
B.
C.
D.
Full Access
Answer:
C
Question # 63
A.
B.
C.
D.
Full Access
Answer:
A
Question # 64
A.
B.
C.
D.
Full Access
Answer:
C
Question # 65
Full Access
Answer:
Answer:
Question # 66
A.
B.
C.
D.
E.
Full Access
Answer:
A
Explanation:
[Reference:, https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand, ]
Quick Links
Unlimited Packages
Site Secure
We Accept
Copyright myexamcollection.com. All Right Reserved.