70-779 practice questions
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have two Microsoft SQL Server database servers named Production1 and Test1. Production1 contains the same tables as Test1, but only a subset of the data. You add Test1 as a data source, and you select 10 tables. You configure several transformations. You need to connect the model to the tables in Production1. The solution must maintain the existing transformations. Solution: You create a new connection to Production1, and then you import the tables. Does this meet the goal?
A. Yes
B. No
Discussion forum
Question
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have two Microsoft SQL Server database servers named Production1 and Test1. Production1 contains the same tables as Test1, but only a subset of the data. You add Test1 as a data source, and you select 10 tables. You configure several transformations. You need to connect the model to the tables in Production1. The solution must maintain the existing transformations. Solution: From Query Editor, you edit the source of each table query. Does this meet the goal?
A. Yes
B. No
Discussion forum
Question
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have two Microsoft SQL Server database servers named Production1 and Test1. Production1 contains the same tables as Test1, but only a subset of the data. You add Test1 as a data source, and you select 10 tables. You configure several transformations. You need to connect the model to the tables in Production1. The solution must maintain the existing transformations. Solution: From Query Editor, you edit the source of each table query. Does this meet the goal?
A. Yes
B. No
Discussion forum
Question
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have two Microsoft SQL Server database servers named Production1 and Test1. Production1 contains the same tables as Test1, but only a subset of the data. You add Test1 as a data source, and you select 10 tables. You configure several transformations. You need to connect the model to the tables in Production1. The solution must maintain the existing transformations. Solution: From Query Editor, you configure the Data source settings. Does this meet the goal?
A. Yes
B. No
Discussion forum
Question
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have two Microsoft SQL Server database servers named Production1 and Test1. Production1 contains the same tables as Test1, but only a subset of the data. You add Test1 as a data source, and you select 10 tables. You configure several transformations. You need to connect the model to the tables in Production1. The solution must maintain the existing transformations. Solution: From Query Editor, you configure the Data source settings. Does this meet the goal?
A. Yes
B. No
Discussion forum
Question
You add two tables named Date and Invoices to a data model. Invoices contains a column named InvoiceDate that has a data Type of Date. Date contains a column named DateID that has a Data Type of Whole Number. DateID is in the format of YYYYMMDD. You need to create a relationship between Date and Invoices. What should you do first?
A. Change the Data Type of InvoiceDate and DateID to Text
B. Create a calculated column in Invoices that uses the FORMAT DAX function
C. Change the Data Type of DateID to Date
D. Create a measure in Invoices that uses the FORMAT DAX function
Discussion forum
Question
You have a table in a Power Pivot model that is loaded from a Microsoft SQL Server database. The source table has four columns named ID, Price, Quantity, and Total. Total is derived by multiplying Price and Quantity. ID is a unique row identifier. You need to minimize the amount of memory used to load the model. The solution must ensure that you can create visualizations based on Price, Quantity, and Total. What should you do?
A. Replace the Total column by using a measure
B. Replace the Total column by using a calculated column
C. From Query Editor, remove duplicate rows from the table
D. Move the Total column to a lookup table
Discussion forum
Question
You have a table in a Power Pivot model that is loaded from a Microsoft SQL Server database. The source table has four columns named ID, Price, Quantity, and Total. Total is derived by multiplying Price and Quantity. ID is a unique row identifier. You need to minimize the amount of memory used to load the model. The solution must ensure that you can create visualizations based on Price, Quantity, and Total. What should you do?
A. Replace the Total column by using a measure
B. Replace the Total column by using a calculated column
C. From Query Editor, remove duplicate rows from the table
D. Move the Total column to a lookup table
Discussion forum
Question
You have an Excel workbook query that loads data to a worksheet and the data model. You need to ensure that the data is refreshed whenever you open the workbook. What should you do?
A. From the File tab, click Options, and then modify the General options
B. From the Power Pivot model, modify the Table Behavior setting
C. From the File tab, click Options, and then modify the Data options
D. Run the Data tab, click Queries & Connections, and then edit the properties of the query
Discussion forum
Question
You create an Excel workbook named SalesResults.xlsx. You create a workbook query that connects to a Microsoft SQL Server database and loads data to the data model. You create a PivotTable and a PivotChart. You plan to share SalesResult.xlsx to several users outside of your organization. You need to ensure that the users can see the PivotTable and the PivotChart when they open the file. The data in the model must be removed. What should you do?
A. Modify the source of the query
B. Save the workbook as an Excel Binary Workbook (.xlsb)
C. From Query Editor, open the Data Source and delete the credentials
D. Run the Document Inspector
Discussion forum
Question
You have multiple workbook queries that load data from tables in Microsoft Azure SQL Database to a Power Pivot data model. You discover that new rows were added to the tables in Azure SQL Database. You need to ensure that the workbook has the new data. What should you do?
A. From the Data tab, click Refresh All
B. From the Power Pivot tab, click Update All
C. Close and open the workbook
D. Select a cell in the worksheet and press F5
Discussion forum
Question
You have 20 workbook queries that load 20 CSV files to a local computer. You plan to send the workbook and the 20 CSV files to several users. The users will store the files in various locations. You need to ensure that the users can change the path to the CSV files in the queries as quickly as possible. What should you do from Query Editor?
A. Append all the queries. Edit the source of the first query
B. Merge all the queries. Edit the source of the first query
C. For each query, create a new query that uses a reference. Modify the source of each new query
D. Create a parameter. Modify the source of each query to use the parameter
Discussion forum
Question
You have an Excel workbook that has the following two workbook queries: ✑ A query named Consultants that retrieves a table named Consultants_Contact from a Microsoft SQL Server database A query named Employees that retrieves a table named Employee_Contact from a Microsoft Azure SQL database Both tables have the same columns. You need to combine all the data from Consultants and Employees into one table. Which command should you use?
A. Append Queries
B. Combine Binaries
C. Transpose
D. Merge Queries
Discussion forum
Question
You open C:\Data\Data.xlsx in Excel. When you attempt to publish the file to Microsoft Power BI, you receive the following error message: “We couldn’t publish to Power BI. Make sure your workbook is saved as an Excel file (.xlsx or .xlsm) and is not password protected.” You need to ensure that you can publish the file to Power BI. What should you do first?
A. Decrypt the workbook
B. Copy the file to a network share
C. Add a digital signature to the workbook
D. Disable iterative calculation for the workbook
Discussion forum
Question
You have an Excel workbook that contains two tables named User and Activity. You plan to publish the workbook to the Power BI service. Users will use Q&A in the Power BI service to perform natural language queries. You need to ensure that the users can query the term employee and receive results from the User table. What should you do before you publish to Power BI?
A. From PowerPivot Settings, modify the Language options
B. From PowerPivot Settings, modify the Categorization options
C. From the Power Pivot model, edit the Synonyms
D. From Workbook Connections, add a connection
Discussion forum
Question