{"id":1137,"date":"2018-09-03T09:49:04","date_gmt":"2018-09-03T09:49:04","guid":{"rendered":"https:\/\/dumps.dumpsbase.com\/?p=1137"},"modified":"2019-03-04T06:46:34","modified_gmt":"2019-03-04T06:46:34","slug":"test-70-779-analyzing-and-visualizing-data-with-microsoft-excel-dumps-online","status":"publish","type":"post","link":"https:\/\/www.dumpsbase.com\/freedumps\/test-70-779-analyzing-and-visualizing-data-with-microsoft-excel-dumps-online.html","title":{"rendered":"Test 70-779 Analyzing and Visualizing Data with Microsoft Excel Dumps Online"},"content":{"rendered":"<p>Test 70-779 Analyzing and Visualizing Data with Microsoft Excel Dumps Online now. 70-779 exam is one of the requirements for MCSA:BI Reporting certification. Before taking 70-779 exam, you should know the exam skills:<\/p>\n<ul>\n<li>Published: July 31, 2017<\/li>\n<li>Languages: English<\/li>\n<li>Audiences: BI professionals, data analysts<\/li>\n<li>Technology: Microsoft Excel, Power BI<\/li>\n<li>Credit toward certification: MCP, MCSA<\/li>\n<\/ul>\n<p>Passing 70-779 exam and getting MCSA BI Reporting certification will help you improve yourself.<\/p>\n<p><em><span style=\"font-size: 14pt; color: #ff6600;\"><strong>Test 70-779 Analyzing and Visualizing Data with Microsoft Excel Dumps Online<\/strong><\/span><\/em><\/p>\n<script>\n\t  window.fbAsyncInit = function() {\n\t    FB.init({\n\t      appId            : '622169541470367',\n\t      autoLogAppEvents : true,\n\t      xfbml            : true,\n\t      version          : 'v3.1'\n\t    });\n\t  };\n\t\n\t  (function(d, s, id){\n\t     var js, fjs = d.getElementsByTagName(s)[0];\n\t     if (d.getElementById(id)) {return;}\n\t     js = d.createElement(s); js.id = id;\n\t     js.src = \"https:\/\/connect.facebook.net\/en_US\/sdk.js\";\n\t     fjs.parentNode.insertBefore(js, fjs);\n\t   }(document, 'script', 'facebook-jssdk'));\n\t<\/script><script type=\"text\/javascript\" >\ndocument.addEventListener(\"DOMContentLoaded\", function(event) { \nif(!window.jQuery) alert(\"The important jQuery library is not properly loaded in your site. Your WordPress theme is probably missing the essential wp_head() call. You can switch to another theme and you will see that the plugin works fine and this notice disappears. If you are still not sure what to do you can contact us for help.\");\n});\n<\/script>  \n  \n<div  id=\"watupro_quiz\" class=\"quiz-area single-page-quiz\">\n<p id=\"submittingExam415\" style=\"display:none;text-align:center;\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/plugins\/watupro\/img\/loading.gif\" width=\"16\" height=\"16\"><\/p>\n\n<div class=\"watupro-exam-description\" id=\"description-quiz-415\"><\/div>\n\n<form action=\"\" method=\"post\" class=\"quiz-form\" id=\"quiz-415\"  enctype=\"multipart\/form-data\" >\n<div class='watu-question ' id='question-1' style=';'><div id='questionWrap-1'  class='   watupro-question-id-8028'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>1. <\/span>DRAG DROP <br \/>\r<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 \/>\r<br>You need to analyze the entire year of sales data. <br \/>\r<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. <br \/>\r<br><br><img decoding=\"async\" border=0 width=623 height=208 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V8.files\/image059.jpg\" v:shapes=\"Picture_x0020_32\"><br><\/div><input type='hidden' name='question_id[]' id='qID_1' value='8028' \/><input type='hidden' id='answerType8028' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-8028[]' id='textarea_q_8028' class='watupro-textarea-medium' rows='5' cols='80'><\/textarea>\n<\/p><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-2' style=';'><div id='questionWrap-2'  class='   watupro-question-id-8029'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>2. <\/span>You have 20 workbook queries that load 20 CSV files to a local computer. <br \/>\r<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 \/>\r<br>You need to ensure that the users can change the path to the CSV files in the queries as quickly as possible. <br \/>\r<br>What should you do from Query Editor?<\/div><input type='hidden' name='question_id[]' id='qID_2' value='8029' \/><input type='hidden' id='answerType8029' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-8029[]' id='answer-id-33387' class='answer   answerof-8029 ' value='33387'   \/><label for='answer-id-33387' id='answer-label-33387' class=' answer'><span>Merge all the queries. Edit the source of the first query.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-8029[]' id='answer-id-33388' class='answer   answerof-8029 ' value='33388'   \/><label for='answer-id-33388' id='answer-label-33388' class=' answer'><span>Create a parameter. Modify the source of each query to use the parameter.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-8029[]' id='answer-id-33389' class='answer   answerof-8029 ' value='33389'   \/><label for='answer-id-33389' id='answer-label-33389' class=' answer'><span>For each query, create a new query that uses a reference. Modify the source of each new query.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-8029[]' id='answer-id-33390' class='answer   answerof-8029 ' value='33390'   \/><label for='answer-id-33390' id='answer-label-33390' class=' answer'><span>Append all the queries. Edit the source of the first query.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-3' style=';'><div id='questionWrap-3'  class='   watupro-question-id-8030'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>3. <\/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 \/>\r<br>You plane to share SalesResults.slsx to several users outside of your organization. <br \/>\r<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 \/>\r<br>What should you do?<\/div><input type='hidden' name='question_id[]' id='qID_3' value='8030' \/><input type='hidden' id='answerType8030' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-8030[]' id='answer-id-33391' class='answer   answerof-8030 ' value='33391'   \/><label for='answer-id-33391' id='answer-label-33391' class=' answer'><span>Modify the source of the query.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-8030[]' id='answer-id-33392' class='answer   answerof-8030 ' value='33392'   \/><label for='answer-id-33392' id='answer-label-33392' class=' answer'><span>From Query Editor, open the Data Source Setting and delete the credentials.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-8030[]' id='answer-id-33393' class='answer   answerof-8030 ' value='33393'   \/><label for='answer-id-33393' id='answer-label-33393' class=' answer'><span>Run the Document inspector.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-8030[]' id='answer-id-33394' class='answer   answerof-8030 ' value='33394'   \/><label for='answer-id-33394' id='answer-label-33394' class=' answer'><span>Save the workbook as an Excel Binary Workbook (xlsx)<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-4' style=';'><div id='questionWrap-4'  class='   watupro-question-id-8031'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>4. <\/span>You have a query that retrieves customers and their locations. You have sample of the data as shown in the following table. <br \/>\r<br><br><img decoding=\"async\" border=0 width=385 height=137 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V8.files\/image062.jpg\" v:shapes=\"Picture_x0020_33\"><br><br \/>\r<br>Additional customers and locations are added frequently. <br \/>\r<br>You need to transform the data as shown in the following table. <br \/>\r<br><br><img decoding=\"async\" border=0 width=377 height=310 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V8.files\/image063.jpg\" v:shapes=\"Picture_x0020_34\"><br><br \/>\r<br>What should you do?<\/div><input type='hidden' name='question_id[]' id='qID_4' value='8031' \/><input type='hidden' id='answerType8031' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-8031[]' id='answer-id-33395' class='answer   answerof-8031 ' value='33395'   \/><label for='answer-id-33395' id='answer-label-33395' class=' answer'><span>Select the Locations columns and the select split column by delimiter. Use a comma as the delimiter and split into rows.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-8031[]' id='answer-id-33396' class='answer   answerof-8031 ' value='33396'   \/><label for='answer-id-33396' id='answer-label-33396' class=' answer'><span>Select the Customer columns, and then click Unpivot Columns.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-8031[]' id='answer-id-33397' class='answer   answerof-8031 ' value='33397'   \/><label for='answer-id-33397' id='answer-label-33397' class=' answer'><span>Select the Customer columns, and then click Unpivot other Columns.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-8031[]' id='answer-id-33398' class='answer   answerof-8031 ' value='33398'   \/><label for='answer-id-33398' id='answer-label-33398' class=' answer'><span>Select the Location columns and then select split column by delimiter. Use a comma as the delimiter and split into columns.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-5' style=';'><div id='questionWrap-5'  class='   watupro-question-id-8032'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>5. <\/span>You open an Excel worksheet as shown in the following exhibit. <br \/>\r<br><br><img decoding=\"async\" border=0 width=468 height=375 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V8.files\/image065.jpg\" v:shapes=\"Picture_x0020_51\"><br><br \/>\r<br>You need to export the data into a dataset in the Microsoft Power BI service. <br \/>\r<br>What should you do first?<\/div><input type='hidden' name='question_id[]' id='qID_5' value='8032' \/><input type='hidden' id='answerType8032' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-8032[]' id='answer-id-33399' class='answer   answerof-8032 ' value='33399'   \/><label for='answer-id-33399' id='answer-label-33399' class=' answer'><span>Save the tile as an Excel template.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-8032[]' id='answer-id-33400' class='answer   answerof-8032 ' value='33400'   \/><label for='answer-id-33400' id='answer-label-33400' class=' answer'><span>Select the data, and then insert a table.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-8032[]' id='answer-id-33401' class='answer   answerof-8032 ' value='33401'   \/><label for='answer-id-33401' id='answer-label-33401' class=' answer'><span>Select the data, and Then insert a PivotTable.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-8032[]' id='answer-id-33402' class='answer   answerof-8032 ' value='33402'   \/><label for='answer-id-33402' id='answer-label-33402' class=' answer'><span>Install Power BI Publisher for Excel.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-6' style=';'><div id='questionWrap-6'  class='   watupro-question-id-8033'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>6. <\/span>You have a table named Sales that has three columns named OrderDate, OrderNumber, and SalesAmount. <br \/>\r<br>You need to create the PivotTable as shown in the following table. <br \/>\r<br><br><img decoding=\"async\" border=0 width=292 height=275 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V8.files\/image066.jpg\" v:shapes=\"Picture_x0020_52\"><br><br \/>\r<br>What should you use?<\/div><input type='hidden' name='question_id[]' id='qID_6' value='8033' \/><input type='hidden' id='answerType8033' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-8033[]' id='answer-id-33403' class='answer   answerof-8033 ' value='33403'   \/><label for='answer-id-33403' id='answer-label-33403' class=' answer'><span>KPIs<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-8033[]' id='answer-id-33404' class='answer   answerof-8033 ' value='33404'   \/><label for='answer-id-33404' id='answer-label-33404' class=' answer'><span>sparklines<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-8033[]' id='answer-id-33405' class='answer   answerof-8033 ' value='33405'   \/><label for='answer-id-33405' id='answer-label-33405' class=' answer'><span>conditional formatting<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-8033[]' id='answer-id-33406' class='answer   answerof-8033 ' value='33406'   \/><label for='answer-id-33406' id='answer-label-33406' class=' answer'><span>banded rows<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-7' style=';'><div id='questionWrap-7'  class='   watupro-question-id-8034'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>7. <\/span>Your network contains a folder that has data files m various formats. <br \/>\r<br>You need to identify how many files of each extension type are in the folder by using Query Editor. <br \/>\r<br>What should you do?<\/div><input type='hidden' name='question_id[]' id='qID_7' value='8034' \/><input type='hidden' id='answerType8034' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-8034[]' id='answer-id-33407' class='answer   answerof-8034 ' value='33407'   \/><label for='answer-id-33407' id='answer-label-33407' class=' answer'><span>Create a query that uses a file source, and then use the Count Values command on the Transform tab.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-8034[]' id='answer-id-33408' class='answer   answerof-8034 ' value='33408'   \/><label for='answer-id-33408' id='answer-label-33408' class=' answer'><span>Create a query that uses a folder source, and then use the Group By command on the Home tab.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-8034[]' id='answer-id-33409' class='answer   answerof-8034 ' value='33409'   \/><label for='answer-id-33409' id='answer-label-33409' class=' answer'><span>Create a query that uses a file source, and then use the Group By command on the Home tab.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-8034[]' id='answer-id-33410' class='answer   answerof-8034 ' value='33410'   \/><label for='answer-id-33410' id='answer-label-33410' class=' answer'><span>Create a query that uses a folder source, and then use the Count Values command on the Transform tab.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-8' style=';'><div id='questionWrap-8'  class='   watupro-question-id-8035'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>8. <\/span>You have a data model in Excel. <br \/>\r<br>You export the data and the data model into a dataset in the Microsoft Power BI service. <br \/>\r<br>What can you use to modify the data model that is published to the Power BI service?<\/div><input type='hidden' name='question_id[]' id='qID_8' value='8035' \/><input type='hidden' id='answerType8035' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-8035[]' id='answer-id-33411' class='answer   answerof-8035 ' value='33411'   \/><label for='answer-id-33411' id='answer-label-33411' class=' answer'><span>Microsoft Power BI Desktop<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-8035[]' id='answer-id-33412' class='answer   answerof-8035 ' value='33412'   \/><label for='answer-id-33412' id='answer-label-33412' class=' answer'><span>Excel and the Microsoft Power BI service<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-8035[]' id='answer-id-33413' class='answer   answerof-8035 ' value='33413'   \/><label for='answer-id-33413' id='answer-label-33413' class=' answer'><span>Excel only<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-8035[]' id='answer-id-33414' class='answer   answerof-8035 ' value='33414'   \/><label for='answer-id-33414' id='answer-label-33414' class=' answer'><span>the Microsoft Power BI service only<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-9' style=';'><div id='questionWrap-9'  class='   watupro-question-id-8036'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>9. <\/span>You have a table named Sales that has three columns named Region, Country, and SalesAmount. <br \/>\r<br>You create a PivotTable as shown in the following exhibit. <br \/>\r<br><br><img decoding=\"async\" border=0 width=187 height=172 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V8.files\/image068.jpg\" v:shapes=\"Picture_x0020_36\"><br><br \/>\r<br>You need to ensure that the PivotTable appears in three columns as shown in the following exhibit. <br \/>\r<br><br><img decoding=\"async\" border=0 width=292 height=130 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V8.files\/image070.jpg\" v:shapes=\"Picture_x0020_37\"><br><\/div><input type='hidden' name='question_id[]' id='qID_9' value='8036' \/><input type='hidden' id='answerType8036' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-8036[]' id='answer-id-33415' class='answer   answerof-8036 ' value='33415'   \/><label for='answer-id-33415' id='answer-label-33415' class=' answer'><span>On the Design tab, click Report Layout and then click Show in Compact Form.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-8036[]' id='answer-id-33416' class='answer   answerof-8036 ' value='33416'   \/><label for='answer-id-33416' id='answer-label-33416' class=' answer'><span>Move Country from the Rows area to the Columns area.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-8036[]' id='answer-id-33417' class='answer   answerof-8036 ' value='33417'   \/><label for='answer-id-33417' id='answer-label-33417' class=' answer'><span>Move Country from the Rows area to the Values area.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-8036[]' id='answer-id-33418' class='answer   answerof-8036 ' value='33418'   \/><label for='answer-id-33418' id='answer-label-33418' class=' answer'><span>On the Design tab, click Report Layout and then click Show in Tabular Form.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-10' style=';'><div id='questionWrap-10'  class='   watupro-question-id-8037'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>10. <\/span>You have a pie chart. <br \/>\r<br>You need the wedges of the pie chart to be separated as shown in the following exhibit. <br \/>\r<br><br><img decoding=\"async\" border=0 width=372 height=246 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V8.files\/image071.jpg\" alt=Untitled v:shapes=\"Picture_x0020_38\"><br><\/div><input type='hidden' name='question_id[]' id='qID_10' value='8037' \/><input type='hidden' id='answerType8037' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-8037[]' id='answer-id-33419' class='answer   answerof-8037 ' value='33419'   \/><label for='answer-id-33419' id='answer-label-33419' class=' answer'><span>Change the chart type to Pie of Pie.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-8037[]' id='answer-id-33420' class='answer   answerof-8037 ' value='33420'   \/><label for='answer-id-33420' id='answer-label-33420' class=' answer'><span>Right-click the pie chart, click Expand\/Collapse, and then click Expand.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-8037[]' id='answer-id-33421' class='answer   answerof-8037 ' value='33421'   \/><label for='answer-id-33421' id='answer-label-33421' class=' answer'><span>Right-click the pie chart, click Expand\/Collapse, and Then click Expand Entire Field<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-8037[]' id='answer-id-33422' class='answer   answerof-8037 ' value='33422'   \/><label for='answer-id-33422' id='answer-label-33422' class=' answer'><span>Select a wedge of the pie chart and then drag the wedge.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-11' style=';'><div id='questionWrap-11'  class='   watupro-question-id-8038'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>11. <\/span>You need to create a PivotChart that has a filter as shown in the following exhibit. <br \/>\r<br><br><img decoding=\"async\" border=0 width=362 height=277 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V8.files\/image073.jpg\" alt=Untitled v:shapes=\"Picture_x0020_39\"><br><\/div><input type='hidden' name='question_id[]' id='qID_11' value='8038' \/><input type='hidden' id='answerType8038' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-8038[]' id='answer-id-33423' class='answer   answerof-8038 ' value='33423'   \/><label for='answer-id-33423' id='answer-label-33423' class=' answer'><span>From the model, create a measure.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-8038[]' id='answer-id-33424' class='answer   answerof-8038 ' value='33424'   \/><label for='answer-id-33424' id='answer-label-33424' class=' answer'><span>From Query Editor, create a function.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-8038[]' id='answer-id-33425' class='answer   answerof-8038 ' value='33425'   \/><label for='answer-id-33425' id='answer-label-33425' class=' answer'><span>From Query Editor, create a parameter.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-8038[]' id='answer-id-33426' class='answer   answerof-8038 ' value='33426'   \/><label for='answer-id-33426' id='answer-label-33426' class=' answer'><span>From the model, create a hierarchy.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-12' style=';'><div id='questionWrap-12'  class='   watupro-question-id-8039'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>12. <\/span>DRAG DROP <br \/>\r<br>You create a new workbook and add a table to a data model. The data is shown in the following table. <br \/>\r<br><br><img decoding=\"async\" border=0 width=319 height=156 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V8.files\/image074.jpg\" alt=Untitled v:shapes=\"Picture_x0020_40\"><br><br \/>\r<br>You need to create a visualization as shown in the following exhibit. <br \/>\r<br><br><img decoding=\"async\" border=0 width=308 height=120 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V8.files\/image075.jpg\" alt=Untitled v:shapes=\"Picture_x0020_41\"><br><br \/>\r<br>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. <br \/>\r<br><br><img decoding=\"async\" border=0 width=493 height=135 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V8.files\/image077.jpg\" alt=Untitled v:shapes=\"Picture_x0020_42\"><br><\/div><input type='hidden' name='question_id[]' id='qID_12' value='8039' \/><input type='hidden' id='answerType8039' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-8039[]' id='textarea_q_8039' class='watupro-textarea-medium' rows='5' cols='80'><\/textarea>\n<\/p><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-13' style=';'><div id='questionWrap-13'  class='   watupro-question-id-8040'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>13. <\/span>You have the data model shown in the Data Model exhibit. (Click the Exhibit button.) <br \/>\r<br><br><img decoding=\"async\" border=0 width=256 height=370 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V8.files\/image081.jpg\" v:shapes=\"Picture_x0020_156\"><br><br \/>\r<br>You have the PivotChart shown in the Pivot Chart exhibit. (Click the Exhibit button.) <br \/>\r<br><br><img decoding=\"async\" border=0 width=469 height=299 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V8.files\/image082.jpg\" alt=Untitled v:shapes=\"Picture_x0020_158\"><br><br \/>\r<br>You need to change the current view of the PivotChart to display ProductCategory only. <br \/>\r<br>What should you do?<\/div><input type='hidden' name='question_id[]' id='qID_13' value='8040' \/><input type='hidden' id='answerType8040' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-8040[]' id='answer-id-33428' class='answer   answerof-8040 ' value='33428'   \/><label for='answer-id-33428' id='answer-label-33428' class=' answer'><span>Double-click a bar in the PivotChart.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-8040[]' id='answer-id-33429' class='answer   answerof-8040 ' value='33429'   \/><label for='answer-id-33429' id='answer-label-33429' class=' answer'><span>Click the - button.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-8040[]' id='answer-id-33430' class='answer   answerof-8040 ' value='33430'   \/><label for='answer-id-33430' id='answer-label-33430' class=' answer'><span>Right-click the PivotChart and click Reset to Match Style.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-8040[]' id='answer-id-33431' class='answer   answerof-8040 ' value='33431'   \/><label for='answer-id-33431' id='answer-label-33431' class=' answer'><span>Right-click a bar in the PivotChart and click Expand Entire Field.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-14' style=';'><div id='questionWrap-14'  class='   watupro-question-id-8041'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>14. <\/span>You have a KPI named Goal that calculates the sales from the previous year and multiplies the sales by 1.1. <br \/>\r<br>You need to modify Goal to multiply the sales from the previous year by 1.15. <br \/>\r<br>What should you do?<\/div><input type='hidden' name='question_id[]' id='qID_14' value='8041' \/><input type='hidden' id='answerType8041' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-8041[]' id='answer-id-33432' class='answer   answerof-8041 ' value='33432'   \/><label for='answer-id-33432' id='answer-label-33432' class=' answer'><span>From Power Pivot, modify the measure.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-8041[]' id='answer-id-33433' class='answer   answerof-8041 ' value='33433'   \/><label for='answer-id-33433' id='answer-label-33433' class=' answer'><span>From the properties of the KPI, modify the KPI base field.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-8041[]' id='answer-id-33434' class='answer   answerof-8041 ' value='33434'   \/><label for='answer-id-33434' id='answer-label-33434' class=' answer'><span>From Power Pivot, create a new calculated column, and then modify the KP<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-8041[]' id='answer-id-33435' class='answer   answerof-8041 ' value='33435'   \/><label for='answer-id-33435' id='answer-label-33435' class=' answer'><span>From the properties of the KPI, modify the absolute value.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-15' style=';'><div id='questionWrap-15'  class='   watupro-question-id-8042'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>15. <\/span>DRAG DROP <br \/>\r<br>You have a data model that contains a table named SalesOrders has four columns named Orderld, SalesAmount, OrderDate, and Territory. <br \/>\r<br>You plan to create a PivotChart that will display the percentage of SalesAmount for each Territory. <br \/>\r<br>You need to create a measure to calculate the percentage of sales of each territory. <br \/>\r<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. <br \/>\r<br><br><img decoding=\"async\" border=0 width=623 height=166 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V8.files\/image084.jpg\" v:shapes=\"Picture_x0020_35\"><br><\/div><input type='hidden' name='question_id[]' id='qID_15' value='8042' \/><input type='hidden' id='answerType8042' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-8042[]' id='textarea_q_8042' class='watupro-textarea-medium' rows='5' cols='80'><\/textarea>\n<\/p><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-16' style=';'><div id='questionWrap-16'  class='   watupro-question-id-8043'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>16. <\/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 \/>\r<br>You need to create a relationship between Date and Invoices. <br \/>\r<br>What should you do first?<\/div><input type='hidden' name='question_id[]' id='qID_16' value='8043' \/><input type='hidden' id='answerType8043' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-8043[]' id='answer-id-33437' class='answer   answerof-8043 ' value='33437'   \/><label for='answer-id-33437' id='answer-label-33437' class=' answer'><span>Change the Data Type of InvoiceDate and DateID to Text.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-8043[]' id='answer-id-33438' class='answer   answerof-8043 ' value='33438'   \/><label for='answer-id-33438' id='answer-label-33438' class=' answer'><span>Create a measure in Invoices that uses the Format DAX Function.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-8043[]' id='answer-id-33439' class='answer   answerof-8043 ' value='33439'   \/><label for='answer-id-33439' id='answer-label-33439' class=' answer'><span>Change the Data Type of DateID to Date.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-8043[]' id='answer-id-33440' class='answer   answerof-8043 ' value='33440'   \/><label for='answer-id-33440' id='answer-label-33440' class=' answer'><span>Create a calculated column in Invoices that uses the Format DAX function.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-17' style=';'><div id='questionWrap-17'  class='   watupro-question-id-8044'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>17. <\/span>You have the following table. <br \/>\r<br><br><img decoding=\"async\" border=0 width=325 height=322 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V8.files\/image085.jpg\" v:shapes=\"Picture_x0020_361\"><br><br \/>\r<br>You plan to use [Month Name] as the axis in a PivotChart. <br \/>\r<br>You need to ensure that whenever [Month Name] is used in a chart, the months are displayed chronologically be default. <br \/>\r<br>What should you do?<\/div><input type='hidden' name='question_id[]' id='qID_17' value='8044' \/><input type='hidden' id='answerType8044' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-8044[]' id='answer-id-33441' class='answer   answerof-8044 ' value='33441'   \/><label for='answer-id-33441' id='answer-label-33441' class=' answer'><span>Sort the [Month Name] column by [Month Name].<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-8044[]' id='answer-id-33442' class='answer   answerof-8044 ' value='33442'   \/><label for='answer-id-33442' id='answer-label-33442' class=' answer'><span>Change the Data Type of [Month Name] to Date.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-8044[]' id='answer-id-33443' class='answer   answerof-8044 ' value='33443'   \/><label for='answer-id-33443' id='answer-label-33443' class=' answer'><span>Sort the [Month Name] column by [Month Name].<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-8044[]' id='answer-id-33444' class='answer   answerof-8044 ' value='33444'   \/><label for='answer-id-33444' id='answer-label-33444' class=' answer'><span>Add a calculated column named [ID] that use the [Month Name] &amp; [Month Number] DAX formula<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-18' style=';'><div id='questionWrap-18'  class='   watupro-question-id-8045'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>18. <\/span>You have a table in Power Pivot model that is loaded from a Microsoft SQL Server database. <br \/>\r<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 \/>\r<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 \/>\r<br>What should you do?<\/div><input type='hidden' name='question_id[]' id='qID_18' value='8045' \/><input type='hidden' id='answerType8045' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-8045[]' id='answer-id-33445' class='answer   answerof-8045 ' value='33445'   \/><label for='answer-id-33445' id='answer-label-33445' class=' answer'><span>Replace the Total column by using a measure.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-8045[]' id='answer-id-33446' class='answer   answerof-8045 ' value='33446'   \/><label for='answer-id-33446' id='answer-label-33446' class=' answer'><span>Replace the Total column by using a calculated column.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-8045[]' id='answer-id-33447' class='answer   answerof-8045 ' value='33447'   \/><label for='answer-id-33447' id='answer-label-33447' class=' answer'><span>From Query Editor, remove duplicate rows from the table.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-8045[]' id='answer-id-33448' class='answer   answerof-8045 ' value='33448'   \/><label for='answer-id-33448' id='answer-label-33448' class=' answer'><span>Move the Total column to a lookup table.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-19' style=';'><div id='questionWrap-19'  class='   watupro-question-id-8046'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>19. <\/span>DRAG DROP <br \/>\r<br>You have a model that contains the following table named Sales. <br \/>\r<br><br><img decoding=\"async\" border=0 width=623 height=107 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V8.files\/image087.jpg\" v:shapes=\"Picture_x0020_371\"><br><br \/>\r<br>You have measure named TotalSales that calculates the sum of Line Total. <br \/>\r<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. <br \/>\r<br><br><img decoding=\"async\" border=0 width=624 height=212 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V8.files\/image089.jpg\" v:shapes=\"Picture_x0020_381\"><br><br \/>\r<br><br><img decoding=\"async\" border=0 width=624 height=183 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V8.files\/image091.jpg\" v:shapes=\"Picture_x0020_391\"><br><br \/>\r<br>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 \/>\r<br>NOTE: Each correct selection is wroth on point. <br \/>\r<br><br><img decoding=\"async\" border=0 width=624 height=152 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V8.files\/image093.jpg\" v:shapes=\"Picture_x0020_110\"><br><\/div><input type='hidden' name='question_id[]' id='qID_19' value='8046' \/><input type='hidden' id='answerType8046' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-8046[]' id='textarea_q_8046' class='watupro-textarea-medium' rows='5' cols='80'><\/textarea>\n<\/p><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-20' style=';'><div id='questionWrap-20'  class='   watupro-question-id-8047'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>20. <\/span>HOTSPOT <br \/>\r<br>You have a table named Date that contains the following data. <br \/>\r<br><br><img decoding=\"async\" border=0 width=623 height=510 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V8.files\/image095.jpg\" v:shapes=\"Picture_x0020_7\"><br><br \/>\r<br>You plan to create Pivot Charts that will be sliced by MonthName. <br \/>\r<br>You need to create a relationship between Sales and Date. <br \/>\r<br>Which Columns should you use to create the relationship? To answer, select the appropriate options in the answer area. <br \/>\r<br>NOTE: Each correct selection is worth one point. <br \/>\r<br><br><img decoding=\"async\" border=0 width=314 height=217 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-779%20V8.files\/image097.gif\" v:shapes=\"Picture_x0020_168\"><br><\/div><input type='hidden' name='question_id[]' id='qID_20' value='8047' \/><input type='hidden' id='answerType8047' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-8047[]' id='textarea_q_8047' class='watupro-textarea-medium' rows='5' cols='80'><\/textarea>\n<\/p><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div style='display:none' id='question-21'>\n\t<div class='question-content'>\n\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/plugins\/watupro\/img\/loading.gif\" width=\"16\" height=\"16\" alt=\"Loading...\" title=\"Loading...\" \/>&nbsp;Loading...\t<\/div>\n<\/div>\n\n<br \/>\n\t\n\t\t\t<div class=\"watupro_buttons flex \" id=\"watuPROButtons415\" >\n\t\t  <div id=\"prev-question\" style=\"display:none;\"><input type=\"button\" value=\"&lt; Previous\" onclick=\"WatuPRO.nextQuestion(event, 'previous');\"\/><\/div>\t\t  \t\t  \t\t   \n\t\t   \t  \t\t<div><input type=\"button\" name=\"action\" class=\"watupro-submit-button\" onclick=\"WatuPRO.submitResult(event)\" id=\"action-button\" value=\"View Results\"  \/>\n\t\t<\/div>\n\t\t<\/div>\n\t\t\n\t<input type=\"hidden\" name=\"quiz_id\" value=\"415\" id=\"watuPROExamID\"\/>\n\t<input type=\"hidden\" name=\"start_time\" id=\"startTime\" value=\"2026-05-06 15:46:51\" \/>\n\t<input type=\"hidden\" name=\"start_timestamp\" id=\"startTimeStamp\" value=\"1778082411\" \/>\n\t<input type=\"hidden\" name=\"question_ids\" value=\"\" \/>\n\t<input type=\"hidden\" name=\"watupro_questions\" value=\"8028:33386 | 8029:33387,33388,33389,33390 | 8030:33391,33392,33393,33394 | 8031:33395,33396,33397,33398 | 8032:33399,33400,33401,33402 | 8033:33403,33404,33405,33406 | 8034:33407,33408,33409,33410 | 8035:33411,33412,33413,33414 | 8036:33415,33416,33417,33418 | 8037:33419,33420,33421,33422 | 8038:33423,33424,33425,33426 | 8039:33427 | 8040:33428,33429,33430,33431 | 8041:33432,33433,33434,33435 | 8042:33436 | 8043:33437,33438,33439,33440 | 8044:33441,33442,33443,33444 | 8045:33445,33446,33447,33448 | 8046:33449 | 8047:33450\" \/>\n\t<input type=\"hidden\" name=\"no_ajax\" value=\"0\">\t\t\t<\/form>\n\t<p>&nbsp;<\/p>\n<\/div>\n\n<script type=\"text\/javascript\">\n\/\/jQuery(document).ready(function(){\ndocument.addEventListener(\"DOMContentLoaded\", function(event) { \t\nvar question_ids = \"8028,8029,8030,8031,8032,8033,8034,8035,8036,8037,8038,8039,8040,8041,8042,8043,8044,8045,8046,8047\";\nWatuPROSettings[415] = {};\nWatuPRO.qArr = question_ids.split(',');\nWatuPRO.exam_id = 415;\t    \nWatuPRO.post_id = 1137;\nWatuPRO.store_progress = 0;\nWatuPRO.curCatPage = 1;\nWatuPRO.requiredIDs=\"0\".split(\",\");\nWatuPRO.hAppID = \"0.54873300 1778082411\";\nvar url = \"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/plugins\/watupro\/show_exam.php\";\nWatuPRO.examMode = 1;\nWatuPRO.siteURL=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-admin\/admin-ajax.php\";\nWatuPRO.emailIsNotRequired = 0;\nWatuPROIntel.init(415);\nWatuPRO.inCategoryPages=1;});    \t \n<\/script>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Test 70-779 Analyzing and Visualizing Data with Microsoft Excel Dumps Online now. 70-779 exam is one of the requirements for MCSA:BI Reporting certification. Before taking 70-779 exam, you should know the exam skills: Published: July 31, 2017 Languages: English Audiences: BI professionals, data analysts Technology: Microsoft Excel, Power BI Credit toward certification: MCP, MCSA Passing [&hellip;]<\/p>\n","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,3067,3069,3074,3071,3070,3072,3073],"class_list":["post-1137","post","type-post","status-publish","format-standard","hentry","category-mcsa","category-microsoft","tag-70-779","tag-70-779-dumps","tag-70-779-dumps-questions","tag-70-779-exam-dumps","tag-70-779-exam-questions","tag-70-779-free-dumps","tag-70-779-free-questions","tag-70-779-questions"],"_links":{"self":[{"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/posts\/1137","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=1137"}],"version-history":[{"count":1,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/posts\/1137\/revisions"}],"predecessor-version":[{"id":1138,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/posts\/1137\/revisions\/1138"}],"wp:attachment":[{"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/media?parent=1137"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/categories?post=1137"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/tags?post=1137"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}