PL-300 Exam Dumps | You plan to create a Power BI semantic model named ModeM that will contain data from an Azure SQL database.

<< Prev Question Next Question >>

Question 141/231

You plan to create a Power BI semantic model named ModeM that will contain data from an Azure SQL database. Model1 will have the following tables.

For the last three days, refresh in Power BI has failed, and you receive the following error message: " You have reached the maximum allowable memory allocation for your tier. Consider upgrading to a tier with more available memory. " You need to resolve the error and ensure that query response times are minimized for end users.
What should you do?

A. Merge the Sales person and Invoice tables based on the SalesPersonld column.

B. Change the Invoice table to a composite table that contains historical data as a DirectQuery table and hot data as an import table, and then partition the table.

C. Change the Invoice table to a DirectQuery table and read the data live from the source, retaining only the dimension tables as import tables.

D. Reduce the size of the Invoice table by summarizing sales by Product, Sales person, Calendar, and Customer.

Question List (231q): Question 1: You are building a semantic model from a JSON file that cont...; Question 2: You need to create a calculated column to display the month ...; Question 3: You have a query that contains customer data in Power Query ...; Question 4: In Power BI Desktop, you are creating visualizations in a re...; Question 5: You have sales data in a star schema that contains four tabl...; Question 6: You have a Microsoft Power BI report. The size of PBIX file ...; Question 7: You publish a semantic model that contains data from an on-p...; Question 8: You have a Power BI report that contains a page. The page co...; Question 9: You have a Power BI model that contains a table named Sales....; Question 10: You have a table that contains a column named Phone. The fol...; Question 11: You have an on-premises data gateway. You need to reduce the...; Question 12: You have a Fabric workspace. You need to create two reports ...; Question 13: You have a Power BI model that contains the following data. ...; Question 14: You plan to embed multiple visualization in a public website...; Question 15: You have a Power BI app that contains a report named Report1...; Question 16: You are creating a dashboard by using the Power BI service. ...; Question 17: You are modifying a Power BI model by using Power BI Desktop...; Question 18: You have a Microsoft Exert spreadsheet named Excel1 that con...; Question 19: You have a Power BI report that contains five bookmarks. You...; Question 20: You need to create the On-Time Shipping report. The report m...; Question 21: You need to calculate the last day of the month in the balan...; Question 22: You are using the key influencers visual to identify which f...; Question 23: You are building a Power BI report. Users will view the repo...; Question 24: You create a Power BI report named RPT1 that contains sales ...; Question 25: You use Power Query to import two tables named Order Header ...; Question 26: You create a semantic model sourced from dozens of flat file...; Question 27: You have a PBIX file that imports several tables from an Azu...; Question 28: You use Power Query Editor to preview the data shown in the ...; Question 29: You have a report that contains a bar chart and a column cha...; Question 30: (Exhibit) Users only use the date portion of the Transaction...; Question 31: You receive annual sales data that must be included in Power...; Question 32: You have a report in Power BI Desktop. You add a key influen...; Question 33: You plan to use Power BI Desktop optimized for Power BI Repo...; Question 34: You have a Power BI report that contains the table visual sh...; Question 35: You have a Power BI data model that contains a table named E...; Question 36: Note: This question is part of a series of questions that pr...; Question 37: You publish the semantic model to the Power BI service. For ...; Question 38: You have a Power BI workspace that contains several reports....; Question 39: You have the Azure SQL databases shown in the following tabl...; Question 40: You have sales data in a star schema that contains four tabl...; Question 41: Vou have a Power BI semantic model that contains the followi...; Question 42: The tables have the following relationships. (Exhibit) You h...; Question 43: You use Power BI Desktop to import two tables named Customer...; Question 44: You use Power Query Editor to create a query named Products....; Question 45: You have a source that contains a comumn. The column contain...; Question 46: You have a Power BI report that contains five pages. Pages 1...; Question 47: You have the visual shown in the Original exhibit. (Exhibit)...; Question 48: Note: This question is part of a series of questions that pr...; Question 49: (Exhibit) Each Region value appears only on the tow where it...; Question 50: You need to provide a user with the ability to add members t...; Question 51: You are using existing reports to build a dashboard that wil...; Question 52: You use Microsoft Power BI Desktop to review the data shown ...; Question 53: Note: This question is part of a series of questions that pr...; Question 54: You plan to use Power BI Desktop to create a bog tracking da...; Question 55: You have four sales regions. Each region has multiple sales ...; Question 56: You have a Power BI tenant. You have reports that use financ...; Question 57: You have a Power BI report. You need to create a calculated ...; Question 58: You have a Power BI data model that imports data from a Micr...; Question 59: You create a report by using Microsoft Power BI Desktop. The...; Question 60: You have a semantic mortal that is used infrequently and ref...; Question 61: You have an app workspace that contains a dashboard and four...; Question 62: You have a Microsoft Power BI report. The size of PBIX file ...; Question 63: You are creating a Power BI report by using Power BI Desktop...; Question 64: You are creating a column chart visualization. You configure...; Question 65: Note: This question is a part of a series of questions that ...; Question 66: You need to create a visual as shown in the following exhibi...; Question 67: You build a Power BI report that displays IoT temperature da...; Question 68: Note: This question is part of a series of questions that pr...; Question 69: Note: This question is part of a series of questions that pr...; Question 70: What should you create to meet the reporting requirements of...; Question 71: You plan to create the chart shown in the following exhibit....; Question 72: You are reviewing a query that produces 10,000 rows in the P...; Question 73: You have a semantic model that contains a table named Sales....; Question 74: You import a large semantic model to Power Query Editor. You...; Question 75: Note: This question is part of a series of questions that pr...; Question 76: You have a Power BI report that contains a bar chart. The ba...; Question 77: You have a Power BI semantic model. You discover that he sem...; Question 78: Note: This question is part of a series of questions that pr...; Question 79: You embed a Power BI report in a Microsoft SharePoint Online...; Question 80: Adding an index key and normalizing casing in the data sourc...; Question 81: You have a collection of reports for the HR department of yo...; Question 82: Note: This question is part of a series of questions that us...; Question 83: The tables have the following relationships. (Exhibit) You h...; Question 84: In Power BI Desktop, you are building a sales report that co...; Question 85: You have a Power BI semantic model that contains a table nam...; Question 86: You have a Power BI semantic model that contains a table You...; Question 87: You have a Power BI semantic model that contains the followi...; Question 88: You need to recommend a strategy to consistently define the ...; Question 89: You are creating a Power BI report to analyze consumer purch...; Question 90: You have a Power BI query named Sates that imports the colum...; Question 91: A user creates a Power BI report named ReportA that uses a c...; Question 92: You are profiling data by using Power Query Editor. You have...; Question 93: You have a prospective customer list that contains 1,500 row...; Question 94: You need to grant access to the business unit analysts. What...; Question 95: You have a CSV file that contains user complaints. The file ...; Question 96: You have a Power BI report that contains one visual You need...; Question 97: You have a Power BI report. The report contains visualizatio...; Question 98: You have a semantic model named Pens that contains the follo...; Question 99: You have a Power BI model mat contains a table named Date. T...; Question 100: You have the Power BI data model shown in the following exhi...; Question 101: You have a Power BI report. You have the following tables. (...; Question 102: You import a Power BI semantic model that contains the follo...; Question 103: You have a project management app that is fully hosted in Mi...; Question 104: For the sales department at your company, you publish a Powe...; Question 105: You are creating a visual to show the ranking of product cat...; Question 106: You have a Power BI report that contains three pages. The pa...; Question 107: You are creating a Power BI model in Power BI Desktop You ne...; Question 108: Note: This question is part of a series of questions that pr...; Question 109: You have a semantic model in import mode that contains the m...; Question 110: You have a Fabric workspace that contains the items shown in...; Question 111: You plan to create a report that will display sales data fro...; Question 112: You have a sales system that contains the tables shown in th...; Question 113: Note: This question is part of a series of questions that pr...; Question 114: You have a Power BI report that contains three pages named P...; Question 115: You use Power Query Editor to review a query that contains a...; Question 116: Note: This question is part of a series of questions that pr...; Question 117: You are creating a Microsoft Power BI imported data model to...; Question 118: You build a report to analyze customer transactions from a d...; Question 119: The Sales table contains records of sales by day from the la...; Question 120: The tables have the following relationships. (Exhibit) You h...; Question 121: You need to design the data model and the relationships for ...; Question 122: You have a Microsoft Excel workbook that contains two sheets...; Question 123: You have multiple dashboards. You need to ensure that when u...; Question 124: Note: This question is part of a series of questions that pr...; Question 125: You a-e using Power BI Desktop 10 profile data in Power Quer...; Question 126: You create a dashboard by using the Microsoft Power BI Servi...; Question 127: You are creating a Power BI single-page report. Some users w...; Question 128: You publish a report to a workspace named Customer Services....; Question 129: You receive revenue data that must be included in Microsoft ...; Question 130: You use Power Query Editor to preview the data shown in the ...; Question 131: You need to create a KPI visualization to meet the reporting...; Question 132: You have a table that contains sales data and approximately ...; Question 133: You have a Power BI workspace named BI Data that contains a ...; Question 134: You have two CSV files named Products and Categories. The Pr...; Question 135: You have a custom connector that returns ID, From, To, Subje...; Question 136: You are building a Power BI report that uses data from an Az...; Question 137: You need to use Power BI to create a visual that will allow ...; Question 138: In Power BI Desktop, you have a semantic model that contains...; Question 139: You have a Power BI data model that imports a date table and...; Question 140: You need to ensure that the data is updated to meet the repo...; Question 141: You plan to create a Power BI semantic model named ModeM tha...; Question 142: Your organization has a team of power users who recently cre...; Question 143: You have a report that includes a card visualization. You ne...; Question 144: Adding an index key and normalizing casing in the data sourc...; Question 145: You have a Fabric tenant that hosts the semantic models show...; Question 146: You attempt to open a PBIX file in Microsoft Power BI Deskto...; Question 147: You have the Performance analyzer results shown in the follo...; Question 148: Once the profit and loss semantic model is created, which fo...; Question 149: You attempt to connect Power BI Desktop to a Cassandra datab...; Question 150: You import two Microsoft Excel tables named Customer and Add...; Question 151: You are creating a query to be used as a Country dimension i...; Question 152: You are designing the data model for a Power BI semantic mod...; Question 153: You have a Power BI report that uses row-level security (RLS...; Question 154: You have the line chart shown in the exhibit. (Exhibit) You ...; Question 155: You have a Fabric workspace named Workspace1 that contains t...; Question 156: You plan to use Power BI to create a quarterly profit report...; Question 157: Your company has training videos that are published to Micro...; Question 158: A manager can represent only a single country. You need to u...; Question 159: You have a report that contains four pages. Each page contai...; Question 160: You need to create a visual that enables the adhoc explorati...; Question 161: You have the CSV file shown in the following table. (Exhibit...; Question 162: You need to create relationships to meet the reporting requi...; Question 163: You have the data lineage shown in the following exhibit. (E...; Question 164: You have a Microsoft 365 subscription that contains the reso...; Question 165: You need to configure access for the sales department users....; Question 166: You are developing a report page. Some users will navigate t...; Question 167: You are creating a new semantic model in Microsoft Power BI ...; Question 168: You create a Fabric workspace named Workspace!. You publish ...; Question 169: You have a Power BI dashboard that displays different visual...; Question 170: You have an Azure SQL database that contains sales transacti...; Question 171: Note: This question is part of a series of questions that pr...; Question 172: You are configuring a Microsoft Power BI data model to enabl...; Question 173: You use Power Query Editor to preview the data in a column n...; Question 174: You need to create a relationship in the data model for RLS....; Question 175: You publish the semantic model to the Power BI service. For ...; Question 176: You have a Q & A visual that displays information from a...; Question 177: You have the tables shown in the following table. (Exhibit) ...; Question 178: You have a source that contains a comumn. The column contain...; Question 179: You have a Power BI report that contains one page. The page ...; Question 180: You have five sales regions. Each region is assigned a singl...; Question 181: You open the Power BI service as shown in the following exhi...; Question 182: You have a data model that contains many complex DAX express...; Question 183: You have multiple dashboards. You need to ensure that when u...; Question 184: You use an R visual to produce a map of 500,000 customers. Y...; Question 185: You have a Power BI report that contains the fields shown in...; Question 186: Note: This question is part of a series of questions that pr...; Question 187: You have a Fabric workspace named Workspace1 and a group nam...; Question 188: You have a Microsoft Excel file in a Microsoft OneDrive fold...; Question 189: You have two tables named Customers and Invoice in a Power B...; Question 190: You merge data from Sales.Region, Region_Manager, Sales_Mana...; Question 191: You have a Microsoft Power BI dashboard. You need to ensure ...; Question 192: You have a dashboard that contains tiles pinned from a singl...; Question 193: You plan to create a Power BI semantic model to analyze atte...; Question 194: You create a Power BI semantic model that contains the table...; Question 195: You have a Power BI report named ReportA. You have a Power B...; Question 196: You need to create a semantic model in Power BI Desktop. The...; Question 197: Note: This question is part of a series of questions that us...; Question 198: You create a semantic model sourced from dozens of flat file...; Question 199: You have a Power BI model that contains the following data. ...; Question 200: You have a Power BI report that contains a clustered bar cha...; Question 201: You have a Power BI workspace named Inventory that contains ...; Question 202: You have a semantic model named Model1 that will be used to ...; Question 203: Note: This question is part of a series of questions that pr...; Question 204: You have a semantic model named Model1 that contains sales d...; Question 205: The tables have the following relationships. (Exhibit) You h...; Question 206: You plan to use Power BI to create sales invoices for custom...; Question 207: You have a Power BI report that uses a semantic model based ...; Question 208: You use Power Query Editor to ingest data into Power BI Desk...; Question 209: You have a Microsoft Power BI workspace. You need to grant t...; Question 210: Your company has employees in 10 states. The company recentl...; Question 211: You are profiling data by using Power Query Editor. The Addr...; Question 212: You have the Power BI data model shown in the following exhi...; Question 213: You need to get data from the Microsoft SQL Server tables. W...; Question 214: You are profiling data by using Power Query Editor. You have...; Question 215: You manage a Power BI model has a table named Sales and prod...; Question 216: (Exhibit) Each employee has one manager as shown in the Pare...; Question 217: You use Power BI Desktop to open a PBIX file that contains a...; Question 218: Vou plan to create a Power BI report that will be connected ...; Question 219: You have a Power BI semantic model that contains the followi...; Question 220: You have a Power BI report named Report1 and a dashboard nam...; Question 221: You have a semantic model that contains two tables named Sal...; Question 222: Note: This question is part of a series of questions that pr...; Question 223: Your company has affiliates who help the company acquire cus...; Question 224: You build a report about warehouse inventory data. The seman...; Question 225: You have a Power BI semantic model that contains the followi...; Question 226: You are creating reports in Power BI Desktop. The model has ...; Question 227: You need to minimize the size of the semantic model. The sol...; Question 228: You have a Power BI semantic model named Model1. You need to...; Question 229: You need to create a Power BI report. The first page or the ...; Question 230: You are using Performance analyzer to analyze the performanc...; Question 231: You have an API that returns more than 100 columns. The foll...

Question 141/231

LEAVE A REPLY

Download PDF File