{"id":4606,"date":"2019-11-11T08:06:24","date_gmt":"2019-11-11T08:06:24","guid":{"rendered":"https:\/\/www.dumpsbase.com\/freedumps\/?p=4606"},"modified":"2019-11-11T08:06:28","modified_gmt":"2019-11-11T08:06:28","slug":"updated-microsoft-excel-70-779-practice-exam-questions-v9-02","status":"publish","type":"post","link":"https:\/\/www.dumpsbase.com\/freedumps\/updated-microsoft-excel-70-779-practice-exam-questions-v9-02.html","title":{"rendered":"Updated Microsoft Excel 70-779 Practice Exam Questions V9.02"},"content":{"rendered":"\n<p>Latest 70-779 Analyzing and Visualizing Data with Microsoft Excel exam questions are released. Updated Microsoft Excel 70-779 Practice Exam Questions V9.02 come with 101 real exam questions and answers to ensure that you can pass Microsoft 70-779 exam smoothly. If you&#8217;re totally prepared in taking Microsoft 70-779 test, then you must get the most updated\u00a0Microsoft Excel 70-779 Practice Exam Questions for the good results inside Analyzing and Visualizing Data with Microsoft Excel 70-779 test.\u00a0<\/p>\n<h2>Recommend to <span style=\"color: #339966;\">Check 70-779 Free Dumps<\/span> Online First<\/h2>\n<script>\n  window.fbAsyncInit = function() {\n    FB.init({\n      appId            : '622169541470367',\n      autoLogAppEvents : true,\n      xfbml            : true,\n      version          : 'v3.1'\n    });\n  };\n\n  (function(d, s, id){\n     var js, fjs = d.getElementsByTagName(s)[0];\n     if (d.getElementById(id)) {return;}\n     js = d.createElement(s); js.id = id;\n     js.src = \"https:\/\/connect.facebook.net\/en_US\/sdk.js\";\n     fjs.parentNode.insertBefore(js, fjs);\n   }(document, 'script', 'facebook-jssdk'));\n<\/script><div id=\"watu_quiz\" class=\"quiz-area single-page-quiz\">\n<p><\/p><form action=\"\" method=\"post\" class=\"quiz-form \" id=\"quiz-2008\" >\n<div class='watu-question' id='question-1'><div class='question-content'><p><span class='watu_num'>1. <\/span>Your company has sales offices in several cities.<br \/>\n<br \/>You create a table that represents the amount of sales in each city by month as shown in the exhibit. <\/p>\n<p><img decoding=\"async\" width=502 height=186 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V9.files\/image002.jpg\" v:shapes=\"Picture_x0020_1\"><\/p>\n<p>You need to ensure that all values lower than 250 display a red icon. The solution must ensure that all values greater than 500 display a green icon.<br \/>\n<br \/>Solution: You create a measure, and then define a target value.<br \/>\n<br \/>Does this meet the goal?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='115471' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476240' \/><div class='watu-question-choice'><input type='radio' name='answer-115471[]' id='answer-id-476240' class='answer answer-1  answerof-115471' value='476240' \/>&nbsp;<label for='answer-id-476240' id='answer-label-476240' class=' answer label-1'><span class='answer'>Yes<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476241' \/><div class='watu-question-choice'><input type='radio' name='answer-115471[]' id='answer-id-476241' class='answer answer-1  answerof-115471' value='476241' \/>&nbsp;<label for='answer-id-476241' id='answer-label-476241' class=' answer label-1'><span class='answer'>No<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType1' value='radio' class=''><\/div><div class='watu-question' id='question-2'><div class='question-content'><p><span class='watu_num'>2. <\/span>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.<br \/>\n<br \/>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.<br \/>\n<br \/>Your company has sales offices in several cities.<br \/>\n<br \/>You create a table that the represents the amount of sales in each city by month as shown in the exhibit. <\/p>\n<p><img decoding=\"async\" width=511 height=189 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V9.files\/image004.jpg\" v:shapes=\"Picture_x0020_2\"><\/p>\n<p>You need to ensure that alt values lower than 250 display a red icon. The solution must ensure that all values greater than 500 display a green icon.<br \/>\n<br \/>Solution: You create a new conditional formatting rule that uses the Format only cells that contain rule type.<br \/>\n<br \/>Does this meet the goal?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='115472' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476242' \/><div class='watu-question-choice'><input type='radio' name='answer-115472[]' id='answer-id-476242' class='answer answer-2  answerof-115472' value='476242' \/>&nbsp;<label for='answer-id-476242' id='answer-label-476242' class=' answer label-2'><span class='answer'>Yes<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476243' \/><div class='watu-question-choice'><input type='radio' name='answer-115472[]' id='answer-id-476243' class='answer answer-2  answerof-115472' value='476243' \/>&nbsp;<label for='answer-id-476243' id='answer-label-476243' class=' answer label-2'><span class='answer'>No<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType2' value='radio' class=''><\/div><div class='watu-question' id='question-3'><div class='question-content'><p><span class='watu_num'>3. <\/span>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.<br \/>\n<br \/>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.<br \/>\n<br \/>Your company has sales offices in several cities.<br \/>\n<br \/>You create a table that represents the amount of sales in each city by month as shown in the exhibit. <\/p>\n<p><img decoding=\"async\" width=517 height=199 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V9.files\/image006.jpg\" v:shapes=\"Picture_x0020_3\"><\/p>\n<p>You need to ensure that all values lower than 250 display a red icon. The solution must ensure that all values greater than 500 display a green icon.<br \/>\n<br \/>Solution: You modify the conditional formatting rule, and then set a new value for the yellow icon.<br \/>\n<br \/>Does this meet the goal?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='115473' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476244' \/><div class='watu-question-choice'><input type='radio' name='answer-115473[]' id='answer-id-476244' class='answer answer-3  answerof-115473' value='476244' \/>&nbsp;<label for='answer-id-476244' id='answer-label-476244' class=' answer label-3'><span class='answer'>Yes<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476245' \/><div class='watu-question-choice'><input type='radio' name='answer-115473[]' id='answer-id-476245' class='answer answer-3  answerof-115473' value='476245' \/>&nbsp;<label for='answer-id-476245' id='answer-label-476245' class=' answer label-3'><span class='answer'>No<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType3' value='radio' class=''><\/div><div class='watu-question' id='question-4'><div class='question-content'><p><span class='watu_num'>4. <\/span>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.<br \/>\n<br \/>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.<br \/>\n<br \/>You have the following data. <\/p>\n<p><img decoding=\"async\" width=520 height=140 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V9.files\/image008.jpg\" v:shapes=\"Picture_x0020_4\"><\/p>\n<p>You need to retrieve a list of the unique ProductName entries.<br \/>\n<br \/>Solution: Open the Advanced Filter dialog box, select Filter the list, in-place, and then select Unique records only.<br \/>\n<br \/>Does this meet the goal?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='115474' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476246' \/><div class='watu-question-choice'><input type='radio' name='answer-115474[]' id='answer-id-476246' class='answer answer-4  answerof-115474' value='476246' \/>&nbsp;<label for='answer-id-476246' id='answer-label-476246' class=' answer label-4'><span class='answer'>Yes<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476247' \/><div class='watu-question-choice'><input type='radio' name='answer-115474[]' id='answer-id-476247' class='answer answer-4  answerof-115474' value='476247' \/>&nbsp;<label for='answer-id-476247' id='answer-label-476247' class=' answer label-4'><span class='answer'>No<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType4' value='radio' class=''><\/div><div class='watu-question' id='question-5'><div class='question-content'><p><span class='watu_num'>5. <\/span>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.<br \/>\n<br \/>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.<br \/>\n<br \/>You have the following data. <\/p>\n<p><img decoding=\"async\" width=488 height=131 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V9.files\/image009.jpg\" v:shapes=\"Picture_x0020_5\"><\/p>\n<p>You need to retrieve a list of the unique ProductName entries.<br \/>\n<br \/>Solution: Create a PivotTable that uses the ProductName field in the Values area.<br \/>\n<br \/>Does this meet the goal?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='115475' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476248' \/><div class='watu-question-choice'><input type='radio' name='answer-115475[]' id='answer-id-476248' class='answer answer-5  answerof-115475' value='476248' \/>&nbsp;<label for='answer-id-476248' id='answer-label-476248' class=' answer label-5'><span class='answer'>Yes<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476249' \/><div class='watu-question-choice'><input type='radio' name='answer-115475[]' id='answer-id-476249' class='answer answer-5  answerof-115475' value='476249' \/>&nbsp;<label for='answer-id-476249' id='answer-label-476249' class=' answer label-5'><span class='answer'>No<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType5' value='radio' class=''><\/div><div class='watu-question' id='question-6'><div class='question-content'><p><span class='watu_num'>6. <\/span>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.<br \/>\n<br \/>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.<br \/>\n<br \/>You have the following data. <\/p>\n<p><img decoding=\"async\" width=494 height=133 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V9.files\/image010.jpg\" v:shapes=\"Picture_x0020_6\"><\/p>\n<p>You need to retrieve a list of the unique ProductName entries.<br \/>\n<br \/>Select the ProductName column, and then click Group on the Data tab.<br \/>\n<br \/>Does this meet the goal?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='115476' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476250' \/><div class='watu-question-choice'><input type='radio' name='answer-115476[]' id='answer-id-476250' class='answer answer-6  answerof-115476' value='476250' \/>&nbsp;<label for='answer-id-476250' id='answer-label-476250' class=' answer label-6'><span class='answer'>Yes<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476251' \/><div class='watu-question-choice'><input type='radio' name='answer-115476[]' id='answer-id-476251' class='answer answer-6  answerof-115476' value='476251' \/>&nbsp;<label for='answer-id-476251' id='answer-label-476251' class=' answer label-6'><span class='answer'>No<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType6' value='radio' class=''><\/div><div class='watu-question' id='question-7'><div class='question-content'><p><span class='watu_num'>7. <\/span>Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer chokes, but the text of the scenario is the same in each question in this series.<br \/>\n<br \/>Start of repeated scenario<br \/>\n<br \/>You are creating reports for a car repair company. You have four datasets in Excel spreadsheets. Four workbook queries load the datasets to a data model. A sample of the data is shown in the Data Sample exhibit.<br \/>\n<br \/>Data Sample: <\/p>\n<p><img decoding=\"async\" width=506 height=287 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V9.files\/image012.jpg\" v:shapes=\"Picture_x0020_8\"><\/p>\n<p>The data model is shown in the Data Model exhibit.<br \/>\n<br \/>Data Model: <\/p>\n<p><img decoding=\"async\" width=511 height=266 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V9.files\/image014.jpg\" v:shapes=\"Picture_x0020_9\"><\/p>\n<\/div><input type='hidden' name='question_id[]' value='115477' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476252' \/><div class='watu-question-choice'><input type='radio' name='answer-115477[]' id='answer-id-476252' class='answer answer-7  answerof-115477' value='476252' \/>&nbsp;<label for='answer-id-476252' id='answer-label-476252' class=' answer label-7'><span class='answer'>In the workbook query for Workshops, filter [IsLatest] to equal 1.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476253' \/><div class='watu-question-choice'><input type='radio' name='answer-115477[]' id='answer-id-476253' class='answer answer-7  answerof-115477' value='476253' \/>&nbsp;<label for='answer-id-476253' id='answer-label-476253' class=' answer label-7'><span class='answer'>In the workbook query for Workshops, add an index column.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476254' \/><div class='watu-question-choice'><input type='radio' name='answer-115477[]' id='answer-id-476254' class='answer answer-7  answerof-115477' value='476254' \/>&nbsp;<label for='answer-id-476254' id='answer-label-476254' class=' answer label-7'><span class='answer'>In the Power Pivot model, change the data type for Workshop[lD] to General.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476255' \/><div class='watu-question-choice'><input type='radio' name='answer-115477[]' id='answer-id-476255' class='answer answer-7  answerof-115477' value='476255' \/>&nbsp;<label for='answer-id-476255' id='answer-label-476255' class=' answer label-7'><span class='answer'>In the Power Pivot model, change the Table Behavior setting for Workshops.<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType7' value='radio' class=''><\/div><div class='watu-question' id='question-8'><div class='question-content'><p><span class='watu_num'>8. <\/span>DRAG DROP<br \/>\n<br \/>Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is the same in each question in this series.<br \/>\n<br \/>Start of repeated scenario<br \/>\n<br \/>You are creating reports for a car repair company. You have four datasets in Excel spreadsheets. Pour workbook queries load the datasets to a data model. A sample of the data is shown in the Data Sample exhibit.<br \/>\n<br \/>Data Sample: <\/p>\n<p><img decoding=\"async\" width=443 height=250 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V9.files\/image015.jpg\" v:shapes=\"Picture_x0020_12\"><\/p>\n<p>The data model is shown in the Data Model exhibit.<br \/>\n<br \/>Data Model <\/p>\n<p><img decoding=\"async\" width=457 height=240 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V9.files\/image017.jpg\" v:shapes=\"Picture_x0020_13\"><\/p>\n<p>The tables in the model contain the following data:<br \/>\n<br \/>DailyRepairs has a log of hours and revenue for each day, workshop, and repair type. Every day, a log entry is created for each workshop, even if no hours or revenue are recorded for that day. Total Hours and Total Revenue are two measures denned in DailyRepairs. Total Hours sums the Hours column, and Total Revenue sums the Revenue column.<br \/>\n<br \/>Workshops has a list of all the workshops and the current and previous workshop managers. The format of the Workshop Manager column is always FirstnameLastname. A value of 1 in the IsLatest column indicates that the workshop manager listed in the record is the current workshop manager.<br \/>\n<br \/>RepairTypes has a list of all the repair types.<br \/>\n<br \/>Dates has a list of dates from 2015 to 2018.<br \/>\n<br \/>End of repeated scenario.<br \/>\n<br \/>You need to create a PivotChart that displays the month, the hours of the month, and the hours of the previous month, as shown in the following exhibit. <\/p>\n<p><img decoding=\"async\" width=394 height=170 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V9.files\/image018.jpg\" v:shapes=\"Picture_x0020_10\"><\/p>\n<p>Which DAX formula should you use for the Total Hours Last Month measure? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.<br \/>\n<br \/>NOTE: Each correct selection is worth one point. <\/p>\n<p><img decoding=\"async\" width=453 height=105 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V9.files\/image020.jpg\" v:shapes=\"Picture_x0020_11\"><\/p>\n<\/div><input type='hidden' name='question_id[]' value='115478' \/><textarea name='answer-115478[]' rows='5' cols='40' id='textarea_q_115478' class='watu-textarea watu-textarea-8'><\/textarea><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476256' \/><\/div><input type='hidden' id='questionType8' value='textarea' class=''><\/div><div class='watu-question' id='question-9'><div class='question-content'><p><span class='watu_num'>9. <\/span>HOTSPOT<br \/>\n<br \/>Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is the same in each question in this series.<br \/>\n<br \/>Start of repeated scenario<br \/>\n<br \/>You are creating reports for a car repair company. You have four datasets in Excel spreadsheets. Pour workbook queries load the datasets to a data model. A sample of the data is shown in the Data Sample exhibit.<br \/>\n<br \/>Data Sample: <\/p>\n<p><img decoding=\"async\" width=426 height=242 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V9.files\/image024.jpg\" v:shapes=\"Picture_x0020_14\"><\/p>\n<p>The data model is shown in the Data Model exhibit.<br \/>\n<br \/>Data Model <\/p>\n<p><img decoding=\"async\" width=424 height=222 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V9.files\/image025.jpg\" v:shapes=\"Picture_x0020_15\"><\/p>\n<p>The tables in the model contain the following data:<br \/>\n<br \/>DailyRepairs has a log of hours and revenue for each day, workshop, and repair type. Every day, a log entry is created for each workshop, even if no hours or revenue are recorded for that day. Total Hours and Total Revenue are two measures denned in DailyRepairs. Total Hours sums the Hours column, and Total Revenue sums the Revenue column.<br \/>\n<br \/>Workshops has a list of all the workshops and the current and previous workshop managers. The format of the Workshop Manager column is always FirstnameLastname. A value of 1 in the IsLatest column indicates that the workshop manager listed in the record is the current workshop manager.<br \/>\n<br \/>RepairTypes has a list of all the repair types.<br \/>\n<br \/>Dates has a list of dates from 2015 to 2018.<br \/>\n<br \/>End of repeated scenario.<br \/>\n<br \/>To the Dates table, you need to add a calculated column named Months Ago. Months Ago must display the number of calendar months before the current month. For example, if the current date is July 10, 2017, the value of Months Ago will be 0 for all the dates in July 2017,1 for all the dates in June 2017, and 2 for all the dates in May 2017.<br \/>\n<br \/>How should you complete the DAX formula? To answer, select the appropriate options in the answer area.<br \/>\n<br \/>NOTE: Each correct selection is worth one point. <\/p>\n<p><img decoding=\"async\" width=782 height=130 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V9.files\/image027.gif\" v:shapes=\"Picture_x0020_134\"><\/p>\n<\/div><input type='hidden' name='question_id[]' value='115479' \/><textarea name='answer-115479[]' rows='5' cols='40' id='textarea_q_115479' class='watu-textarea watu-textarea-9'><\/textarea><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476257' \/><\/div><input type='hidden' id='questionType9' value='textarea' class=''><\/div><div class='watu-question' id='question-10'><div class='question-content'><p><span class='watu_num'>10. <\/span>Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is the same in each question in this series.<br \/>\n<br \/>Start of repeated scenario<br \/>\n<br \/>You are creating reports for a car repair company. You have four datasets in Excel spreadsheets. Pour workbook queries load the datasets to a data model. A sample of the data is shown in the Data Sample exhibit.<br \/>\n<br \/>Data Sample: <\/p>\n<p><img decoding=\"async\" width=495 height=280 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V9.files\/image028.jpg\" v:shapes=\"Picture_x0020_18\"><\/p>\n<p>The data model is shown in the Data Model exhibit.<br \/>\n<br \/>Data Model <\/p>\n<p><img decoding=\"async\" width=459 height=241 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V9.files\/image029.jpg\" v:shapes=\"Picture_x0020_19\"><\/p>\n<p>The tables in the model contain the following data:<br \/>\n<br \/>DailyRepairs has a log of hours and revenue for each day, workshop, and repair type. Every day, a log entry is created for each workshop, even if no hours or revenue are recorded for that day. Total Hours and Total Revenue are two measures denned in DailyRepairs. Total Hours sums the Hours column, and Total Revenue sums the Revenue column.<br \/>\n<br \/>Workshops has a list of all the workshops and the current and previous workshop managers. The format of the Workshop Manager column is always FirstnameLastname. A value of 1 in the IsLatest column indicates that the workshop manager listed in the record is the current workshop manager.<br \/>\n<br \/>RepairTypes has a list of all the repair types.<br \/>\n<br \/>Dates has a list of dates from 2015 to 2018.<br \/>\n<br \/>End of repeated scenario.<br \/>\n<br \/>You create a measure named Average Revenue Per Hour that average revenue per hour.<br \/>\n<br \/>You need to populate a cell in a worksheet to display the Average Revenue Per Hour where Repair Type is Engine.<br \/>\n<br \/>Which Excel formula should you use? <\/p>\n<p><img decoding=\"async\" width=490 height=161 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V9.files\/image031.jpg\" v:shapes=\"Picture_x0020_17\"><\/p>\n<\/div><input type='hidden' name='question_id[]' value='115480' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476258' \/><div class='watu-question-choice'><input type='radio' name='answer-115480[]' id='answer-id-476258' class='answer answer-10  answerof-115480' value='476258' \/>&nbsp;<label for='answer-id-476258' id='answer-label-476258' class=' answer label-10'><span class='answer'>Option A<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476259' \/><div class='watu-question-choice'><input type='radio' name='answer-115480[]' id='answer-id-476259' class='answer answer-10  answerof-115480' value='476259' \/>&nbsp;<label for='answer-id-476259' id='answer-label-476259' class=' answer label-10'><span class='answer'>Option B<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476260' \/><div class='watu-question-choice'><input type='radio' name='answer-115480[]' id='answer-id-476260' class='answer answer-10  answerof-115480' value='476260' \/>&nbsp;<label for='answer-id-476260' id='answer-label-476260' class=' answer label-10'><span class='answer'>Option C<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476261' \/><div class='watu-question-choice'><input type='radio' name='answer-115480[]' id='answer-id-476261' class='answer answer-10  answerof-115480' value='476261' \/>&nbsp;<label for='answer-id-476261' id='answer-label-476261' class=' answer label-10'><span class='answer'>Option D<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType10' value='radio' class=''><\/div><div class='watu-question' id='question-11'><div class='question-content'><p><span class='watu_num'>11. <\/span>DRAG DROP<br \/>\n<br \/>You merge several CVS files by using Query Editor.<br \/>\n<br \/>You need to remove all the leading whitespaces and all the non-printable characters from a column.<br \/>\n<br \/>What should you do to achieve each task? To answer, drag the appropriate actions to the correct goals. Each action may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.<br \/>\n<br \/>NOTE: Each correct selection is worth one point. <\/p>\n<p><img decoding=\"async\" width=524 height=154 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V9.files\/image033.jpg\" v:shapes=\"Picture_x0020_20\"><\/p>\n<\/div><input type='hidden' name='question_id[]' value='115481' \/><textarea name='answer-115481[]' rows='5' cols='40' id='textarea_q_115481' class='watu-textarea watu-textarea-11'><\/textarea><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476262' \/><\/div><input type='hidden' id='questionType11' value='textarea' class=''><\/div><div class='watu-question' id='question-12'><div class='question-content'><p><span class='watu_num'>12. <\/span>You have the Excel worksheet shown in the exhibit. <\/p>\n<p><img decoding=\"async\" width=462 height=362 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V9.files\/image037.jpg\" v:shapes=\"Picture_x0020_21\"><\/p>\n<p>You need to transform the data by using Query Editor.<br \/>\n<br \/>What should you do first?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='115482' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476263' \/><div class='watu-question-choice'><input type='radio' name='answer-115482[]' id='answer-id-476263' class='answer answer-12  answerof-115482' value='476263' \/>&nbsp;<label for='answer-id-476263' id='answer-label-476263' class=' answer label-12'><span class='answer'>From the Data tab, Click From Table\/Range.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476264' \/><div class='watu-question-choice'><input type='radio' name='answer-115482[]' id='answer-id-476264' class='answer answer-12  answerof-115482' value='476264' \/>&nbsp;<label for='answer-id-476264' id='answer-label-476264' class=' answer label-12'><span class='answer'>From the Insert tab, Click Store.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476265' \/><div class='watu-question-choice'><input type='radio' name='answer-115482[]' id='answer-id-476265' class='answer answer-12  answerof-115482' value='476265' \/>&nbsp;<label for='answer-id-476265' id='answer-label-476265' class=' answer label-12'><span class='answer'>From the Data tab, Click Flash Fill.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476266' \/><div class='watu-question-choice'><input type='radio' name='answer-115482[]' id='answer-id-476266' class='answer answer-12  answerof-115482' value='476266' \/>&nbsp;<label for='answer-id-476266' id='answer-label-476266' class=' answer label-12'><span class='answer'>From the Data tab, Click Consolidate.<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType12' value='radio' class=''><\/div><div class='watu-question' id='question-13'><div class='question-content'><p><span class='watu_num'>13. <\/span>HOTSPOT<br \/>\n<br \/>You have a workbook query that uses an Excel data source. The data source contains the following table. <\/p>\n<p><img decoding=\"async\" border=0 width=466 height=118 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V9.files\/image039.jpg\" v:shapes=\"Picture_x0020_22\"><\/p>\n<p>You need the data to appear as shown in the following table. <\/p>\n<p><img decoding=\"async\" border=0 width=239 height=312 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V9.files\/image041.jpg\" v:shapes=\"Picture_x0020_23\"><\/p>\n<p>How should you transform the data from Query Editor? To answer, select the appropriate options in the answer area.<br \/>\n<br \/>NOTE: Each correct selection is worth one point. <\/p>\n<p><img decoding=\"async\" border=0 width=538 height=283 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V9.files\/image043.gif\" v:shapes=\"Picture_x0020_136\"><\/p>\n<\/div><input type='hidden' name='question_id[]' value='115483' \/><textarea name='answer-115483[]' rows='5' cols='40' id='textarea_q_115483' class='watu-textarea watu-textarea-13'><\/textarea><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476267' \/><\/div><input type='hidden' id='questionType13' value='textarea' class=''><\/div><div class='watu-question' id='question-14'><div class='question-content'><p><span class='watu_num'>14. <\/span>You have multiple workbook queries that load data from tables in Microsoft Azure SQL Database to a Power Pivot data model.<br \/>\n<br \/>You discover that new rows were added to the tables in Azure SQL Database.<br \/>\n<br \/>You need to ensure that the workbook has the new data.<br \/>\n<br \/>Why should you do?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='115484' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476268' \/><div class='watu-question-choice'><input type='radio' name='answer-115484[]' id='answer-id-476268' class='answer answer-14  answerof-115484' value='476268' \/>&nbsp;<label for='answer-id-476268' id='answer-label-476268' class=' answer label-14'><span class='answer'>Select a cell in the worksheet and pressF5.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476269' \/><div class='watu-question-choice'><input type='radio' name='answer-115484[]' id='answer-id-476269' class='answer answer-14  answerof-115484' value='476269' \/>&nbsp;<label for='answer-id-476269' id='answer-label-476269' class=' answer label-14'><span class='answer'>From the data tab, click Refresh All.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476270' \/><div class='watu-question-choice'><input type='radio' name='answer-115484[]' id='answer-id-476270' class='answer answer-14  answerof-115484' value='476270' \/>&nbsp;<label for='answer-id-476270' id='answer-label-476270' class=' answer label-14'><span class='answer'>Close and open the workbook.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476271' \/><div class='watu-question-choice'><input type='radio' name='answer-115484[]' id='answer-id-476271' class='answer answer-14  answerof-115484' value='476271' \/>&nbsp;<label for='answer-id-476271' id='answer-label-476271' class=' answer label-14'><span class='answer'>From the Power Pivot tab, click Update All.<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType14' value='radio' class=''><\/div><div class='watu-question' id='question-15'><div class='question-content'><p><span class='watu_num'>15. <\/span>DRAG DROP<br \/>\n<br \/>You use a workbook query to import a table named Customers that contains a column named CustomerName. Has names in the format of Lastname, Firstname.<br \/>\n<br \/>You need the CustomerName column to contain names in the format of FirstnameLastname. A space must separate Firstname and lastname.<br \/>\n<br \/>Which two commands should you use? To answer, drag the appropriate commands to the correct targets. Each command may be used once, more than once, or not at all. You may need to frag the split bar between panes or scroll to view content.<br \/>\n<br \/>NOTE: Each correct selection is worth one point. <\/p>\n<p><img decoding=\"async\" border=0 width=624 height=166 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V9.files\/image049.jpg\" v:shapes=\"Picture_x0020_25\"><\/p>\n<\/div><input type='hidden' name='question_id[]' value='115485' \/><textarea name='answer-115485[]' rows='5' cols='40' id='textarea_q_115485' class='watu-textarea watu-textarea-15'><\/textarea><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476272' \/><\/div><input type='hidden' id='questionType15' value='textarea' class=''><\/div><div class='watu-question' id='question-16'><div class='question-content'><p><span class='watu_num'>16. <\/span>You have an Excel workbook query that loads data to a worksheet and the data model.<br \/>\n<br \/>You need to ensure that the data is refreshed whenever you open the workbook.<br \/>\n<br \/>What should you do?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='115486' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476273' \/><div class='watu-question-choice'><input type='radio' name='answer-115486[]' id='answer-id-476273' class='answer answer-16  answerof-115486' value='476273' \/>&nbsp;<label for='answer-id-476273' id='answer-label-476273' class=' answer label-16'><span class='answer'>From the File tab, click Option, and then modify the Data option.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476274' \/><div class='watu-question-choice'><input type='radio' name='answer-115486[]' id='answer-id-476274' class='answer answer-16  answerof-115486' value='476274' \/>&nbsp;<label for='answer-id-476274' id='answer-label-476274' class=' answer label-16'><span class='answer'>From the File tab, click Options, and then modify the General options.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476275' \/><div class='watu-question-choice'><input type='radio' name='answer-115486[]' id='answer-id-476275' class='answer answer-16  answerof-115486' value='476275' \/>&nbsp;<label for='answer-id-476275' id='answer-label-476275' class=' answer label-16'><span class='answer'>From the Data tab, click Queries &amp; Connections, and then edit the properties of the query.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476276' \/><div class='watu-question-choice'><input type='radio' name='answer-115486[]' id='answer-id-476276' class='answer answer-16  answerof-115486' value='476276' \/>&nbsp;<label for='answer-id-476276' id='answer-label-476276' class=' answer label-16'><span class='answer'>From the Power Pivot model, modify the Table Behavior setting.<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType16' value='radio' class=''><\/div><div class='watu-question' id='question-17'><div class='question-content'><p><span class='watu_num'>17. <\/span>You have an Excel workbook that has the following two workbook queries:<br \/>\n<br \/>A query named consultants that retrieves a table named Consultants_Contact from a Microsoft SQL Server database<br \/>\n<br \/>A query named employees that retrieves a table named Employee_Contact from a Microsoft Azure SQL database<br \/>\n<br \/>Both tables have the same columns.<br \/>\n<br \/>You need to combine all the data from Consultants and Employees into one table.<br \/>\n<br \/>Which command should you use?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='115487' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476277' \/><div class='watu-question-choice'><input type='radio' name='answer-115487[]' id='answer-id-476277' class='answer answer-17  answerof-115487' value='476277' \/>&nbsp;<label for='answer-id-476277' id='answer-label-476277' class=' answer label-17'><span class='answer'>Transpose<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476278' \/><div class='watu-question-choice'><input type='radio' name='answer-115487[]' id='answer-id-476278' class='answer answer-17  answerof-115487' value='476278' \/>&nbsp;<label for='answer-id-476278' id='answer-label-476278' class=' answer label-17'><span class='answer'>Append Queries<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476279' \/><div class='watu-question-choice'><input type='radio' name='answer-115487[]' id='answer-id-476279' class='answer answer-17  answerof-115487' value='476279' \/>&nbsp;<label for='answer-id-476279' id='answer-label-476279' class=' answer label-17'><span class='answer'>Merge Queries<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476280' \/><div class='watu-question-choice'><input type='radio' name='answer-115487[]' id='answer-id-476280' class='answer answer-17  answerof-115487' value='476280' \/>&nbsp;<label for='answer-id-476280' id='answer-label-476280' class=' answer label-17'><span class='answer'>Combine Binaries<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType17' value='radio' class=''><\/div><div class='watu-question' id='question-18'><div class='question-content'><p><span class='watu_num'>18. <\/span>You have two queries named client and invoice. A sample of Client is shown in the following table. <\/p>\n<p><img decoding=\"async\" border=0 width=241 height=107 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V9.files\/image052.jpg\" v:shapes=\"Picture_x0020_26\"><\/p>\n<p>A sample of Invoices is shown in the following table. <\/p>\n<p><img decoding=\"async\" border=0 width=450 height=112 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V9.files\/image053.jpg\" v:shapes=\"Picture_x0020_27\"><\/p>\n<p>You need to create a new table that has the following information. <\/p>\n<p><img decoding=\"async\" border=0 width=603 height=122 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V9.files\/image054.jpg\" v:shapes=\"Picture_x0020_28\"><\/p>\n<p>Which join kind should you use?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='115488' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476281' \/><div class='watu-question-choice'><input type='radio' name='answer-115488[]' id='answer-id-476281' class='answer answer-18  answerof-115488' value='476281' \/>&nbsp;<label for='answer-id-476281' id='answer-label-476281' class=' answer label-18'><span class='answer'>Inner<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476282' \/><div class='watu-question-choice'><input type='radio' name='answer-115488[]' id='answer-id-476282' class='answer answer-18  answerof-115488' value='476282' \/>&nbsp;<label for='answer-id-476282' id='answer-label-476282' class=' answer label-18'><span class='answer'>Left Outer<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476283' \/><div class='watu-question-choice'><input type='radio' name='answer-115488[]' id='answer-id-476283' class='answer answer-18  answerof-115488' value='476283' \/>&nbsp;<label for='answer-id-476283' id='answer-label-476283' class=' answer label-18'><span class='answer'>Right Anti<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476284' \/><div class='watu-question-choice'><input type='radio' name='answer-115488[]' id='answer-id-476284' class='answer answer-18  answerof-115488' value='476284' \/>&nbsp;<label for='answer-id-476284' id='answer-label-476284' class=' answer label-18'><span class='answer'>Left Anti<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType18' value='radio' class=''><\/div><div class='watu-question' id='question-19'><div class='question-content'><p><span class='watu_num'>19. <\/span>You have a workbook query that loads the following table. <\/p>\n<p><img decoding=\"async\" border=0 width=365 height=194 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V9.files\/image055.jpg\" v:shapes=\"Picture_x0020_29\"><\/p>\n<p>You pivot the table on the key column by using value as the values column, and you receive the results shown in the following table. <\/p>\n<p><img decoding=\"async\" border=0 width=188 height=97 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V9.files\/image056.jpg\" v:shapes=\"Picture_x0020_30\"><\/p>\n<p>You need to ensure that the data appears as shown in the following table. <\/p>\n<p><img decoding=\"async\" border=0 width=290 height=137 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V9.files\/image057.jpg\" v:shapes=\"Picture_x0020_31\"><\/p>\n<\/div><input type='hidden' name='question_id[]' value='115489' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476285' \/><div class='watu-question-choice'><input type='radio' name='answer-115489[]' id='answer-id-476285' class='answer answer-19  answerof-115489' value='476285' \/>&nbsp;<label for='answer-id-476285' id='answer-label-476285' class=' answer label-19'><span class='answer'>Change the aggregate value function of the pivot.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476286' \/><div class='watu-question-choice'><input type='radio' name='answer-115489[]' id='answer-id-476286' class='answer answer-19  answerof-115489' value='476286' \/>&nbsp;<label for='answer-id-476286' id='answer-label-476286' class=' answer label-19'><span class='answer'>Select the ID column, and then click Unpivot Columns<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476287' \/><div class='watu-question-choice'><input type='radio' name='answer-115489[]' id='answer-id-476287' class='answer answer-19  answerof-115489' value='476287' \/>&nbsp;<label for='answer-id-476287' id='answer-label-476287' class=' answer label-19'><span class='answer'>Change the Data Type of the Value column.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476288' \/><div class='watu-question-choice'><input type='radio' name='answer-115489[]' id='answer-id-476288' class='answer answer-19  answerof-115489' value='476288' \/>&nbsp;<label for='answer-id-476288' id='answer-label-476288' class=' answer label-19'><span class='answer'>Delete the Picoted Column step. Select the Key column, and the click UnpivotColumns .<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType19' value='radio' class=''><\/div><div class='watu-question' id='question-20'><div class='question-content'><p><span class='watu_num'>20. <\/span>DRAG DROP<br \/>\n<br \/>You have 12 sales reports stored in a folder as CSV files. Each report represents one month of sales data for a year. The reports have the same structure.<br \/>\n<br \/>You need to analyze the entire year of sales data.<br \/>\n<br \/>Which three 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 order. <\/p>\n<p><img decoding=\"async\" border=0 width=623 height=208 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V9.files\/image059.jpg\" v:shapes=\"Picture_x0020_32\"><\/p>\n<\/div><input type='hidden' name='question_id[]' value='115490' \/><textarea name='answer-115490[]' rows='5' cols='40' id='textarea_q_115490' class='watu-textarea watu-textarea-20'><\/textarea><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476289' \/><\/div><input type='hidden' id='questionType20' value='textarea' class=''><\/div><div class='watu-question' id='question-21'><div class='question-content'><p><span class='watu_num'>21. <\/span>You have 20 workbook queries that load 20 CSV files to a local computer.<br \/>\n<br \/>You plan to send the workbook and the 20 CSV files to several users. The users will store the files in various location.<br \/>\n<br \/>You need to ensure that the users can change the path to the CSV files in the queries as quickly as possible.<br \/>\n<br \/>What should you do from Query Editor?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='115491' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476290' \/><div class='watu-question-choice'><input type='radio' name='answer-115491[]' id='answer-id-476290' class='answer answer-21  answerof-115491' value='476290' \/>&nbsp;<label for='answer-id-476290' id='answer-label-476290' class=' answer label-21'><span class='answer'>Merge all the queries. Edit the source of the first query.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476291' \/><div class='watu-question-choice'><input type='radio' name='answer-115491[]' id='answer-id-476291' class='answer answer-21  answerof-115491' value='476291' \/>&nbsp;<label for='answer-id-476291' id='answer-label-476291' class=' answer label-21'><span class='answer'>Create a parameter. Modify the source of each query to use the parameter.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476292' \/><div class='watu-question-choice'><input type='radio' name='answer-115491[]' id='answer-id-476292' class='answer answer-21  answerof-115491' value='476292' \/>&nbsp;<label for='answer-id-476292' id='answer-label-476292' class=' answer label-21'><span class='answer'>For each query, create a new query that uses a reference. Modify the source of each new query.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476293' \/><div class='watu-question-choice'><input type='radio' name='answer-115491[]' id='answer-id-476293' class='answer answer-21  answerof-115491' value='476293' \/>&nbsp;<label for='answer-id-476293' id='answer-label-476293' class=' answer label-21'><span class='answer'>Append all the queries. Edit the source of the first query.<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType21' value='radio' class=''><\/div><div class='watu-question' id='question-22'><div class='question-content'><p><span class='watu_num'>22. <\/span>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.<br \/>\n<br \/>You plane to share SalesResults.slsx to several users outside of your organization.<br \/>\n<br \/>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.<br \/>\n<br \/>What should you do?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='115492' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476294' \/><div class='watu-question-choice'><input type='radio' name='answer-115492[]' id='answer-id-476294' class='answer answer-22  answerof-115492' value='476294' \/>&nbsp;<label for='answer-id-476294' id='answer-label-476294' class=' answer label-22'><span class='answer'>Modify the source of the query.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476295' \/><div class='watu-question-choice'><input type='radio' name='answer-115492[]' id='answer-id-476295' class='answer answer-22  answerof-115492' value='476295' \/>&nbsp;<label for='answer-id-476295' id='answer-label-476295' class=' answer label-22'><span class='answer'>From Query Editor, open the Data Source Setting and delete the credentials.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476296' \/><div class='watu-question-choice'><input type='radio' name='answer-115492[]' id='answer-id-476296' class='answer answer-22  answerof-115492' value='476296' \/>&nbsp;<label for='answer-id-476296' id='answer-label-476296' class=' answer label-22'><span class='answer'>Run the Document inspector.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476297' \/><div class='watu-question-choice'><input type='radio' name='answer-115492[]' id='answer-id-476297' class='answer answer-22  answerof-115492' value='476297' \/>&nbsp;<label for='answer-id-476297' id='answer-label-476297' class=' answer label-22'><span class='answer'>Save the workbook as an Excel Binary Workbook (xlsx)<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType22' value='radio' class=''><\/div><div class='watu-question' id='question-23'><div class='question-content'><p><span class='watu_num'>23. <\/span>You have a query that retrieves customers and their locations. You have sample of the data as shown in the following table. <\/p>\n<p><img decoding=\"async\" border=0 width=385 height=137 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V9.files\/image062.jpg\" v:shapes=\"Picture_x0020_33\"><\/p>\n<p>Additional customers and locations are added frequently.<br \/>\n<br \/>You need to transform the data as shown in the following table. <\/p>\n<p><img decoding=\"async\" border=0 width=377 height=310 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V9.files\/image063.jpg\" v:shapes=\"Picture_x0020_34\"><\/p>\n<p>What should you do?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='115493' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476298' \/><div class='watu-question-choice'><input type='radio' name='answer-115493[]' id='answer-id-476298' class='answer answer-23  answerof-115493' value='476298' \/>&nbsp;<label for='answer-id-476298' id='answer-label-476298' class=' answer label-23'><span class='answer'>Select the Locations columns and the select split column by delimiter. Use a comma as the delimiter and split into rows.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476299' \/><div class='watu-question-choice'><input type='radio' name='answer-115493[]' id='answer-id-476299' class='answer answer-23  answerof-115493' value='476299' \/>&nbsp;<label for='answer-id-476299' id='answer-label-476299' class=' answer label-23'><span class='answer'>Select the Customer columns, and then click Unpivot Columns.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476300' \/><div class='watu-question-choice'><input type='radio' name='answer-115493[]' id='answer-id-476300' class='answer answer-23  answerof-115493' value='476300' \/>&nbsp;<label for='answer-id-476300' id='answer-label-476300' class=' answer label-23'><span class='answer'>Select the Customer columns, and then click Unpivot other Columns.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476301' \/><div class='watu-question-choice'><input type='radio' name='answer-115493[]' id='answer-id-476301' class='answer answer-23  answerof-115493' value='476301' \/>&nbsp;<label for='answer-id-476301' id='answer-label-476301' class=' answer label-23'><span class='answer'>Select the Location columns and then select split column by delimiter. Use a comma as the delimiter and split into columns.<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType23' value='radio' class=''><\/div><div class='watu-question' id='question-24'><div class='question-content'><p><span class='watu_num'>24. <\/span>You open an Excel worksheet as shown in the following exhibit. <\/p>\n<p><img decoding=\"async\" border=0 width=468 height=375 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V9.files\/image065.jpg\" v:shapes=\"Picture_x0020_51\"><\/p>\n<p>You need to export the data into a dataset in the Microsoft Power BI service.<br \/>\n<br \/>What should you do first?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='115494' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476302' \/><div class='watu-question-choice'><input type='radio' name='answer-115494[]' id='answer-id-476302' class='answer answer-24  answerof-115494' value='476302' \/>&nbsp;<label for='answer-id-476302' id='answer-label-476302' class=' answer label-24'><span class='answer'>Save the tile as an Excel template.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476303' \/><div class='watu-question-choice'><input type='radio' name='answer-115494[]' id='answer-id-476303' class='answer answer-24  answerof-115494' value='476303' \/>&nbsp;<label for='answer-id-476303' id='answer-label-476303' class=' answer label-24'><span class='answer'>Select the data, and then insert a table.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476304' \/><div class='watu-question-choice'><input type='radio' name='answer-115494[]' id='answer-id-476304' class='answer answer-24  answerof-115494' value='476304' \/>&nbsp;<label for='answer-id-476304' id='answer-label-476304' class=' answer label-24'><span class='answer'>Select the data, and Then insert a PivotTable.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476305' \/><div class='watu-question-choice'><input type='radio' name='answer-115494[]' id='answer-id-476305' class='answer answer-24  answerof-115494' value='476305' \/>&nbsp;<label for='answer-id-476305' id='answer-label-476305' class=' answer label-24'><span class='answer'>Install Power BI Publisher for Excel.<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType24' value='radio' class=''><\/div><div class='watu-question' id='question-25'><div class='question-content'><p><span class='watu_num'>25. <\/span>You have a table named Sales that has three columns named OrderDate, OrderNumber, and SalesAmount.<br \/>\n<br \/>You need to create the PivotTable as shown in the following table. <\/p>\n<p><img decoding=\"async\" border=0 width=292 height=275 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V9.files\/image066.jpg\" v:shapes=\"Picture_x0020_52\"><\/p>\n<p>What should you use?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='115495' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476306' \/><div class='watu-question-choice'><input type='radio' name='answer-115495[]' id='answer-id-476306' class='answer answer-25  answerof-115495' value='476306' \/>&nbsp;<label for='answer-id-476306' id='answer-label-476306' class=' answer label-25'><span class='answer'>KPIs<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476307' \/><div class='watu-question-choice'><input type='radio' name='answer-115495[]' id='answer-id-476307' class='answer answer-25  answerof-115495' value='476307' \/>&nbsp;<label for='answer-id-476307' id='answer-label-476307' class=' answer label-25'><span class='answer'>sparklines<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476308' \/><div class='watu-question-choice'><input type='radio' name='answer-115495[]' id='answer-id-476308' class='answer answer-25  answerof-115495' value='476308' \/>&nbsp;<label for='answer-id-476308' id='answer-label-476308' class=' answer label-25'><span class='answer'>conditional formatting<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476309' \/><div class='watu-question-choice'><input type='radio' name='answer-115495[]' id='answer-id-476309' class='answer answer-25  answerof-115495' value='476309' \/>&nbsp;<label for='answer-id-476309' id='answer-label-476309' class=' answer label-25'><span class='answer'>banded rows<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType25' value='radio' class=''><\/div><div class='watu-question' id='question-26'><div class='question-content'><p><span class='watu_num'>26. <\/span>Your network contains a folder that has data files m various formats.<br \/>\n<br \/>You need to identify how many files of each extension type are in the folder by using Query Editor.<br \/>\n<br \/>What should you do?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='115496' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476310' \/><div class='watu-question-choice'><input type='radio' name='answer-115496[]' id='answer-id-476310' class='answer answer-26  answerof-115496' value='476310' \/>&nbsp;<label for='answer-id-476310' id='answer-label-476310' class=' answer label-26'><span class='answer'>Create a query that uses a file source, and then use the Count Values command on the Transform tab.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476311' \/><div class='watu-question-choice'><input type='radio' name='answer-115496[]' id='answer-id-476311' class='answer answer-26  answerof-115496' value='476311' \/>&nbsp;<label for='answer-id-476311' id='answer-label-476311' class=' answer label-26'><span class='answer'>Create a query that uses a folder source, and then use the Group By command on the Home tab.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476312' \/><div class='watu-question-choice'><input type='radio' name='answer-115496[]' id='answer-id-476312' class='answer answer-26  answerof-115496' value='476312' \/>&nbsp;<label for='answer-id-476312' id='answer-label-476312' class=' answer label-26'><span class='answer'>Create a query that uses a file source, and then use the Group By command on the Home tab.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476313' \/><div class='watu-question-choice'><input type='radio' name='answer-115496[]' id='answer-id-476313' class='answer answer-26  answerof-115496' value='476313' \/>&nbsp;<label for='answer-id-476313' id='answer-label-476313' class=' answer label-26'><span class='answer'>Create a query that uses a folder source, and then use the Count Values command on the Transform tab.<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType26' value='radio' class=''><\/div><div class='watu-question' id='question-27'><div class='question-content'><p><span class='watu_num'>27. <\/span>You have a data model in Excel.<br \/>\n<br \/>You export the data and the data model into a dataset in the Microsoft Power BI service.<br \/>\n<br \/>What can you use to modify the data model that is published to the Power BI service?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='115497' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476314' \/><div class='watu-question-choice'><input type='radio' name='answer-115497[]' id='answer-id-476314' class='answer answer-27  answerof-115497' value='476314' \/>&nbsp;<label for='answer-id-476314' id='answer-label-476314' class=' answer label-27'><span class='answer'>Microsoft Power BI Desktop<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476315' \/><div class='watu-question-choice'><input type='radio' name='answer-115497[]' id='answer-id-476315' class='answer answer-27  answerof-115497' value='476315' \/>&nbsp;<label for='answer-id-476315' id='answer-label-476315' class=' answer label-27'><span class='answer'>Excel and the Microsoft Power BI service<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476316' \/><div class='watu-question-choice'><input type='radio' name='answer-115497[]' id='answer-id-476316' class='answer answer-27  answerof-115497' value='476316' \/>&nbsp;<label for='answer-id-476316' id='answer-label-476316' class=' answer label-27'><span class='answer'>Excel only<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476317' \/><div class='watu-question-choice'><input type='radio' name='answer-115497[]' id='answer-id-476317' class='answer answer-27  answerof-115497' value='476317' \/>&nbsp;<label for='answer-id-476317' id='answer-label-476317' class=' answer label-27'><span class='answer'>the Microsoft Power BI service only<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType27' value='radio' class=''><\/div><div class='watu-question' id='question-28'><div class='question-content'><p><span class='watu_num'>28. <\/span>You have a table named Sales that has three columns named Region, Country, and SalesAmount.<br \/>\n<br \/>You create a PivotTable as shown in the following exhibit. <\/p>\n<p><img decoding=\"async\" border=0 width=187 height=172 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V9.files\/image068.jpg\" v:shapes=\"Picture_x0020_36\"><\/p>\n<p>You need to ensure that the PivotTable appears in three columns as shown in the following exhibit. <\/p>\n<p><img decoding=\"async\" border=0 width=292 height=130 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V9.files\/image070.jpg\" v:shapes=\"Picture_x0020_37\"><\/p>\n<\/div><input type='hidden' name='question_id[]' value='115498' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476318' \/><div class='watu-question-choice'><input type='radio' name='answer-115498[]' id='answer-id-476318' class='answer answer-28  answerof-115498' value='476318' \/>&nbsp;<label for='answer-id-476318' id='answer-label-476318' class=' answer label-28'><span class='answer'>On the Design tab, click Report Layout and then click Show in Compact Form.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476319' \/><div class='watu-question-choice'><input type='radio' name='answer-115498[]' id='answer-id-476319' class='answer answer-28  answerof-115498' value='476319' \/>&nbsp;<label for='answer-id-476319' id='answer-label-476319' class=' answer label-28'><span class='answer'>Move Country from the Rows area to the Columns area.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476320' \/><div class='watu-question-choice'><input type='radio' name='answer-115498[]' id='answer-id-476320' class='answer answer-28  answerof-115498' value='476320' \/>&nbsp;<label for='answer-id-476320' id='answer-label-476320' class=' answer label-28'><span class='answer'>Move Country from the Rows area to the Values area.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476321' \/><div class='watu-question-choice'><input type='radio' name='answer-115498[]' id='answer-id-476321' class='answer answer-28  answerof-115498' value='476321' \/>&nbsp;<label for='answer-id-476321' id='answer-label-476321' class=' answer label-28'><span class='answer'>On the Design tab, click Report Layout and then click Show in Tabular Form.<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType28' value='radio' class=''><\/div><div class='watu-question' id='question-29'><div class='question-content'><p><span class='watu_num'>29. <\/span>You have a pie chart.<br \/>\n<br \/>You need the wedges of the pie chart to be separated as shown in the following exhibit. <\/p>\n<p><img decoding=\"async\" border=0 width=372 height=246 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V9.files\/image071.jpg\" alt=Untitled v:shapes=\"Picture_x0020_38\"><\/p>\n<\/div><input type='hidden' name='question_id[]' value='115499' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476322' \/><div class='watu-question-choice'><input type='radio' name='answer-115499[]' id='answer-id-476322' class='answer answer-29  answerof-115499' value='476322' \/>&nbsp;<label for='answer-id-476322' id='answer-label-476322' class=' answer label-29'><span class='answer'>Change the chart type to Pie of Pie.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476323' \/><div class='watu-question-choice'><input type='radio' name='answer-115499[]' id='answer-id-476323' class='answer answer-29  answerof-115499' value='476323' \/>&nbsp;<label for='answer-id-476323' id='answer-label-476323' class=' answer label-29'><span class='answer'>Right-click the pie chart, click Expand\/Collapse, and then click Expand.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476324' \/><div class='watu-question-choice'><input type='radio' name='answer-115499[]' id='answer-id-476324' class='answer answer-29  answerof-115499' value='476324' \/>&nbsp;<label for='answer-id-476324' id='answer-label-476324' class=' answer label-29'><span class='answer'>Right-click the pie chart, click Expand\/Collapse, and Then click Expand Entire Field<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476325' \/><div class='watu-question-choice'><input type='radio' name='answer-115499[]' id='answer-id-476325' class='answer answer-29  answerof-115499' value='476325' \/>&nbsp;<label for='answer-id-476325' id='answer-label-476325' class=' answer label-29'><span class='answer'>Select a wedge of the pie chart and then drag the wedge.<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType29' value='radio' class=''><\/div><div class='watu-question' id='question-30'><div class='question-content'><p><span class='watu_num'>30. <\/span>You need to create a PivotChart that has a filter as shown in the following exhibit. <\/p>\n<p><img decoding=\"async\" border=0 width=362 height=277 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V9.files\/image073.jpg\" alt=Untitled v:shapes=\"Picture_x0020_39\"><\/p>\n<\/div><input type='hidden' name='question_id[]' value='115500' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476326' \/><div class='watu-question-choice'><input type='radio' name='answer-115500[]' id='answer-id-476326' class='answer answer-30  answerof-115500' value='476326' \/>&nbsp;<label for='answer-id-476326' id='answer-label-476326' class=' answer label-30'><span class='answer'>From the model, create a measure.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476327' \/><div class='watu-question-choice'><input type='radio' name='answer-115500[]' id='answer-id-476327' class='answer answer-30  answerof-115500' value='476327' \/>&nbsp;<label for='answer-id-476327' id='answer-label-476327' class=' answer label-30'><span class='answer'>From Query Editor, create a function.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476328' \/><div class='watu-question-choice'><input type='radio' name='answer-115500[]' id='answer-id-476328' class='answer answer-30  answerof-115500' value='476328' \/>&nbsp;<label for='answer-id-476328' id='answer-label-476328' class=' answer label-30'><span class='answer'>From Query Editor, create a parameter.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476329' \/><div class='watu-question-choice'><input type='radio' name='answer-115500[]' id='answer-id-476329' class='answer answer-30  answerof-115500' value='476329' \/>&nbsp;<label for='answer-id-476329' id='answer-label-476329' class=' answer label-30'><span class='answer'>From the model, create a hierarchy.<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType30' value='radio' class=''><\/div><div class='watu-question' id='question-31'><div class='question-content'><p><span class='watu_num'>31. <\/span>DRAG DROP<br \/>\n<br \/>You create a new workbook and add a table to a data model. The data is shown in the following table. <\/p>\n<p><img decoding=\"async\" border=0 width=319 height=156 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V9.files\/image074.jpg\" alt=Untitled v:shapes=\"Picture_x0020_40\"><\/p>\n<p>You need to create a visualization as shown in the following exhibit. <\/p>\n<p><img decoding=\"async\" border=0 width=308 height=120 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V9.files\/image075.jpg\" alt=Untitled v:shapes=\"Picture_x0020_41\"><\/p>\n<p>Witch three 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 order. <\/p>\n<p><img decoding=\"async\" border=0 width=493 height=135 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V9.files\/image077.jpg\" alt=Untitled v:shapes=\"Picture_x0020_42\"><\/p>\n<\/div><input type='hidden' name='question_id[]' value='115501' \/><textarea name='answer-115501[]' rows='5' cols='40' id='textarea_q_115501' class='watu-textarea watu-textarea-31'><\/textarea><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476330' \/><\/div><input type='hidden' id='questionType31' value='textarea' class=''><\/div><div class='watu-question' id='question-32'><div class='question-content'><p><span class='watu_num'>32. <\/span>You have the data model shown in the Data Model exhibit. (Click the Exhibit button.) <\/p>\n<p><img decoding=\"async\" border=0 width=256 height=370 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V9.files\/image081.jpg\" v:shapes=\"Picture_x0020_156\"><\/p>\n<p>You have the PivotChart shown in the Pivot Chart exhibit. (Click the Exhibit button.) <\/p>\n<p><img decoding=\"async\" border=0 width=469 height=299 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V9.files\/image082.jpg\" alt=Untitled v:shapes=\"Picture_x0020_158\"><\/p>\n<p>You need to change the current view of the PivotChart to display ProductCategory only.<br \/>\n<br \/>What should you do?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='115502' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476331' \/><div class='watu-question-choice'><input type='radio' name='answer-115502[]' id='answer-id-476331' class='answer answer-32  answerof-115502' value='476331' \/>&nbsp;<label for='answer-id-476331' id='answer-label-476331' class=' answer label-32'><span class='answer'>Double-click a bar in the PivotChart.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476332' \/><div class='watu-question-choice'><input type='radio' name='answer-115502[]' id='answer-id-476332' class='answer answer-32  answerof-115502' value='476332' \/>&nbsp;<label for='answer-id-476332' id='answer-label-476332' class=' answer label-32'><span class='answer'>Click the &#8211; button.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476333' \/><div class='watu-question-choice'><input type='radio' name='answer-115502[]' id='answer-id-476333' class='answer answer-32  answerof-115502' value='476333' \/>&nbsp;<label for='answer-id-476333' id='answer-label-476333' class=' answer label-32'><span class='answer'>Right-click the PivotChart and click Reset to Match Style.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476334' \/><div class='watu-question-choice'><input type='radio' name='answer-115502[]' id='answer-id-476334' class='answer answer-32  answerof-115502' value='476334' \/>&nbsp;<label for='answer-id-476334' id='answer-label-476334' class=' answer label-32'><span class='answer'>Right-click a bar in the PivotChart and click Expand Entire Field.<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType32' value='radio' class=''><\/div><div class='watu-question' id='question-33'><div class='question-content'><p><span class='watu_num'>33. <\/span>You have a KPI named Goal that calculates the sales from the previous year and multiplies the sales by 1.1.<br \/>\n<br \/>You need to modify Goal to multiply the sales from the previous year by 1.15.<br \/>\n<br \/>What should you do?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='115503' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476335' \/><div class='watu-question-choice'><input type='radio' name='answer-115503[]' id='answer-id-476335' class='answer answer-33  answerof-115503' value='476335' \/>&nbsp;<label for='answer-id-476335' id='answer-label-476335' class=' answer label-33'><span class='answer'>From Power Pivot, modify the measure.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476336' \/><div class='watu-question-choice'><input type='radio' name='answer-115503[]' id='answer-id-476336' class='answer answer-33  answerof-115503' value='476336' \/>&nbsp;<label for='answer-id-476336' id='answer-label-476336' class=' answer label-33'><span class='answer'>From the properties of the KPI, modify the KPI base field.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476337' \/><div class='watu-question-choice'><input type='radio' name='answer-115503[]' id='answer-id-476337' class='answer answer-33  answerof-115503' value='476337' \/>&nbsp;<label for='answer-id-476337' id='answer-label-476337' class=' answer label-33'><span class='answer'>From Power Pivot, create a new calculated column, and then modify the KP<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476338' \/><div class='watu-question-choice'><input type='radio' name='answer-115503[]' id='answer-id-476338' class='answer answer-33  answerof-115503' value='476338' \/>&nbsp;<label for='answer-id-476338' id='answer-label-476338' class=' answer label-33'><span class='answer'>From the properties of the KPI, modify the absolute value.<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType33' value='radio' class=''><\/div><div class='watu-question' id='question-34'><div class='question-content'><p><span class='watu_num'>34. <\/span>DRAG DROP<br \/>\n<br \/>You have a data model that contains a table named SalesOrders has four columns named Orderld, SalesAmount, OrderDate, and Territory.<br \/>\n<br \/>You plan to create a PivotChart that will display the percentage of SalesAmount for each Territory.<br \/>\n<br \/>You need to create a measure to calculate the percentage of sales of each territory.<br \/>\n<br \/>How should you complete the DAX formula? To answer, drag the appropriate value to the correct targets. Each value may be used once, more than once, or not at all. You need to drag the split bar between panes or scroll to view content. <\/p>\n<p><img decoding=\"async\" border=0 width=623 height=166 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V9.files\/image084.jpg\" v:shapes=\"Picture_x0020_35\"><\/p>\n<\/div><input type='hidden' name='question_id[]' value='115504' \/><textarea name='answer-115504[]' rows='5' cols='40' id='textarea_q_115504' class='watu-textarea watu-textarea-34'><\/textarea><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476339' \/><\/div><input type='hidden' id='questionType34' value='textarea' class=''><\/div><div class='watu-question' id='question-35'><div class='question-content'><p><span class='watu_num'>35. <\/span>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.<br \/>\n<br \/>You need to create a relationship between Date and Invoices.<br \/>\n<br \/>What should you do first?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='115505' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476340' \/><div class='watu-question-choice'><input type='radio' name='answer-115505[]' id='answer-id-476340' class='answer answer-35  answerof-115505' value='476340' \/>&nbsp;<label for='answer-id-476340' id='answer-label-476340' class=' answer label-35'><span class='answer'>Change the Data Type of InvoiceDate and DateID to Text.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476341' \/><div class='watu-question-choice'><input type='radio' name='answer-115505[]' id='answer-id-476341' class='answer answer-35  answerof-115505' value='476341' \/>&nbsp;<label for='answer-id-476341' id='answer-label-476341' class=' answer label-35'><span class='answer'>Create a measure in Invoices that uses the Format DAX Function.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476342' \/><div class='watu-question-choice'><input type='radio' name='answer-115505[]' id='answer-id-476342' class='answer answer-35  answerof-115505' value='476342' \/>&nbsp;<label for='answer-id-476342' id='answer-label-476342' class=' answer label-35'><span class='answer'>Change the Data Type of DateID to Date.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476343' \/><div class='watu-question-choice'><input type='radio' name='answer-115505[]' id='answer-id-476343' class='answer answer-35  answerof-115505' value='476343' \/>&nbsp;<label for='answer-id-476343' id='answer-label-476343' class=' answer label-35'><span class='answer'>Create a calculated column in Invoices that uses the Format DAX function.<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType35' value='radio' class=''><\/div><div class='watu-question' id='question-36'><div class='question-content'><p><span class='watu_num'>36. <\/span>You have the following table. <\/p>\n<p><img decoding=\"async\" border=0 width=325 height=322 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V9.files\/image085.jpg\" v:shapes=\"Picture_x0020_361\"><\/p>\n<p>You plan to use [Month Name] as the axis in a PivotChart.<br \/>\n<br \/>You need to ensure that whenever [Month Name] is used in a chart, the months are displayed chronologically be default.<br \/>\n<br \/>What should you do?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='115506' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476344' \/><div class='watu-question-choice'><input type='radio' name='answer-115506[]' id='answer-id-476344' class='answer answer-36  answerof-115506' value='476344' \/>&nbsp;<label for='answer-id-476344' id='answer-label-476344' class=' answer label-36'><span class='answer'>Sort the [Month Name] column by [Month Name].<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476345' \/><div class='watu-question-choice'><input type='radio' name='answer-115506[]' id='answer-id-476345' class='answer answer-36  answerof-115506' value='476345' \/>&nbsp;<label for='answer-id-476345' id='answer-label-476345' class=' answer label-36'><span class='answer'>Change the Data Type of [Month Name] to Date.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476346' \/><div class='watu-question-choice'><input type='radio' name='answer-115506[]' id='answer-id-476346' class='answer answer-36  answerof-115506' value='476346' \/>&nbsp;<label for='answer-id-476346' id='answer-label-476346' class=' answer label-36'><span class='answer'>Sort the [Month Name] column by [Month Number ].<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476347' \/><div class='watu-question-choice'><input type='radio' name='answer-115506[]' id='answer-id-476347' class='answer answer-36  answerof-115506' value='476347' \/>&nbsp;<label for='answer-id-476347' id='answer-label-476347' class=' answer label-36'><span class='answer'>Add a calculated column named [ID] that use the [Month Name] &amp; [Month Number] DAX formula<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType36' value='radio' class=''><\/div><div class='watu-question' id='question-37'><div class='question-content'><p><span class='watu_num'>37. <\/span>You have a table in Power Pivot model that is loaded from a Microsoft SQL Server database.<br \/>\n<br \/>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.<br \/>\n<br \/>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.<br \/>\n<br \/>What should you do?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='115507' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476348' \/><div class='watu-question-choice'><input type='radio' name='answer-115507[]' id='answer-id-476348' class='answer answer-37  answerof-115507' value='476348' \/>&nbsp;<label for='answer-id-476348' id='answer-label-476348' class=' answer label-37'><span class='answer'>Replace the Total column by using a measure.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476349' \/><div class='watu-question-choice'><input type='radio' name='answer-115507[]' id='answer-id-476349' class='answer answer-37  answerof-115507' value='476349' \/>&nbsp;<label for='answer-id-476349' id='answer-label-476349' class=' answer label-37'><span class='answer'>Replace the Total column by using a calculated column.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476350' \/><div class='watu-question-choice'><input type='radio' name='answer-115507[]' id='answer-id-476350' class='answer answer-37  answerof-115507' value='476350' \/>&nbsp;<label for='answer-id-476350' id='answer-label-476350' class=' answer label-37'><span class='answer'>From Query Editor, remove duplicate rows from the table.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476351' \/><div class='watu-question-choice'><input type='radio' name='answer-115507[]' id='answer-id-476351' class='answer answer-37  answerof-115507' value='476351' \/>&nbsp;<label for='answer-id-476351' id='answer-label-476351' class=' answer label-37'><span class='answer'>Move the Total column to a lookup table.<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType37' value='radio' class=''><\/div><div class='watu-question' id='question-38'><div class='question-content'><p><span class='watu_num'>38. <\/span>DRAG DROP<br \/>\n<br \/>You have a model that contains the following table named Sales. <\/p>\n<p><img decoding=\"async\" border=0 width=623 height=107 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V9.files\/image087.jpg\" v:shapes=\"Picture_x0020_371\"><\/p>\n<p>You have measure named TotalSales that calculates the sum of Line Total.<br \/>\n<br \/>You plan to create a PivotChart to display TotalSale for each category and the percent of total sales for each category as shown in the following exhibit. <\/p>\n<p><img decoding=\"async\" border=0 width=624 height=212 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V9.files\/image089.jpg\" v:shapes=\"Picture_x0020_381\"><\/p>\n<p><img decoding=\"async\" border=0 width=624 height=183 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V9.files\/image091.jpg\" v:shapes=\"Picture_x0020_391\"><\/p>\n<p>How should you complete the DAX formula for the Percent measure? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You need to drag the split bar between panes or scroll to view content.<br \/>\n<br \/>NOTE: Each correct selection is wroth on point. <\/p>\n<p><img decoding=\"async\" border=0 width=624 height=152 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V9.files\/image093.jpg\" v:shapes=\"Picture_x0020_110\"><\/p>\n<\/div><input type='hidden' name='question_id[]' value='115508' \/><textarea name='answer-115508[]' rows='5' cols='40' id='textarea_q_115508' class='watu-textarea watu-textarea-38'><\/textarea><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476352' \/><\/div><input type='hidden' id='questionType38' value='textarea' class=''><\/div><div class='watu-question' id='question-39'><div class='question-content'><p><span class='watu_num'>39. <\/span>HOTSPOT<br \/>\n<br \/>You have a table named Date that contains the following data. <\/p>\n<p><img decoding=\"async\" border=0 width=623 height=510 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V9.files\/image095.jpg\" v:shapes=\"Picture_x0020_7\"><\/p>\n<p>You plan to create Pivot Charts that will be sliced by MonthName.<br \/>\n<br \/>You need to create a relationship between Sales and Date.<br \/>\n<br \/>Which Columns should you use to create the relationship? To answer, select the appropriate options in the answer area.<br \/>\n<br \/>NOTE: Each correct selection is worth one point. <\/p>\n<p><img decoding=\"async\" border=0 width=314 height=217 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V9.files\/image097.gif\" v:shapes=\"Picture_x0020_168\"><\/p>\n<\/div><input type='hidden' name='question_id[]' value='115509' \/><textarea name='answer-115509[]' rows='5' cols='40' id='textarea_q_115509' class='watu-textarea watu-textarea-39'><\/textarea><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476353' \/><\/div><input type='hidden' id='questionType39' value='textarea' class=''><\/div><div class='watu-question' id='question-40'><div class='question-content'><p><span class='watu_num'>40. <\/span>HOTSPOT<br \/>\n<br \/>You have a model that contain data relating to corporate profits. The model contains a measure named Profit.<br \/>\n<br \/>You need to create a PivoTable to display the Profit measure in three different formats by using the Show Value As feature. The PivoTable must produce the result shown in the following table. <\/p>\n<p><img decoding=\"async\" border=0 width=624 height=697 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V9.files\/image103.jpg\" v:shapes=\"Picture_x0020_421\"><\/p>\n<p>How should you configure the Show Value As feature for % Profit of Annual Total and % Profit of Grand Total? To answer,<br \/>\n<br \/>Select the appropriate options in the answer area.<br \/>\n<br \/>NOTE: Each correct selections is worth one point.<br \/>\n<br \/>Answer Area <\/p>\n<p><img decoding=\"async\" border=0 width=337 height=144 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V9.files\/image105.gif\" v:shapes=\"Picture_x0020_166\"><\/p>\n<\/div><input type='hidden' name='question_id[]' value='115510' \/><textarea name='answer-115510[]' rows='5' cols='40' id='textarea_q_115510' class='watu-textarea watu-textarea-40'><\/textarea><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='476354' \/><\/div><input type='hidden' id='questionType40' value='textarea' class=''><\/div><div style='display:none' id='question-41'><br \/><div class='question-content'><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/plugins\/watu\/loading.gif\" width=\"16\" height=\"16\" alt=\"Loading ...\" title=\"Loading ...\" \/>&nbsp;Loading &#8230;<\/div><\/div><br \/>\n<input type=\"button\" name=\"action\" onclick=\"Watu.submitResult()\" id=\"action-button\" value=\"Submit\"  class=\"watu-submit-button\" \/>\n<input type=\"hidden\" name=\"no_ajax\" value=\"0\"><input type=\"hidden\" name=\"quiz_id\" value=\"2008\" \/>\n<input type=\"hidden\" id=\"watuStartTime\" name=\"start_time\" value=\"2026-05-01 00:33:14\" \/>\n<\/form>\n<\/div>\n<div id=\"watu-loading-result\" style=\"display:none;\">\n\t<p align=\"center\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/plugins\/watu\/loading.gif\" width=\"16\" height=\"16\" alt=\"Loading\" title=\"Loading\" \/><\/p>\n<\/div>\t\n<script type=\"text\/javascript\">\nvar exam_id=0;\nvar question_ids='';\nvar watuURL='';\njQuery(function($){\nquestion_ids = \"115471,115472,115473,115474,115475,115476,115477,115478,115479,115480,115481,115482,115483,115484,115485,115486,115487,115488,115489,115490,115491,115492,115493,115494,115495,115496,115497,115498,115499,115500,115501,115502,115503,115504,115505,115506,115507,115508,115509,115510\";\nexam_id = 2008;\nWatu.exam_id = exam_id;\nWatu.qArr = question_ids.split(',');\nWatu.post_id = 4606;\nWatu.singlePage = '1';\nWatu.hAppID = \"0.67912000 1777595594\";\nwatuURL = \"https:\/\/www.dumpsbase.com\/freedumps\/wp-admin\/admin-ajax.php\";\nWatu.noAlertUnanswered = 0;\n});\n<\/script>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[160,101],"tags":[3068,3069,3070,7809],"class_list":["post-4606","post","type-post","status-publish","format-standard","hentry","category-mcsa","category-microsoft","tag-70-779","tag-70-779-dumps-questions","tag-70-779-free-dumps","tag-70-779-practice-exam-questions"],"_links":{"self":[{"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/posts\/4606","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/comments?post=4606"}],"version-history":[{"count":1,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/posts\/4606\/revisions"}],"predecessor-version":[{"id":4607,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/posts\/4606\/revisions\/4607"}],"wp:attachment":[{"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/media?parent=4606"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/categories?post=4606"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/tags?post=4606"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}