Your organization is designing a Power BI semantic model to analyze sales performance. The model includes a 'Sales' fact table and dimension tables: 'Product', 'Customer', and 'Date'.
You need to establish relationships between these tables for accurate data filtering and aggregation.
Each correct answer presents part of the solution. Which two actions should you perform?
Select all answers that apply.
Define one-to-many relationships from dimension tables to the fact table.
Enable bi-directional cross-filtering.
Set single-direction cross-filtering.
Use many-to-many relationships between the fact table and dimension tables.
You need to create a new hierarchy in Power BI Desktop.
What should you do first?
You plan to use the calculated table functionality to add a duplicate table in Power BI Desktop.
Which characteristics of the original table will be duplicated?
You create a data model in Power BI Desktop that contains DAX calculated columns and measures. You now need to create a report.
In which two places can a DAX calculated column be used, but a DAX calculated measure cannot be used? Each correct answer presents a complete solution.
You need to develop a quick measure in Power BI Desktop.
Which two elements can you use? Each correct answer presents a complete solution.
In Power BI Desktop, you need to create a measure.
Which two interfaces can you use? Each correct answer presents a complete the solution.
You are creating a report in a Power BI Desktop by using a semantic model that contains sales data.
You need to create a measure that always provides the value of total sales for the year 2022, regardless of which year is selected in any visual in the same report.
Which DAX function should you use in combination with the SUM function to override the context and provide the result?
You have a Power BI Desktop semantic model that includes a table named Salesperson. The table includes a column named UPN. UPN contains the user principal name of the salesperson’s Microsoft Entra ID account.
You need to ensure that each salesperson will only be able to see the rows in the Salesperson table where the UPN column value matches their User Principal Name.
Which two actions should you perform? Each correct answer presents part of the solution.
You have a Power BI Desktop semantic model based on a star schema data source.
You need to use Data Analysis Expression (DAX) to create a date table in the dataset and populate the table with a range of dates based on the earliest and latest date within the semantic model.
Which function should you use?
You need to reduce the cardinality of a column in a Power BI semantic model.
What should you do?
Sie erstellen ein Power BI-Dashboard.
Sie müssen ein benutzerdefiniertes Design aus einem anderen Power BI-Dashboarddesign auf das Dashboard anwenden.
Welche Art von Datei sollten Sie konfigurieren?
You plan to get data from flat files for a Power BI semantic model.
You need to select a location to store the files.
Which location requires an on-premises data gateway?
You plan to add data to Power BI Desktop from a new data source. You are evaluating whether you should use the DirectQuery storage mode or the Import storage mode.
What are two benefits of using Import instead of DirectQuery? Each correct answer presents a complete solution.
You have multiple Excel files stored in a folder synced with OneDrive for Business.
You need to import data from the files. The solution must NOT use a data gateway.
Which type of connector should you use?
You plan to publish a semantic model from Power BI Desktop.
You need to ensure that your data source server name can be changed after the semantic model has been published to the Power BI Service.
You have created a Power BI semantic model and need to create multiple reports.
What is a benefit of using a Power BI semantic model as a data source for multiple reports compared to each report having a separate semantic model?
From Power BI Desktop, you create a data source by importing an Excel file that contains 10,000 rows.
You plan to identify data anomalies within the data source.
You need to ensure that column distribution considers all rows in the Excel file.
You have a query that retrieves data from a table that contains more than 8,000 rows of data.
In Power Query Editor, you notice that the column statistics for each column shows a count of exactly 1,000.
You need to ensure that the column statistics for each column shows the statistics based on all rows that are returned by the query.
You are analyzing query data by using Power Query Editor.
You need to ensure that the Column statistics are based on an analysis of the entire dataset.
Your organization is using Microsoft Power BI to analyze sales data, which contains null values in the 'Sales Amount' column and text entries in numeric fields.
You need to clean the data to resolve these inconsistencies.
Which two actions should you take? Each answer is part of the solution.
You have an Excel spreadsheet that contains three columns labeled Year, 2021, and 2012. The entries in rows for the first column consists of names of the individual months in the year while the other two columns contain the sales amount for each month for the corresponding year.
You import data from the Excel spreadsheet into Power BI Desktop.
You need to transform the data so it will consist of three columns, with the first one containing month, the second containing year, and the third containing the sales amount for that month and year.
Which transformation should you use first?
You have a query that has a column named Country and columns for each month of sales data. The names of the sales data columns use a format of Month Year, for example January 2022. The month columns contain the Sales Amount values for each month.
You need to reshape the table to have all sales amount values in a single column.
A new column should also be added and contain the relevant month year for each row of data.
What should you do from the Power Query Editor?
You have a table that contains a column named ProductID.
The ProductID column contains values that have a prefix of PD followed by five numbers. For example: PD15332.
You plan to convert the ProductID values to numbers (integer).
You need to remove the leading two letters from the current ProductID values.
Which two commands can you use? Each correct answer presents a complete solution.
You have a Power BI data source that contains the following tables:
ProductCategory: Lists the product category ID and category name
ProductSubcategory: Lists the product subcategory ID, subcategory name, and the related category ID
ProductList: Lists the product ID, name, and subcategory ID
You need to optimize the data to create a dimension for use in a star schema data model.
How should the tables be transformed before loading into the model?
From Power BI Desktop, you create a data source by importing a Cosmos DB for NoSQL item collection.
You connect to the Cosmos DB account, database, and collection, but the preview displays only a list of items named Record.
You need to select individual fields from items in the collection that you want to load into Power BI Desktop.
You have begun the process of creating a Power BI Semantic model by connecting to a data source based on multiple tables in a SQL Server database.
You need to modify the relationship between the tables.
Which interface should you use in the Power BI Desktop?
You are designing a data model in Power BI.
You need to avoid introducing ambiguity into your data model design.
Which type of cardinality should you avoid?
You have a fact table that contains sales data and the following two date columns:
OrderDate
ShipDate
Both columns have a relationship to the Date column in the Calendar table, and DAX measures have been configured to use these relationships for calculations related to order or ship dates.
You need to ensure that by default, the Calendar table does NOT filter the fact table, unless it is using a DAX measure that uses these relationships.
Select only one answer.
Disable Make this relationship active for both relationships.
Enable Apply security filter in both directions for both relationships.
Enable Make this relationship active for both relationships.
Set the cross-filter direction to both for each relationship.
You need to use DAX quick measures to generate results to use in a report.
Which type of DAX quick measure calculations will NOT work against a DirectQuery table?
In Power BI Desktop, you plan to use M-language to define a common date table spanning a period of 10 years.
You need identify the M language function that would allow you to specify that rows in the table should represent consecutive days within the date range you designated. Your solution must minimize administrative effort.
Which syntax should you use?
You need to reduce the size of a Power BI semantic model that contains two dimension tables named Date and Location, and one fact table named Temperatures. The Temperatures table contains the following fields:
Reading Time (datetime)
DateKey (date)
LocationKey (whole number)
Temp C (decimal)
You have one row for every 5-minute interval for each location. The Temperatures table is related to the Date and Location dimensions by using many-to-one relationships.
You need to reduce the cardinality of the table. The solution must ensure that the semantic model supports reports that analyze average temperature by hour and location.
What two actions should you perform? Each correct answer presents part of the solution.
You plan to run Power BI Desktop Performance Analyzer.
You need to ensure that the data engine cache will NOT impact the test results without restarting Power BI Desktop.
You are designing a data model for Power BI Desktop.
You need to reduce the model size.
Which technique should you use to reduce the model size?
Which data role enables advanced analytics capabilities specifically through reports and visualizations?
Which data analyst task has a critical performance impact on reporting and data analysis?
Which one of the following options is the most important key benefit of data analysis?
Which of the following are building blocks of Power BI?
What is a collection of reports and dashboards called in Power BI?
What is the common flow of activity in Power BI?
What is a key benefit of using Microsoft Fabric in data projects?
What is the default storage format for Fabric's OneLake?
Which Fabric experience is used to move and transform data?
What is the role of Power Query in the preparation of a semantic model for Power BI report?
What is the purpose of creating relationships between tables in Power BI?
What is the primary function of Power BI Desktop in report development?
What is the purpose of the Narrative visual in Power BI?
Frage 2
You have a project management app that is fully hosted in Microsoft Teams. The app was developed by using Microsoft Power Apps. You need to create a Power BI report that connects to the project management app. Which connector should you select?
Question: 3 For the sales department at your company, you publish a Power BI report that imports data from a Microsoft Excel file located in a Microsoft SharePoint folder. The data model contains several measures. You need to create a Power BI report from the existing data. The solution must minimize development effort. Which type of data source should you use?
Question: 4 You import two Microsoft Excel tables named Customer and Address into Power Query. Customer contains the following columns:
✑ Customer ID
✑ Customer Name
✑ Phone
✑ Email Address
✑ Address ID
Address contains the following columns:
✑ Address Line 1
✑ Address Line 2
✑ City
✑ State/Region
✑ Country
✑ Postal Code
Each Customer ID represents a unique customer in the Customer table. Each Address ID represents a unique address in the Address table. You need to create a query that has one row per customer. Each row must contain City, State/Region, and Country for each customer. What should you do?
What cardinality type should you set to create a relationship between a dimension table to a fact table?
Which statement about hierarchies is true?
What type of object can you add to a model to summarize data?
You're using Power BI Desktop to develop a model. It has a table named Sales, which includes a column named CustomerKey. In reports, you need a calculation to show the number of different customers who have placed orders. What type of DAX calculation do you add to the model?
You're using Power BI Desktop to develop a model. It has a table named Customer, which includes a column named DateOfBirth. In reports, you need to group customers by current age. What type of DAX calculation should you add to the Customer table?
You're using Power BI Desktop to develop a model. It has a table named Geography, which has two relationships to the Sales table. One relationship filters by customer region and the other filters by sales region. You need to create a role-playing dimension so that both filters are possible. What type of DAX calculation do you add to the model?
You write a DAX formula that adds BLANK to the number 20. What is the result?
Which statement about calculated tables is true?
Which statement about calculated columns is true?
Which statement about measures is correct?
Which type of model object is evaluated within a filter context?
Which one of the following DAX functions allows you to use an inactive relationship when evaluating a measure expression?
Which one of the following statements about the CALCULATE function is true?
In the context of semantic model calculations, which statement best describes time intelligence?
You're developing a semantic model in Power BI Desktop. You've just added a date table by using the CALENDARAUTO function. You've extended it with calculated columns, and you've related it to other model tables. What else should you do to ensure that DAX time intelligence calculations work correctly?
You have a table that stores account balance snapshots for each date, excluding weekends. You need to ensure that your measure formula only filters by a single date. Also, if no record is on the last date of a time period, it should use the latest account balance. Which DAX time intelligence function should you use?
Which DAX function can't be used in a visual calculation?
What does the Axis parameter of visual calculation functions do?
A data analyst is working on a visual calculation in Power BI. They want to compare the current value of a metric to its preceding value. Which template should they use?
A data analyst is working on a visual calculation and wants to ensure the calculation traverses the visual matrix row by row from top to bottom, then column by column from left to right. Which Axis parameter value should the analyst use?
What benefit do you get from analyzing the metadata?
What can be achieved by removing unnecessary rows and columns?
Which of the following statements about relationships in Power BI Desktop is true?
At the Contoso Skateboard Company, Sally is responsible for managing staff rosters to determine when the inventory employees are required to work. Sally relies on a report that forecasts sales order demand to determine the number of employees that are required at any time. It also includes a button to open a Human Resources app to assign employees to rosters. What type of report audience does Sally represent?
At the Contoso Skateboard Company, Sally is responsible for managing staff rosters to determine when the inventory employees are required to work. Sally relies on a report that forecasts sales order demand to determine the number of employees that are required at any time. It also includes a button to open a Human Resources app to assign employees to rosters. What type of report does Sally use?
Which user interface requirement is an example of an accessibility requirement?
At the Contoso Skateboard Company, Brandon is designing a dashboard report to show inventory stock levels over time. What type of report visual should Brandon choose to effectively show the stock levels?
At the Contoso Skateboard Company, Sakura is designing an analytical report. It must include a visual that allows report consumers to explore and discover detailed sales values over time and by store. What type of report visual should Sakura choose to support the report consumer requirement?
At the Contoso Skateboard Company, James is designing a dashboard report. It must prominently show values of sales revenue, units sold, cost of goods sold, and profit, and each value should be compared to a target value. What type of report visual should James choose to support the report consumer requirement?
Which of the following capabilities is unique to the Filters pane?
Which of the following capabilities is unique to slicers?
At the Contoso Skateboard Company, Sally is creating a report to show sales over time. Sally knows occasional spikes occur in sales revenue that could be attributed to many different reasons, such as a marketing campaign. Sally needs to ensure that supporting visuals provide explanation for the spikes. What type of visual should Sally use?
At the Contoso Skateboard Company, Ash is authoring a report that will be distributed to sales managers. The report contains some sensitive data that shouldn’t be exported. Which report design feature can Ash configure to ensure that data isn’t exported?
What is the purpose of the Display state in bookmarks?
What Power BI feature can give an in-depth analysis of the distribution of data?
How can you access the time series chart visual?
What visual should be used to display outliers?
Which of the following statements about Power BI workspaces is correct?
Which of the following statements about Power BI Apps is correct?
Which one of the following options is the best description of a workspace?
Where are semantic model-scheduled refreshes configured?
What reserved parameters configure the start and end of where Incremental refresh should occur?
What is the difference between Promotion and Certification when you're endorsing a semantic model?
What is the primary purpose of applying sensitivity labels in Power BI?
Which of the following is a key advantage of using Power BI Apps?
What is a key difference between the Viewer and Contributor roles in a Power BI workspace?
What is one way that reports and dashboards differ?
Where can you configure and set data alerts?
What is a dashboard?
Which function will tell you the username of the person who is signed in to Power BI service?
Where can you test RLS by using different security roles?
Rupali is a data modeler at Adventure Works who is developing an import model to analyze employee timesheet data. The employee table stores the employee social security number (SSN) in a column. While the model will be available for all company managers, it will also be available to employees in the Payroll department. However, reports must only reveal employee SSNs to payroll employees. What feature should Rupali use to restrict access to the SSN column?
What is a risk of having null values in a numeric column?
If you have two queries that have different data but the same column headers, and you want to combine both tables into one query with all the combined rows, which operation should you perform?
Which of the following selections aren't best practices for naming conventions in Power BI?
When connecting to a SQL Server database to get data, what language should you use to extract data?
You're creating a Power BI report with data from an Azure Analysis Services MDX Cube. When the data refreshes in the cube, you would like to see it immediately in the Power BI report. How should you connect?
What can you do to improve performance when you're getting data in Power BI?
Geoffrey is a data modeler at Adventure Works who developed a DirectQuery model that connects to the data warehouse. To improve the query performance of higher-grain sales queries, Geoffrey added an import aggregation table. What else should Geoffrey do to improve query performance of the higher-grain queries?
Breana is a data modeler at Adventure Works who developed a manufacturing model, which is an import model. Breana needs to ensure that manufacturing reports deliver real-time results. Which type of table should Breana create?
Mousef is a business analyst at Adventure Works who wants to create a new model by extending the sales dataset, which is delivered by IT. Mousef wants to add a new table of census population data sourced from a web page. Which model framework should Mousef use?
Last changed2 days ago