1 / 8

2018 CertQueen Microsoft 70-779 Exam Dumps

Microsoft certification 70-779 exam dumps are available at CertQueen, which can guarantee you success in the first attempt.

wirygnrhd
Download Presentation

2018 CertQueen Microsoft 70-779 Exam Dumps

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. www.certqueen.com Full version: 101 Q&As https://www.certqueen.com/70-779.html Share Microsoft 70-779 Questions and Answers Below. 1.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.Why should you do? A. Select a cell in the worksheet and pressF5. B. From the data tab, click Refresh All. C. Close and open the workbook. D. From the Power Pivot tab, click Update All. Answer: B Get full 70-779 Exam Version: https://www.certqueen.com/70-779.html

  2. www.certqueen.com 2.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 Option, and then modify the Data option. B. From the File tab, click Options, and then modify the General options. C. From the Data tab, click Queries & Connections, and then edit the properties of the query. D. From the Power Pivot model, modify the Table Behavior setting. Answer: C 3.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 Get full 70-779 Exam Version: https://www.certqueen.com/70-779.html

  3. www.certqueen.com 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. Transpose B. Append Queries C. Merge Queries D. Combine Binaries Answer: B 4.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 location.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. Merge all the queries. Edit the source of the first query. B. Create a parameter. Modify the source of each query to use the parameter. C. For each query, create a new query that uses a reference. Modify the source of each new query. Get full 70-779 Exam Version: https://www.certqueen.com/70-779.html

  4. www.certqueen.com D. Append all the queries. Edit the source of the first query. Answer: B 5.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 PivotChart.You plane to share SalesResults.slsx 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.From Query Editor, open the Data Source Setting and delete the credentials. C. Run the Document inspector. D. Save the workbook as an Excel Binary Workbook (xlsx) Answer: A 6.Your network contains a folder that has data files m various formats.You need to identify how many files of each Get full 70-779 Exam Version: https://www.certqueen.com/70-779.html

  5. www.certqueen.com extension type are in the folder by using Query Editor.What should you do? A. Create a query that uses a file source, and then use the Count Values command on the Transform tab. B. Create a query that uses a folder source, and then use the Group By command on the Home tab. C. Create a query that uses a file source, and then use the Group By command on the Home tab. D. Create a query that uses a folder source, and then use the Count Values command on the Transform tab. Answer: B 7.You have a data model in Excel.You export the data and the data model into a dataset in the Microsoft Power BI service.What can you use to modify the data model that is published to the Power BI service? A. Microsoft Power BI Desktop B. Excel and the Microsoft Power BI service C. Excel only D. the Microsoft Power BI service only Get full 70-779 Exam Version: https://www.certqueen.com/70-779.html

  6. www.certqueen.com Answer: A 8.You have a KPI named Goal that calculates the sales from the previous year and multiplies the sales by 1.1.You need to modify Goal to multiply the sales from the previous year by 1.15.What should you do? A. From Power Pivot, modify the measure. B. From the properties of the KPI, modify the KPI base field. C. From Power Pivot, create a new calculated column, and then modify the KPI. D. From the properties of the KPI, modify the absolute value. Answer: A 9.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 which 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. Get full 70-779 Exam Version: https://www.certqueen.com/70-779.html

  7. www.certqueen.com B. Create a measure in Invoices that uses the Format DAX Function. C. Change the Data Type of DateID to Date. D. Create a calculated column in Invoices that uses the Format DAX function. Answer: C 10.You have a table in 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 mode. 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. Get full 70-779 Exam Version: https://www.certqueen.com/70-779.html

  8. www.certqueen.com Answer: B Get full 70-779 Exam Version: https://www.certqueen.com/70-779.html

More Related