<< Prev Question Next Question >>

Question 78/156

A business intelligence (Bl) developer creates a dataflow in Power Bl that uses DirectQuery to access tables from an on premises Microsoft SQL server. The Enhanced Dataflows Compute Engine is turned on for the dataflow.
You need to use the dataflow in a report. The solution must meet the following requirements:
* Minimize online processing operations.
* Minimize calculation times and render times for visuals.
* include data from the current year, up to and including the previous day.
What should you do?

LEAVE A REPLY

Your email address will not be published. Required fields are marked *

Question List (156q)
1 commentQuestion 1: You are building a Power Bl report. Users will view the repo...
Question 2: You have a query that returns the data shown in the followin...
Question 3: You have a table that contains a column named Phone. The fol...
Question 4: You have a Power Bl report You have a table named Dalai that...
Question 5: You need to grant access to the business unit analysts. What...
Question 6: You are creating a visual to show the ranking of product cat...
Question 7: Once the profit and loss dataset is created, which four acti...
Question 8: Note: This question is a part of a series of questions that ...
Question 9: You create a dataset sourced from dozens of flat files in Az...
Question 10: You have a dataset that has the permissions shown in the fol...
Question 11: What is the minimum number of datasets and storage modes req...
Question 12: You have two Power Bl reports named ReportA and ReportB that...
Question 13: You have a Microsoft Power Bl report. The size of PBIX file ...
Question 14: You have sales data in a star schema that contains four tabl...
Question 15: You create a data model in Power BI. Report developers and u...
Question 16: You have a Power Bi report that contains five bookmarks. You...
Question 17: You need to create a Power Bl report. The first page or the ...
Question 18: Note: This question is part of a series of questions that pr...
Question 19: You have the Azure SQL databases shown in the following tabl...
Question 20: You have a Power BI report that contains a page. The page co...
Question 21: You have a Power Bl report named Orders that supports the fo...
Question 22: In Power Query Editor, you have three queries named ProductC...
Question 23: The table has the following columns. (Exhibit) You need to a...
Question 24: You have a Power BI model that contains a table named Sales ...
Question 25: You have a Power Bl table named Customer that contains a fie...
Question 26: You have a Microsoft Power BI data model that contains three...
Question 27: You have the Power BI data model shown in the following exhi...
Question 28: You have a Power Bi model mat contains a table named Date. T...
Question 29: You have a Power Bl workspace that contains a dataset. a rep...
Question 30: You have a Microsoft Power Bl report. The size of PBIX file ...
Question 31: You have a Rawer Bl report That imports a dace table and a s...
Question 32: Note: This question is part of a series of questions that pr...
Question 33: You are creating a Microsoft Power BI data model that has th...
Question 34: How should you distribute the reports to the board? To answe...
Question 35: You have a Power BI report named Report' and a dashboard nam...
Question 36: You have a Power BI report that contains four pages. All the...
Question 37: You have a sales system that contains the tables shown in th...
Question 38: Note: This question is part of a series of questions that us...
Question 39: You need to address the data concerns before creating the da...
Question 40: Note: This question is part of a series of questions that pr...
Question 41: You have a dataset that is used infrequently and refreshes e...
Question 42: You need to create a visual that compares profit across 10 p...
Question 43: You have the tables shown in the following table. (Exhibit) ...
Question 44: You need to provide a user with the ability to add members t...
Question 45: You have a data model that contains many complex DAX express...
Question 46: You have a Power Bi report. The report contains a visual tha...
Question 47: You have a CSV file that contains user complaints. The file ...
Question 48: You build a report to help the sales team understand its per...
Question 49: You are developing a sales report that will have multiple pa...
Question 50: You are creating a Power BI model that contains a table name...
1 commentQuestion 51: You have the dataset shown in the following exhibit. (Exhibi...
Question 52: You have a Power BI app named App1. The privacy for the App1...
Question 53: You have a Power B1 model that contains a table named Date. ...
Question 54: You have two tables named Customers and Invoice in a Power B...
Question 55: You have a Power BI dashboard that displays different visual...
Question 56: You need to get data from the Microsoft SQL Server tables. W...
Question 57: You have a report page that contains the visuals shown in th...
Question 58: Which DAX expression should you use to get the ending balanc...
Question 59: You have a prospective customer list that contains 1,500 row...
Question 60: You have the visual shown in the exhibit. (Click the Exhibit...
Question 61: You have an on-premises Power BI Report Server. You plan to ...
Question 62: You have a Microsoft Excel workbook that contains two tables...
Question 63: You have a CSV file that contains user complaints. The file ...
Question 64: You publish a report to a workspace named Customer Services....
Question 65: From Power Query Editor, you attempt to execute a query and ...
Question 66: You have a Power Bl report that contains five pages. Pages 1...
Question 67: You are creating a sales report in Power Bl for the NorthWes...
Question 68: You have a Power 31 data model that contains a table named S...
Question 69: You are modifying a Power Bi model by using Power Bl Desktop...
Question 70: You maintain a Power Bl workspace that contains a supplier q...
Question 71: You have the following table named Location. (Exhibit) The G...
Question 72: You have an API that returns more than 100 columns. The foll...
Question 73: You have a Power Bl report that uses row-level security (RLS...
Question 74: Note: This question is part of a series of questions that pr...
Question 75: Note: This question is part of a series of questions that pr...
Question 76: You need to design the data model to meet the report require...
Question 77: You are building a Power Bl report that uses data from an Az...
Question 78: A business intelligence (Bl) developer creates a dataflow in...
Question 79: Note: This question is part of a series of questions that pr...
Question 80: You need to create a relationship between the Weekly_Returns...
Question 81: In Power BI Desktop, you have a dataset that contains a tabl...
Question 82: You need to ensure that the data is updated to meet the repo...
Question 83: You need to create the Top Customers report. Which type of f...
Question 84: You have a dashboard that contains tiles pinned from a singl...
Question 85: Note: This question is part of a series of questions that pr...
Question 86: You have four sales regions. Each region has multiple sales ...
Question 87: You have a Power Bl report named Report1 and a dashboard nam...
Question 88: You have a Microsoft Power Bl dashboard. You need to ensure ...
Question 89: You merge data from Sales.Region, Region_Manager, Sales_Mana...
Question 90: Note: This question is a part of a series of questions that ...
Question 91: You create the following step by using Power Query Editor. =...
Question 92: Note: This question is part of a series of questions that pr...
Question 93: You have a table that contains the following three columns: ...
Question 94: You have two Azure SQL databases that contain the same table...
Question 95: You have a Power Bl report that contains three pages. The pa...
Question 96: You have a Power Bl visual that uses indicators to show valu...
Question 97: You have a Microsoft Excel workbook that contains two sheets...
Question 98: You have a report that contains a donut chart and a clustere...
Question 99: Note: This question is part of a series of questions that pr...
Question 100: You have the Power Bl data model shown in the following exhi...
Question 101: You need to create a visual as shown in the following exhibi...
Question 102: You are using the key influencers visual to identify which f...
Question 103: You have a Power Bl workspace that contains a single-page re...
Question 104: Note: This question is part of a series of questions that pr...
Question 105: Note: This question is part of a series of questions that pr...
Question 106: In Power BI Desktop, you are building a sales report that co...
Question 107: You are building a data model for a Power Bl report. You hav...
Question 108: In Power BI Desktop, you are creating a report that will con...
Question 109: You plan to create a Power Bl dataset to analyze attendance ...
Question 110: Note: This question is part of a series of questions that pr...
Question 111: You have a Microsoft Excel spreadsheet that contains the dat...
Question 112: You plan to develop a Power BI report that has a bar chart t...
Question 113: You have a PBiX file that imports several tables from an Azu...
Question 114: You have a Power BI data model that contains a table named E...
Question 115: You build a Power Bl report that displays 10T temperature da...
Question 116: You need to design the data model to meet the report require...
Question 117: You need to create a calculated column to display the month ...
Question 118: You have a line chart that shows the number of employees in ...
Question 119: You have a Power BI workspace named BI Data that contains a ...
Question 120: Note: This question is a part of a series of questions that ...
Question 121: You need to create a solution to meet the notification requi...
Question 122: You are building a dataset from a JSON file that contains an...
Question 123: You have a Power BI report that contains the table visual sh...
Question 124: Note: This question is part of a series of questions that pr...
Question 125: You have a table that contains sales data and approximately ...
Question 126: You have a dataset named Pens that contains the following co...
Question 127: You need to create a visual that enables the adhoc explorati...
Question 128: You have a Power Bi report for the procurement department. T...
Question 129: You have a Power Bl report for the marketing department. The...
Question 130: You need to create a Power BI theme that will be used in mul...
Question 131: You have a column named UnitslnStock as shown in the followi...
Question 132: Note: This question is part of a series of questions that pr...
Question 133: You use Power Bi Desktop to create a Power Bl data model and...
Question 134: You are building a Power BI report to analyze customer segme...
Question 135: Note: This question is part of a series of questions that pr...
Question 136: You need to create a visualization to meet the reporting req...
Question 137: What is the minimum number of Power BI datasets needed to su...
Question 138: You need to create a DAX measure in the data model that only...
Question 139: You are preparing a financial report in Power BI. You connec...
Question 140: You are profiling data by using Power Query Editor. The Addr...
Question 141: You are configuring a Microsoft Power Bl data model to enabl...
Question 142: You are using Power Bi Desktop to connect to an Azure SQL da...
Question 143: You are creating a Microsoft Power Bl model that has two tab...
Question 144: Note: This question is part of a series of questions that pr...
Question 145: You have the Power Bl data model shown in the following exhi...
Question 146: You manage a Power BI model has a table named Sales and prod...
Question 147: You import a large dataset to Power Query Editor. You need t...
Question 148: You have a Power BI report. You need to create a calculated ...
Question 149: You have a folder that contains 100 CSV files. You need to m...
Question 150: You import a Power Bl dataset that contains the following ta...
Question 151: You have a Power BI imported dataset that contains the data ...
Question 152: You plan to create a dashboard in the Power BI service that ...
Question 153: You have a collection of reports for the HR department of yo...
Question 154: You have a Power BI report named Report' and a dashboard nam...
Question 155: Your company plans to completely separate development and pr...
Question 156: You are creating a line chart in a Power Bl report as shown ...