<< Prev Question Next Question >>

Question 117/182

You publish a dataset that contains data from an on-premises Microsoft SQL Server database.
The dataset must be refreshed daily.
You need to ensure that the Power BI service can connect to the database and refresh the dataset.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct

LEAVE A REPLY

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

Question List (182q)
Question 1: You plan to create a report that will display sales data fro...
Question 2: What should you create to meet the reporting requirements of...
Question 3: You have a Power Bl report that uses row-level security (RLS...
Question 4: You have a Power BI report that uses a dataset based on an A...
Question 5: Note: This question is part of a series of questions that pr...
Question 6: Note: This question is part of a series of questions that pr...
Question 7: You are building a data model for a Power Bl report. You hav...
Question 8: You are creating a Power Bi model in Power BI Desktop You ne...
Question 9: You have a Power B1 semantic model that contains two tables ...
Question 10: You have a data model that contains many complex DAX express...
Question 11: You have a Power BI tenant. You have reports that use financ...
Question 12: You create the following step by using Power Query Editor. =...
Question 13: You have a report page that contains the visuals shown in th...
Question 14: You have a Microsoft Excel file on a file server. You create...
Question 15: You have a Microsoft Power Bl report. The size of PBIX file ...
Question 16: Note: This question is part of a series of questions that pr...
Question 17: You have a Power Bl semantic model that contains two queries...
Question 18: You need to create a Power BI theme that will be used in mul...
Question 19: You have a collection of reports for the HR department of yo...
Question 20: You need to create a date table in Power B1 that must contai...
Question 21: Note: This question is a part of a series of questions that ...
Question 22: You have a Power BI report that contains one page. The page ...
Question 23: - You are using Power Query Editor to preview the data in a ...
Question 24: You have the Power BI data model shown in the following exhi...
Question 25: You use Power Query to import two tables named Order Header ...
Question 26: You have a dashboard that contains tiles pinned from a singl...
Question 27: You have a Power Bi data model that imports data from a Micr...
Question 28: In Power BI Desktop, you have a dataset that contains a tabl...
Question 29: You have a Power BI model that has the following tables: Pro...
Question 30: You use Power BI Desktop to import two tables named Customer...
Question 31: You use Power Query Editor to preview customer feedback data...
Question 32: Note: This question is part of a series of questions that pr...
Question 33: You are creating a Microsoft Power Bl model that has two tab...
Question 34: You have an on-premises Power BI Report Server. You plan to ...
Question 35: You use Power Query Editor to preview the data shown in the ...
Question 36: You use Power Query Editor to load two queries named Query 1...
Question 37: You are creating an analytics report that will consume data ...
Question 38: You have a query that returns the data shown in the followin...
Question 39: You have a Power B1 report that contains the visuals shown i...
Question 40: Which two types of visualizations can be used in the balance...
Question 41: You have the line chart shown in the exhibit. (Click the Exh...
Question 42: You have the Power BI data model shown in the following exhi...
Question 43: You have a Power Bl report that will be rendered on a vertic...
Question 44: You have a data source that contain a column. The column con...
Question 45: You need to create a visual that compares profit across 10 p...
Question 46: You a-e using Power Bl Desktop 10 profile data in Power Quer...
Question 47: You need to create a visual as shown in the following exhibi...
Question 48: You attempt to connect Power BI Desktop to a Cassandra datab...
Question 49: You have a table that contains a column named Phone. The fol...
Question 50: You have a Power BI model that contains a table named Sales....
Question 51: What is the minimum number of datasets and storage modes req...
Question 52: You have a semantic model that contains two tables named Sal...
Question 53: You are creating reports in Power BI Desktop. The model has ...
Question 54: In Power BI Desktop, you are creating a report that will con...
Question 55: You have a Power BI report that contains the table visual sh...
Question 56: You need to design the data model and the relationships for ...
Question 57: You need to create a visual that enables the adhoc explorati...
Question 58: You have a Power BI report that contains a page. The page co...
Question 59: Note: This question is part of a series of questions that pr...
Question 60: You have an on-premises data gateway. You need to reduce the...
Question 61: You have the following table named Location. (Exhibit) The G...
Question 62: You have a Microsoft 365 subscription that contains the reso...
Question 63: You have a Power Bi report that contains five bookmarks. You...
Question 64: You publish a Microsoft Power BI dataset to powerbi.com. The...
Question 65: You have a Power B1 report that contains a card. The card di...
Question 66: You have a Power Bl workspace that contains a dataset. a rep...
Question 67: You need to create the relationship between the product list...
Question 68: You have a Power Bl model that contains two tables named Pop...
Question 69: Your company plans to completely separate development and pr...
Question 70: You are creating a Microsoft Power Bl imported data model to...
Question 71: Note: This question is part of a series of questions that pr...
Question 72: Note: This question is part of a series of questions that pr...
Question 73: Note: This question is part of a series of questions that pr...
Question 74: You have a Power Bl report that contains the visual shown in...
Question 75: Note: This question is part of a series of questions that us...
Question 76: You have a table named DiMCountries that contains a column n...
Question 77: You have a semantic model named Model1. You need to ensure t...
Question 78: Note: This question is part of a series of questions that pr...
Question 79: You build a report about warehouse inventory dat a. The data...
Question 80: You are creating a new semantic model in Microsoft Power Bl ...
Question 81: You have a Power BI workspace named BI Data that contains a ...
Question 82: You are enhancing a Power BI model that has DAX calculations...
Question 83: You need to provide a user with the ability to add members t...
Question 84: You have a semantic model named Model1 that contains sales d...
Question 85: Exhibit: (Exhibit) You need to create a report that meets th...
Question 86: You use Power Query Editor to review the query shown in the ...
Question 87: You are profiling data by using Power Query Editor. The Addr...
Question 88: You are building a dataset from a JSON file that contains an...
Question 89: You have the Azure SQL databases shown in the following tabl...
Question 90: You have a report in Power Bl named report1 that is based on...
Question 91: In the Power BI service, you create an app workplace that co...
Question 92: You have a Power BI model that contains the following data. ...
Question 93: You have a Power Bl query named Sates that imports the colum...
Question 94: You have a query named Customer that imports CSV files from ...
Question 95: You have the Power Bi dashboard shown in the Dashboard exhib...
Question 96: How should you distribute the reports to the board? To answe...
Question 97: You are using Performance analyzer to analyze the performanc...
Question 98: You have a large dataset that contains more than 1 million r...
Question 99: You have a Power BI semantic model named Model1. You need to...
Question 100: You are creating a Power Bl report by using Power Bi Desktop...
Question 101: You have a CSV file that contains user complaints. The file ...
Question 102: Note: This question is part of a series of questions that pr...
Question 103: You are preparing a financial report in Power BI. You connec...
Question 104: You have a source that contains a comumn. The column contain...
Question 105: Note: This question is part of a series of questions that pr...
Question 106: In Power Bi Desktop, you are creating visualizations in a re...
Question 107: Note: This question is part of a series of questions that pr...
Question 108: You have an app workspace named Retail Analysis in the Power...
Question 109: You use an R visual to produce a map of 500,000 customers. Y...
Question 110: You have two tables named Customers and Invoice in a Power B...
Question 111: You have a CSV file that contains user complaints. The file ...
Question 112: You need to grant access to the business unit analysts. What...
Question 113: You are creating a report in Power BI Desktop. You load a da...
Question 114: A business intelligence (Bl) developer creates a dataflow in...
Question 115: You have the Power BI data model shown in the following exhi...
Question 116: You have a Power 81 semantic model that contains a table nam...
Question 117: You publish a dataset that contains data from an on-premises...
Question 118: You have a Power BI report that contains four pages. All the...
Question 119: You need to ensure that the data is updated to meet the repo...
Question 120: Note: This question is part of a series of questions that pr...
Question 121: You have a Microsoft Power Bl dashboard. You need to ensure ...
Question 122: You have a semantic model that has the permissions shown in ...
Question 123: You need to create a visualization to meet the reporting req...
Question 124: You are building a Power BI report to analyze customer segme...
Question 125: You are using the key influencers visual to identify which f...
Question 126: A manager can represent only a single country. You need to u...
Question 127: Note: This question is a part of a series of questions that ...
Question 128: You have a semantic model that uses a live connection to a s...
Question 129: You have a Fabric workspace that contains the items shown in...
Question 130: SIMULATION You need to create the Top Customers report. Whic...
Question 131: You have a semantic model named Model1 that contains the fol...
Question 132: You need to create a visualization that compares revenue and...
Question 133: You have a Microsoft Excel workbook that contains two tables...
Question 134: You publish a semantic model to the Power Bl service. The se...
Question 135: You have a Microsoft Excel spreadsheet that contains the dat...
Question 136: You plan to use Power Query Editor to get data from an API. ...
Question 137: You have a Power Bl workspace that contains several reports....
Question 138: You have a CSV file that contains user complaints. The file ...
Question 139: You have a semantic model that contains a table named Employ...
Question 140: You have a Power Bl report that contains a measure named Tot...
Question 141: You have a Power BI app named App1. The privacy for the App1...
Question 142: You import two Microsoft Excel tables named Customer and Add...
Question 143: For the sales department at your company, you publish a Powe...
Question 144: You have a Power B1 report that contains the fields shown in...
Question 145: In Power Query Editor, you have a query named Sales Data tha...
Question 146: You have a Power B1 report that contains the table visual sh...
Question 147: You have two Power Bl reports named ReportA and ReportB that...
Question 148: You have a Power 81 report. The report contains a single rep...
Question 149: You are creating a Power 81 model to analyze inventory. You ...
Question 150: You are profiling data by using Power Query Editor. You have...
Question 151: You use Microsoft Power B1 Desktop to review the data shown ...
Question 152: Note: This question is part of a series of questions that pr...
Question 153: You are creating a sales report in Power Bl for the NorthWes...
Question 154: You need to recommend a strategy to consistently define the ...
Question 155: You need to create a Power Bl theme that will be used in mul...
Question 156: You need to design the data model to meet the report require...
Question 157: Note: This question is part of a series of questions that pr...
Question 158: Vou have a Microsoft Power Bl Desktop report named Report! t...
Question 159: You have a semantic model. You need to configure row level s...
Question 160: You need to create a measure that will return the percentage...
Question 161: You have a semantic model that contains a table named Sales....
Question 162: You have a Power B1 report. The report contains a line chart...
Question 163: You are creating a Power Bi model and report. You have a sin...
Question 164: You have a dataset that contains revenue data from the past ...
Question 165: You have multiple dashboards. You need to ensure that when u...
Question 166: Note: This question is part of a series of questions that pr...
Question 167: You have a Power Bl workspace named Inventory that contains ...
Question 168: You have a Power Bi model mat contains a table named Date. T...
Question 169: You have the Performance analyzer results shown in the follo...
Question 170: You open powerbi.com as shown in the following exhibit. Use ...
Question 171: You have a Microsoft SharePoint Online site that contains se...
Question 172: Note: This question is part of a series of questions that pr...
Question 173: You use Power Query Editor to Import three tables named Cust...
Question 174: You need to create a calculated column to display the month ...
Question 175: Note: This question is part of a series of questions that pr...
Question 176: You are developing a report page. Some users will navigate t...
Question 177: Note: This question is part of a series of questions that pr...
Question 178: The Sales table contains records of sales by day from the la...
Question 179: You have a query in Power Query Editor that contains the fol...
Question 180: You use Power BI Desktop to open a PBIX file that contains a...
Question 181: You have a Q&amp;A visual that displays information from a t...
Question 182: You have a report in Power BI Desktop. You add a key influen...