Study questions Flashcards
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?
Set related dimension tables to dual storage mode
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?
Hybrid table
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?
Composite
Model frameworks:
Import, DirectQuery, composite
Define Hybrid Table
Power BI adds a DirectQuery partition for the current period
T/F You can covert a DirectQuery table to an import table.
TRUE
T/F You can covert an import table to a DirectQuery table.
FALSE
In a Power BI Desktop model design, which type of object do you create to enforce row-level security?
Role
Which of the following statements is correct regarding a star schema design?
Fact table store accumulations of business events
In what order does an analytic query implement its phases?
Filter, Group, Summarize
A good data model offers the following benefits:
Data exploration is faster.Aggregations are simpler to build.Reports are more accurate.Writing reports takes less time.Reports are easier to maintain in the future.
What does data granularity mean?
Data granularity indicates the level the detail within the data, so the higher the granularity, the more detail that is represented in the data.
What is the difference between a fact table and a dimension table?
Fact tables contain observational data while dimension tables contain information about specific entities within the data.
Choose the best answer to explain relationship cardinality?
Cardinality is the measure of unique values in a table.
What is a fully qualified column?
A column that has been identified with both the column and table name.
When should you use the DIVIDE function?
When the denominator is an expression that could return zero or BLANK.
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 will you add to the model?
Measure
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 will you add to the Customer table?
Calculated Column
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 will you add to the model?
Calculated table
You write a DAX formula that adds BLANK to the number 20. What will be the result?
20
Which statement about measures is correct?
Measures can reference other measures directly
Which DAX function can summarize a table?
Countrows
Which of the following statements describing similarity of measures and calculated columns in an Import model is true?
They can achieve summarization of model data
Which statement about calculated tables is true?
Calculated tables store data inside the model, and adding them results in a larger model size.
Which statement about calculated columns is true?
Calculated column formulas are evaluated by using row context.
You’re developing a Power BI desktop model that sources data from an Excel workbook. The workbook has an employee table that stores one row for each employee. Each row has a reference to the employee’s manager, which is also a row in the employee table. You need to add several columns to the Employee table in your model to analyze payroll data within the organization hierarchy (like, executive level, manager level, and so on). Which technique will you use to add the columns?
Add calculated
Admin
Update & Delete the workspace, Add or remove people, including other admins
Member
Add members or others with lower persmissions, Publish, unpublish, and change permsissions for an app
Contributor
Create, edit, and delete content, such as reports, in the workspace, Publish reports to the workspace
Viewere
View and interact with an item, Read data that?s stored in workspace dataflows
In the context of data model calculations, which statement best describes time intelligence?
Filter context modifications involving a date table
You’re developing a data 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?
Mark as a Date table
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?
Lastonblank
What benefit do you get from analyzing the metadata?
The benefit of analyzing the metadata is that you can clearly identify data inconstincies with your dataset
What can be achieved by removing unnecessary rows and columns?
Deleting unnecessary rows and columns will reduce a dataset size and it’s good practice to load only necessary data into your data model.
Which of the following statements about relationships in Power BI Desktop is true?
Relationships can be created between tables that contain different types of data.
You plan to publish a dataset from Power BI Desktop.You need to ensure that a server name can be changed after the dataset has been published to the Power BI Service.Which two actions should you perform? Each correct answer presents part of the solution.
Create a parameter, From the Data source settings, update the server source as a parameter
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.What should you do first?
Open Power Query Editor
You need to create DAX calculated columns and measures in Power BI Desktop.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.
as an item in the Fields well of a slicer, as a filter in the “Filters on this page” wsell of the Filters pane
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.What should you do first?
Connect DAX Studio to the data model
You manage a Power BI workspace.You need to delegate the task to update workspace metadata. The solution must use the principle of least privilege.Which role should you use?
Admin
You are editing a report in Power BI Desktop.You need to adjust the behavior of the report by editing interactions.Which two types of interaction behavior can you change between visuals? Each correct answer presents a complete solution.
Filter, Highlight
In Power BI Desktop, you need to create a measure.Which two interfaces can you use? Each correct answer presents a complete the solution.
Data view, Report View
You need to create a bookmark that toggles the visibility of a visual.This bookmark must only toggle the visibility state and perform no other action.Which three configurations should you make? Each correct answer presents part of the solution.
Disable the Data option, Endable the Display Option, Disable the current page option
You have a bar chart and column chart visual on a report page. Selecting any column from the bar chart visual filters the column chart data to less than 1% of its unfiltered value.Which type of visual interaction should be used when the bar chart is filtering the column chart to ensure that you can easily see the data?
filter
You manage a Power BI workspace in shared capacity. The workspace contains a report that uses a dataset named DS1.You need to implement an incremental refresh of DS1.What should you do first?
In Power BI Desktop, define filter parameters
You manage a Power BI workspace in a shared capacity. The workspace contains a dataset named DS1. You plan to schedule a refresh of DS1.What is the number of consecutive refresh failures of DS1 that will automatically disable the refresh schedule?
4
You have a fact table that contains sales data.The fact table includes a SalesDate column formatted as a Date data type. Auto date/time setting is disabled in both global and current file options.You load the fact table into Power BI Desktop.You need to ensure that you are able to analyze data on a yearly, quarterly, monthly, weekly, and daily basis. Your solution must minimize the model size and administrative effort.What should you do?
Add a separate date dimension table
You need to add a new visual to a Power BI Dashboard. This visual does NOT exist on a report in the workspace. What should you do first?
Select Ask a question about your data.
You need to create a histogram that will display ranges of integers in groups.Which two resources do you need to create the histogram? Each correct answer presents part of the solution.
a Numerical column, a Bin group type
Which native AI visual helps explain correlations for a metric within the dataset?
Key influencers visual
You plan to certify a Power BI dataset.You need to identify at which level within your organization the permissions to certify a dataset are assigned.Which level should you identify?
Tenant
Joshua is a data modeler at Adventure Works who is developing a model for a large data warehouse. The model must enforce RLS, and the Power BI reports that connect to the model should deliver the fastest possible performance. What should Joshua do?
Apply rules to dimension tables
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?
(OLS) Object Level Security
Kasper is a data modeler at Adventure Works who is developing a model that must enforce RLS. It must restrict access to only the sales regions assigned to the report consumer. The source database includes a table that stores employee usernames and their assigned region(s). What should Kasper do?
Create an RLS role and use a dynamic rule
Stephanie is an enterprise data analyst, working as a resource to data analysts sitting in the finance department. One of the finance analysts asked Stephanie to help troubleshoot why report visuals take 5 seconds to render after a slicer selection is made. What tool should Stephanie use first to begin troubleshooting?
Performance analyzer
James has been asked to troubleshoot a report that contains a matrix visual that renders visibly slower than any other visuals on the page. After James runs the Performance analyzer, he notices the need to dig further into the DAX query for the matrix using DAX Studio to understand what’s causing the trouble. That same query is running in less than a second in DAX Studio. Has James solved the problem?
No. James needs to clear the model cache to ensure that query results aren’t cached in the model
Mary-Jo is responsible for managing the maintenance and deployment of Power BI assets for the entire organization. What tool can Mary-Jo use to ensure all data models adhere to data modeling best practices?
Best Practice Analyzer in Tabular Editor
Margaret is a data modeler at Adventure Works who is adding a measure to sales model. When evaluated, the measure must filter by filters already applied to an unrelated table.
Treatas
Which of the following capabilities is unique to the Filters pane?
Top N Filtering
Which of the following capabilities is unique to slicers?
Horizontal Orientation
Which native AI visual helps explain correlations for a metric within the dataset?
Key influencers visual
You plan to get data for a Power BI dataset from flat files.You need a location type to store the files. The data must NOT automatically synchronize between the original file and the dataset.Which location type should you recommend?
Local File
In Power BI Desktop, you need to create a role.Which two interfaces can you use? Each correct answer presents a complete solution.
Model View, Report View
You need to create DAX calculated columns and measures in Power BI Desktop.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.
as an item in the Fields well of a slicer, as a filter in the “Filters on this page” wsell of the Filters pane
You manage a Power BI workspace in shared capacity. The workspace contains a report that uses a dataset named DS1.You need to implement an incremental refresh of DS1.What should you do first?
In Power BI Desktop, define filter parameters
You manage a Power BI workspace.You need to delegate the task to schedule data refreshes. The solution must use the principle of least privilege.Which role should you use?
Contributor