3 Months Free Update
3 Months Free Update
3 Months Free Update
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 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 have a BI dataset and a connected report.
You need to ensure that users can analyze data in Microsoft Excel by connecting directly to the dataset.
You grant the users the Build permission for dataset
What Should do next?
Change default visual interaction for the report
For the report change the Export data setting to Summarized data, data with current layout and underlying data
For the report, change the Export data setting to None
Certify the dataset used by the report.
You have a table that contains the following three columns:
You need to create a key influencers visualization as shown in the exhibit. (Click the Exhibit tab.)
How should you configure the visualization? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Box 1: Total Sales
Box 2: Occupation
Box 3: City
You can use Expand By to add fields you want to use for setting the level of the analysis without looking for new influencers.
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 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.
User 1 = Member
User 2 = Contributor
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-new-workspaces
You have a Power Bl visual that uses indicators to show values that are out of range as shown in the following exhibit.
see the explanation for the answer.
Answer as selected
You have a Microsoft SharePoint Online site that contains several document libraries. One of the document libraries contains manufacturing reports saved as Microsoft Excel files. All the manufacturing reports have the same data structure.
You need to load only the manufacturing reports to a table for analysis.
What should you do in Microsoft Power Bl Desktop?
Get data from a SharePoint Online folder, enter the site URL, and then select Combine & Load.
Get data from a SharePoint Online list and enter the site URL. Edit the query and filter by the path to the manufacturing reports library.
Get data from a SharePoint Online folder and enter the site URL. Edit the query and filter by the path to the
manufacturing reports library.
Get data from a SharePoint Online list, enter the site URL, and then select Combine & Load.
We have to import Excel files from SharePoint, so we need the connector SharePoint folder which is used to get access to the files stored in the library. SharePoint list is a collection of content that has rows and columns (like a table) and is used for task lists, calendars, etc. Since we have to filter only on manufacturing reports, we have to select Transform and then filter by the corresponding folder path.
https://docs.microsoft.com/en-us/p ower-query/connectors/sharepointlist
You view a query named Transactions as shown in the following exhibit.
The query gets CSV files from a folder.
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.
Box 1: 9
9 distinct CSV files.
Box 2: 10
10 distinct dates.
https://pediaa.com/what-is-the-diff erence-between-unique-and-distinct-in-sql/#:~:text=Unique%20and%20Distinct%20are%20two%20SQL%20constraints.,the%20records%20from%20a%20table.
You have a power BI tenant that hosts the datasets shown in the following table.
You have the following requirements:
• The export of reports that contain Personally Identifiable Information (Pll) must be prevented.
• Data used for financial decisions must be reviewed and approved before use.
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 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 are preparing a financial report in Power BI. You connect to the data stored in a Microsoft Excel spreadsheet by using Power Query Editor as shown in the following exhibit. You need to prepare the data to support the following: 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. 1. Use first row as header 2. Unpivot all columns other than "Measure" 3. Rename "Attribute" to "Year" 4. Change data type of "Year" to date (Date > Year) What should you do to address the existing environment data concerns? a calculated column that uses the following formula: ABS(Sales[sales_amount]) a measure that uses the following formula: SUMX(FILTER('Sales', 'Sales'[sales_amount] > 0)),[sales_amount]) a measure that uses the following formula: SUM(Sales[sales_amount]) a calculated column that uses the following formula: IF(ISBLANK(Sales[sales_amount]),0, (Sales[sales_amount])) You have a CSV file that contains user complaints. The file contains a column named Logged logged contains the date and time each complaint occurred. The data in Logged is m the following format: 2018-12-31 at 08:59. You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy. What should you do? Create a column by example that starts with 2018-12-31. Create a column by example that starts with 2018-12-31 and set the data type of the new column to Date Apply the parse function from the Date transformations options to the Logged column. Add a conditional column that outputs 2018 if the Logged column starts with 2018 and set the data type of the new column to Whole Number. You have a Power Bl workspace that contains a single-page report named Sales. You need to add all the visuals from Sales to a dashboard. The solution must ensure that additional visuals added to the page are added automatically to the dashboard. 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. Open powerbi.com Select sales report Pin the page You have two Power Bl reports named ReportA and ReportB that each uses a distinct color palette. You are creating a Power Bl dashboard that will include two visuals from each report You need to use a consistent dark theme for the dashboard. The solution must preserve the original colors of the reports. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point. Upload a snapshot. Select the dark dashboard theme. Turn on tile flow. When pinning visuals to the dashboard, select Use destination theme. For the browser, set the color preference to dark mode. You have a dashboard that contains tiles pinned from a single report as shown in the Original Dashboard exhibit. (Click the Original Dashboard tab.) You need to modify the dashboard to appear as shown in the Modified Dashboard exhibit. (Click the Modified Dashboard tab.) What should you do? Edit the details of each tile. Change the report theme. Change the dashboard theme. Create a custom CSS file. https://docs.microsoft.com/en-us/power-bi/crea te-reports/service-dashboard-themes#how-dashboard-themes-work You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each compliant occurred. The data in Logged is in the fol-lowing format: 2018-12-31 at 08:59. You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy. What should you do? Create a column by example that starts with 2018-12-31. Apply a transformation to extract the last 11 characters of the Logged column and set the data type of the new column to Date. Apply a transformation to extract the first 11 characters of the Logged column. split the Logged column by using at as the delimiter. According to Microsoft Certified: Power BI Data Analyst Associate1, Power Query Editor is a tool that lets you connect to one or many data sources, shape and transform the data to meet your needs, then load that model into Power BI Desktop2. One of the transformations you can perform in Power Query Editor is extract date from text, which creates a date value from a textual representation3. For example, given a text column like this: Logged 2018-12-31 at 08:59 2019-01-01 at 09:15 You can extract the date part by using the Date.FromText function with a specific format4. The result will be: Logged Date 2018-12-31 at 08:59 2018-12-31 2019-01-01 at 09:15 2019-01-01 This makes it possible to use a built-in date hierarchy for analysis. You open powerbi.com 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. Graphical user interface, text, application, Word, email
Description automatically generated References: https://docs.microsoft.com/en-us/power-bi/service-data-classification 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 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 need to provide a user with the ability to add members to a workspace. The solution must use the principle of least privilege. Which role should you assign to the user? Viewer Contributor Member Admin A Member can add members or others with lower permissions. Note: 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. 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 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 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 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 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 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: - 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. 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 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 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 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 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 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. Graphical user interface
Description automatically generated with low confidence 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 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 have a Power BI workspace named BI Data that contains a dataset named BI Finance. You have the Build permission for the 81 Finance dataset but you do NOT have permissions for the workspace, You need to connect to BI Finance and create a report. Which actions should you perform? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point. From the Power BI service, create a dataflow to the dataset by using DirectQuery. From Power BI Desktop, connect to a Dataverse data source. From the Power BI service, create a new report and select a published dataset From Power Bl Desktop, connect to a shared dataset You create a data model in Power BI. Report developers and users provide feedback that the data model is too complex. The model contains the following tables. The model has the following relationships: *There is a one-to-one relationship between Sales_Region and Region_Manager. *There are more records in Manager than in Region_Manager, but every record in Region_Manager has a corresponding record in Manager. *There are more records in Sales_Manager than in Sales_Region, but every record in Sales_Region has a corresponding record in Sales_Manager. You need to denormalize the model into a single table. Only managers who are associated to a sales region must be included in the reports. 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. NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select. 1.Merge [Region_Manager] and [Manager] by using an inner join. 3.Merge [Sales_Region] and [Sales_Manager] by using an inner join. 6.Merge [Sales_Region] and [Region_Manager] by using an inner join. 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 report that imports a date table and a sales table from an Azure SQL database data source. The sales table has the following date foreign keys: • Due Date • Order Date • Delivery Date You need to support the analysis of sales over time based on all three dates at the same time. Solution; You create measures that use the uSEREIATIOHSHIP DAX function to filter sales on the inactive relationships between the sales table and the date table. Does this meet the goal? Yes No In Power Query Editor, you have three queries named ProductCategory, ProductSubCategory, and Product. Every Product has a ProductSubCategory. Not every ProductsubCategory has a parent ProductCategory. You need to merge the three queries into a single query. The solution must ensure the best performance in Power Query. How should you merge the tables? To answer, drag the appropriate merge types to the correct queries. Each merge type 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 have a Power Bl workspace named Workspace1 that contains a dataset named DS1 and a report named RPT1. A user wants to create a report by using the data In DS1 and publish the report to another workspace. You need to provide the user with the appropriate access. The solution must minimize the number of access permissions granted to the user. What should you do? Share RPT1 with the user. Add the user as a Viewer of Workspace1. Add the user as a member of Workspace1. Grant the Build permission for DS1 to the user. Microsoft says: To copy a report to another workspace, and to create a report in another workspace based on a dataset in the current workspace, you need Build permission for the dataset. For datasets in the original workspace, if you have at least the Contributor role, you automatically have Build permission through your workspace role. https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-roles-new-workspaces You have a report that contains a bar chart and a column chart. The bar chart shows customer count by customer segment. The column chart shows sales by month. You need to ensure that when a segment is selected in the bar chart, you see which portion of the total sales for the month belongs to the customer segment. How should the visual interactions be set on the column chart when the bar chart is selected? no impact highlight filter HIGHLIGHT as the question required us to "you see which portion of the total sales for the month belongs to the customer segment" -- in order to see WHICH portion, you need to still see the whole visual, highlight is most appropriate. If the requirement stated to ONLY SEE THE PORTION IT RELATES TO then filter would be appropriate. 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 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. TESTED 29 Mar 2024,
Answer:
Explanation:
Answer:
Answer:
Answer:
Explanation:
Answer:
Answer:
Explanation:
Answer:
Explanation:
Answer:
Explanation:
Answer:
Explanation:
Answer:
Explanation:
Answer:
Explanation:
Answer:
Explanation:
Answer:
Explanation:
Answer:
Answer:
Explanation:
Answer:
Explanation:
Answer:
Answer:
Explanation:
Answer:
Explanation:
Answer:
Answer:
Explanation:
Answer:
Explanation:
Answer:
Answer:
Explanation:
,
Answer:
Explanation:
Answer:
Answer:
Answer:
Explanation:
Answer:
Answer:
Explanation:
Answer:
Explanation:
Answer:
Explanation:
Answer:
Explanation:
Answer:
Explanation:
Answer:
Explanation:
QUICK LINKS
SUPPORT
PAYMENT METHOD
Site Secure