<< Prev Question Next Question >>

Question 117/176

You have two Azure SQL databases that contain the same tables and columns.
For each database, you create a query that retrieves data from a table named Customers.
You need to combine the Customer tables into a single table. The solution must minimize the size of the data model and support scheduled refresh in powerbi.com.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

LEAVE A REPLY

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

Question List (176q)
Question 1: You are developing a sales report that will have multiple pa...
Question 2: You publish a report to a workspace named Customer Services....
Question 3: Note: This question is part of a series of questions that pr...
Question 4: Remove unused columns from tables in the data model. This wi...
Question 5: You are using the key influencers visual to identify which f...
Question 6: You have a Power BI semantic model named Model1 that contain...
Question 7: You need to create a Power BI report. The first page of the ...
Question 8: You need to design the data model to meet the report require...
Question 9: You have a Power BI dashboard that displays different visual...
Question 10: You are creating a Power Bi report that will contain multipl...
Question 11: In the Power BI service, you create an app workplace that co...
Question 12: Note: This question is part of a series of questions that pr...
Question 13: You have a report that contains four pages. Each page contai...
Question 14: You have a Power B1 dataset that contains quarterly sales pe...
Question 15: You have a report in Power Bl named report1 that is based on...
Question 16: You plan to use Power BI Desktop optimized for Power BI Repo...
Question 17: You manage a Power BI model has a table named Sales and prod...
Question 18: You have a report in Power BI Desktop as shown in the follow...
Question 19: You need to ensure that the data is updated to meet the repo...
Question 20: You have a Power Bl visual that uses indicators to show valu...
Question 21: You have a Power Bl model that contains two tables named Pop...
Question 22: You a-e using Power Bl Desktop 10 profile data in Power Quer...
Question 23: You have a semantic model that has the permissions shown in ...
Question 24: You have a CSV file that contains user complaints. The file ...
Question 25: You receive revenue data that must be included in Microsoft ...
Question 26: Which DAX expression should you use to get the ending balanc...
Question 27: You have a Power Bl workspace named Inventory that contains ...
Question 28: You have the visual shown in the exhibit. (Click the Exhibit...
Question 29: You have a report page that contains the visuals shown in th...
Question 30: You have a custom connector that returns ID, From, To, Subje...
Question 31: You have a Power Bl workspace named Workspace1 that contains...
Question 32: You are creating a quick measure as shown in the following e...
Question 33: You have a BI dataset and a connected report. You need to en...
Question 34: You are creating a Power Bi model and report. You have a sin...
Question 35: You have a Power BI report named Report' and a dashboard nam...
Question 36: You have a column named UnitslnStock as shown in the followi...
Question 37: You have the dashboard shown in the following exhibit. (Exhi...
Question 38: Adding an index key and normalizing casing in the data sourc...
Question 39: You need to create the Top Customers report. Which type of f...
Question 40: You have a Power B1 semantic model that contains two tables ...
Question 41: You create a dataset sourced from dozens of flat files in Az...
Question 42: You have a Power B1 report that contains one visual You need...
Question 43: You import a large dataset to Power Query Editor. You need t...
Question 44: You need to create a relationship in the data model for RLS....
Question 45: Note: This question is part of a series of questions that pr...
Question 46: You are profiting data by using Power Query Editor. You have...
Question 47: You need to create a Power Bl report. The first page or the ...
Question 48: You are creating a Microsoft Power Bl imported data model to...
Question 49: You have a Power BI data model that contains a table named E...
Question 50: You plan to generate a line chart to visualize and compare t...
Question 51: You have a semantic model named Model1. You have a Power BI ...
Question 52: You are profiling data by using Power Query Editor. You have...
Question 53: You need to design the data model and the relationships for ...
Question 54: You have a Microsoft Power Bl workspace. You need to grant t...
Question 55: You have a report in Power BI Desktop. You add a key influen...
Question 56: You plan to use Power Bl Desktop to create a bog tracking da...
Question 57: You are creating a Microsoft Power Bl model that has two tab...
Question 58: How should you distribute the reports to the board? To answe...
Question 59: You have a Power Bi data model that imports data from a Micr...
Question 60: You need to get data from the Microsoft SQL Server tables. W...
Question 61: You are creating a Power Bl report by using Power Bi Desktop...
Question 62: Note: This question is part of a series of questions that us...
Question 63: What should you create to meet the reporting requirements of...
Question 64: You have a collection of reports for the HR department of yo...
Question 65: You create the following step by using Power Query Editor. =...
Question 66: From Power Query Editor, you attempt to execute a query and ...
Question 67: You have a Power Bl app that contains a report named Report1...
Question 68: You are creating a dashboard by using the Power Bl service. ...
Question 69: Note: This question is part of a series of questions that pr...
Question 70: You have an app workspace named Retail Analysis in the Power...
Question 71: You need to create the Top Customers report. Which type of f...
Question 72: You have a power BI tenant that hosts the datasets shown in ...
Question 73: You are creating an analytics report that will consume data ...
Question 74: You have a Power Bl query named Sates that imports the colum...
Question 75: You have a Power Bl workspace that contains a dataset. a rep...
Question 76: You view a query named Transactions as shown in the followin...
Question 77: You have a Power Bl report that contains the visual shown in...
Question 78: You need to create a Power Bl theme that will be used in mul...
Question 79: You have a query named Customer that imports CSV files from ...
Question 80: You use Power Query Editor to preview the data shown in the ...
Question 81: You are profiling data by using Power Query Editor. You have...
Question 82: You have a Microsoft Excel spreadsheet that contains the dat...
Question 83: You have a dashboard that contains tiles pinned from a singl...
Question 84: You need to create a visualization to meet the reporting req...
Question 85: You are modifying a Power Bi model by using Power Bl Desktop...
Question 86: You need to recommend a strategy to consistently define the ...
Question 87: You need to create a relationship in the dataset for RLS. Wh...
Question 88: You have a Power Bl report that contains a measure named Tot...
Question 89: You need to create a visual as shown in the following exhibi...
Question 90: (Exhibit) Users only use the date portion of the Transaction...
Question 91: You are creating a Power BI report to analyze consumer purch...
Question 92: You have a Microsoft Excel file in a Microsoft OneDrive fold...
Question 93: You are creating a line chart in a Power Bl report as shown ...
Question 94: You have a Power BI dashboard that monitors the quality of m...
Question 95: You have a Power BI app named App1. The privacy for the App1...
Question 96: Note: This question is a part of a series of questions that ...
Question 97: You create a Power Bl report1 named Summary1 You discover th...
Question 98: You use Power Query Editor to review a query that contains a...
Question 99: Note: This question is part of a series of questions that pr...
Question 100: You have a report that contains a bar chart and a column cha...
Question 101: You have a Microsoft Power Bl report. The size of PBIX file ...
Question 102: You publish a Microsoft Power BI dataset to powerbi.com. The...
Question 103: You have the Power BI data model shown in the following exhi...
Question 104: You are using Power Bi Desktop to connect to an Azure SQL da...
Question 105: You build a report to analyze customer transactions from a d...
Question 106: You have a query that returns the data shown in the followin...
Question 107: You have a collection of reports for the HR department of yo...
Question 108: You have a Power Bl report that contains a page. The page co...
Question 109: You have a Power Bl semantic model that contains the data so...
Question 110: You publish the dataset to powerbi.com. For each of the foll...
Question 111: You have a Power Bl semantic model that contains the followi...
Question 112: You have a Microsoft Power BI data model that contains three...
Question 113: You are creating a Power Bi model in Power BI Desktop You ne...
Question 114: You create a Power Bl dataset that contains the table shown ...
Question 115: Note: This question is part of a series of questions that pr...
Question 116: You have a Power BI imported dataset that contains the data ...
Question 117: You have two Azure SQL databases that contain the same table...
Question 118: You attempt to use power Query Editor to create a custom col...
Question 119: You have a Microsoft Power Bl dashboard. You need to ensure ...
Question 120: You have a Power BI model that contains the following data. ...
Question 121: You receive annual sales data that must be included in Power...
Question 122: You have a Power BI semantic model named Model1. You need to...
Question 123: You have a Microsoft 365 subscription that contains the reso...
Question 124: You have a Power BI semantic model that contains a table nam...
Question 125: You have a Power B1 report named ReportA. You have a Power B...
Question 126: You have a project management app that is fully hosted in Mi...
Question 127: You have an API that returns more than 100 columns. The foll...
Question 128: Note: This question is part of a series of questions that pr...
Question 129: Note: This question is part of a series of questions that pr...
Question 130: The data model must support the following analysis: * Total ...
Question 131: You have a report that includes a card visualization. You ne...
Question 132: You need to create the relationship between the product list...
Question 133: You are preparing a financial report in Power BI. You connec...
Question 134: You have a Power Bl semantic model that contains two queries...
Question 135: You open a query in Power Query Editor. You need to identify...
Question 136: You plan to use Power B1 to create sales invoices for custom...
Question 137: You need to create a measure that will return the percentage...
Question 138: You create a data model in Power BI. Report developers and u...
Question 139: You need to address the data concerns before creating the da...
Question 140: You have data in a Microsoft Excel worksheet as shown in the...
Question 141: Vou have a Microsoft Power Bl Desktop report named Report! t...
Question 142: You have a Power Bl workspace that contains a dataset. a rep...
Question 143: You are designing the data model for a Power Bl semantic mod...
Question 144: A manager can represent only a single country. You need to u...
Question 145: You plan to use Power BI to create a quarterly profit report...
Question 146: You have four sales regions. Each region has multiple sales ...
Question 147: You have the following table named Location. (Exhibit) The G...
Question 148: You have a Power BI report that contains the table visual sh...
Question 149: You have two tables named Customers and Invoice in a Power B...
Question 150: You have the line chart shown in the exhibit. (Click the Exh...
Question 151: You plan to embed multiple visualization in a public website...
Question 152: You have a Power 81 semantic model that contains a table nam...
Question 153: You have a Power B1 report that contains three pages named P...
Question 154: You have a semantic mortal that is used infrequently and ref...
Question 155: You have a source that contains a comumn. The column contain...
Question 156: You use Power BI Desktop to open a PBIX file that contains a...
Question 157: You have a Microsoft Power BI report. The size of PBIX file ...
Question 158: You have the CSV file shown in the following table. (Exhibit...
Question 159: Note: This question is a part of a series of questions that ...
Question 160: You import a Power Bl dataset that contains the following ta...
Question 161: Adding an index key and normalizing casing in the data sourc...
Question 162: You have a table that contains the following three columns: ...
Question 163: Note: This question is part of a series of questions that pr...
Question 164: Your company has employees in 10 states. The company recentl...
Question 165: You have a Power Bl report that contains the table shown in ...
Question 166: You have a Power BI data model that imports a date table and...
Question 167: You have the Power BI data model shown in the following exhi...
Question 168: You have a query named All Sales that imports sales data int...
Question 169: You need to provide a solution to provide the sales managers...
Question 170: Once the profit and loss dataset is created, which four acti...
Question 171: You are building a data model for a Power Bl report. You hav...
Question 172: Note: This question is part of a series of questions that pr...
Question 173: You use Power Query Editor to review the query shown in the ...
Question 174: You have a data model that contains many complex DAX express...
Question 175: You need to create a calculated column to display the month ...
Question 176: You have a Fabric tenant that hosts the semantic models show...