{"id":3319,"date":"2026-03-18T11:54:28","date_gmt":"2026-03-18T11:54:28","guid":{"rendered":"https:\/\/blog.examboosts.com\/?p=3319"},"modified":"2026-03-18T11:54:28","modified_gmt":"2026-03-18T11:54:28","slug":"analytics-con-301-questions-prepare-with-learning-information-2026-regularly-updated-q44-q63","status":"publish","type":"post","link":"https:\/\/blog.examboosts.com\/ja\/2026\/03\/analytics-con-301-questions-prepare-with-learning-information-2026-regularly-updated-q44-q63\/","title":{"rendered":"Analytics-Con-301 Questions Prepare with Learning Information! 2026 Regularly updated [Q44-Q63]"},"content":{"rendered":"\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-left kksr-valign-top\"\n    data-payload='{&quot;align&quot;:&quot;left&quot;,&quot;id&quot;:&quot;3319&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;top&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;0&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;0&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;Rate this post&quot;,&quot;legend&quot;:&quot;0\\\/5 - (0 votes)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;Analytics-Con-301 Questions Prepare with Learning Information! 2026 Regularly updated [Q44-Q63]&quot;,&quot;width&quot;:&quot;0&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 0px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            <span class=\"kksr-muted\">Rate this post<\/span>\n    <\/div>\n    <\/div>\n<p><span style=\"font-size: 18px\"><strong><span style=\"color: red\">Analytics-Con-301 Questions Prepare with Learning Information! 2026 Regularly updated<\/span><\/strong><\/span><\/p>\n<p><strong><span style=\"color: red\">Get Analytics-Con-301 Products Practice Material for Analytics-Con-301 Exam Question Preparation<\/span><\/strong><\/p>\n<p><\/p>\n<h3>Salesforce Analytics-Con-301 Exam Syllabus Topics:<\/h3>\n<table border=\"1\" cellpadding=\"1\" cellspacing=\"1\" style=\"width:100%\">\n<tr>\n<th width=\"100px\">Topic<\/th>\n<th>Details<\/th>\n<\/tr>\n<tr>\n<td>Topic 1<\/td>\n<td>\n<ul>\n<li>Data Analysis: This domain targets Tableau Consultants to plan and prepare data connections effectively. It includes recommending data transformation strategies, designing row-level security (RLS) data structures, and implementing advanced data connections such as Web Data Connectors and Tableau Bridge. Skills in specifying granularity and aggregation strategies for data sources across Tableau products are emphasized.<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<tr>\n<td>Topic 2<\/td>\n<td>\n<ul>\n<li>Data Management: This part focuses on establishing governance and support for published content. Tableau Consultants are expected to manage data security, publish and maintain data sources and workbooks, and oversee content access. It includes applying governance best practices, using metadata APIs, and supporting administration functions to maintain data integrity and accessibility.<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<tr>\n<td>Topic 3<\/td>\n<td>\n<ul>\n<li>Business Consulting: For Tableau Consultants, this section involves designing and troubleshooting calculations and workbooks to meet advanced analytical use cases. It covers selecting appropriate chart types, applying Tableau\u2019s order of operations in calculations, building interactivity into dashboards, and optimizing workbook performance by resolving resource-intensive queries and other design-related issues.<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<\/table>\n<p><\/p>\n<p>&nbsp;<\/p>\n<div id=\"watu_quiz\" class=\"quiz-area single-page-quiz\">\n<form action=\"\" method=\"post\" class=\"quiz-form \" id=\"quiz-1256\" >\n<div class='watu-question' id='question-1'><div class='question-content'><p><strong>Q44.<\/strong> A client currently has a workbook with the table shown below.<br \/><img decoding=\"async\" src=\"https:\/\/blog.examboosts.com\/wp-content\/uploads\/2026\/03\/Analytics-Con-301-d9e09dbe86fa28a3caf92d731a441838.jpg\"\/><br \/>Which method will produce the output for the Total Sales Value field for all the categories shown in the table?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='24877' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96238' \/><div class='watu-question-choice'><input type='radio' name='answer-24877[]' id='answer-id-96238' class='answer answer-1 js-answer-label answerof-24877' value='96238' \/>&nbsp;<label for='answer-id-96238' id='answer-label-96238' class='js-answer-label answer label-1'><span class='answer'>Quick Table Calculation<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96239' \/><div class='watu-question-choice'><input type='radio' name='answer-24877[]' id='answer-id-96239' class='answer answer-1 js-answer-label answerof-24877' value='96239' \/>&nbsp;<label for='answer-id-96239' id='answer-label-96239' class='js-answer-label answer label-1'><span class='answer'>A Window Function<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96240' \/><div class='watu-question-choice'><input type='radio' name='answer-24877[]' id='answer-id-96240' class='answer answer-1 php-answer-label answerof-24877' value='96240' \/>&nbsp;<label for='answer-id-96240' id='answer-label-96240' class='php-answer-label answer label-1'><span class='answer'>Level of Detail (LOD) Calculation<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96241' \/><div class='watu-question-choice'><input type='radio' name='answer-24877[]' id='answer-id-96241' class='answer answer-1 js-answer-label answerof-24877' value='96241' \/>&nbsp;<label for='answer-id-96241' id='answer-label-96241' class='js-answer-label answer label-1'><span class='answer'>MAX() Function<\/span><\/label><\/div>\n<\/div><div class='show-question-feedback' style='display:none;'>To calculate the Total Sales Value for all categories as displayed in the table, an LOD expression is ideal. An LOD calculation in Tableau allows you to compute values at the data level that is different from the view level. In this case, since the Total Sales Value appears consistent across different sub-categories within each category, an LOD expression can be used to fix the Total Sales Value irrespective of the sub-category detail.<br\/>Here&#8217;s how to set it up:<br\/>* Go to the Calculations area by right-clicking in the data pane and selecting &#8220;Create Calculated Field&#8221;.<br\/>* Enter a name for the calculation, such as &#8220;Total Sales Value&#8221;.<br\/>* Enter the LOD expression: { FIXED [Category] : SUM([Sales]) }. This calculation fixes the total sales to the category level, effectively summing sales for all sub-categories within each category, irrespective of how the data is broken down in the view.<br\/>* Drag this new calculated field into your visualization alongside the existing measures.<br\/>This method ensures that the Total Sales Value reflects the total for each category across all its sub-categories, matching the uniform values shown across different rows for each category in your table.<br\/>References<br\/>The explanation utilizes the concept of Level of Detail calculations in Tableau, which allows for advanced aggregations independent of the view level details. This concept is covered extensively in Tableau&#8217;s official documentation and relevant training materials such as Tableau&#8217;s online help resources.<\/div><input type='button' class='showchecked' style='margin: 10px 0;' onclick='showanswer1(1,this)' id='btn-1' value='See Answer'  \/><input type='hidden' id='questionType1' value='radio' class=''><\/div><div class='watu-question' id='question-2'><div class='question-content'><p><strong>Q45.<\/strong> A Tableau consultant tasked with evaluating a data structure is handed the below sample dataset.<br \/>Which two statements are true about the dataset? Choose two.<br \/><img decoding=\"async\" src=\"https:\/\/blog.examboosts.com\/wp-content\/uploads\/2026\/03\/Analytics-Con-301-d3633d2f42821de4fabc3e63ab5868be.jpg\"\/><\/p>\n<\/div><input type='hidden' name='question_id[]' value='24878' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96242' \/><div class='watu-question-choice'><input type='checkbox' name='answer-24878[]' id='answer-id-96242' class='answer answer-2 php-answer-label answerof-24878' value='96242' \/>&nbsp;<label for='answer-id-96242' id='answer-label-96242' class='php-answer-label answer label-2'><span class='answer'>The data structure will require a lot of maintenance, as maintenance will need to be done to handle a new column for a new year.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96243' \/><div class='watu-question-choice'><input type='checkbox' name='answer-24878[]' id='answer-id-96243' class='answer answer-2 js-answer-label answerof-24878' value='96243' \/>&nbsp;<label for='answer-id-96243' id='answer-label-96243' class='js-answer-label answer label-2'><span class='answer'>The names of the columns are accurate and indicate what the data values actually mean.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96244' \/><div class='watu-question-choice'><input type='checkbox' name='answer-24878[]' id='answer-id-96244' class='answer answer-2 php-answer-label answerof-24878' value='96244' \/>&nbsp;<label for='answer-id-96244' id='answer-label-96244' class='php-answer-label answer label-2'><span class='answer'>The data can be pivoted in order to enable a year selector.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96245' \/><div class='watu-question-choice'><input type='checkbox' name='answer-24878[]' id='answer-id-96245' class='answer answer-2 js-answer-label answerof-24878' value='96245' \/>&nbsp;<label for='answer-id-96245' id='answer-label-96245' class='js-answer-label answer label-2'><span class='answer'>The data needs to be denormalized before it can be used.<\/span><\/label><\/div>\n<\/div><div class='show-question-feedback' style='display:none;'>The dataset shown is a classic &#8220;wide&#8221; format&#8221;:<br\/>* A single row per state<br\/>* Separate columns for each year: 2019, 2020, 2021, 2022, 2023, 2024<br\/>Tableau&#8217;s documentation on data structure and pivoting explains:<br\/># Why A is TRUE<br\/>Tableau documentation identifies wide datasets (multiple columns representing categories such as years, months, or similar time periods) as high-maintenance structures because:<br\/>* For every new year, a new column must be added.<br\/>* Metadata and calculations must be updated each time.<br\/>* This type of structure is described as having poor scalability and higher maintenance.<br\/>This dataset fits that exact description, so A is correct.<br\/># Why C is TRUE<br\/>According to Tableau&#8217;s &#8220;Pivot Data from Columns to Rows&#8221; section:<br\/>* Wide datasets can and should often be pivoted so that repeated columns (such as year columns) become rows.<br\/>* Pivoting enables dynamic capabilities such as:<br\/>* Year filters (year selector)<br\/>* Time-series analysis<br\/>* Consistent aggregations<br\/>* Simplified calculations<br\/>Pivoting this dataset would produce:<br\/>State<br\/>Year<br\/>Value<br\/>Alabama<br\/>2019<br\/>2300.39<br\/>Alabama<br\/>2020<br\/>3030.39<br\/>&#8230;<br\/>&#8230;<br\/>&#8230;<br\/>This makes the dataset tall and tidy, which Tableau identifies as better for analysis and dashboard interactivity.<br\/>Therefore, C is correct.<br\/># Why B is FALSE<br\/>The column names (2019, 2020, 2021&#8230;) are simply numbers.<br\/>Tableau documentation stresses that good metadata includes descriptive column names.<br\/>These column names:<br\/>* Do not indicate what the measure represents (Revenue? Sales? Population?)<br\/>* Only show the year, not the meaning of the metric<br\/>Thus they are not considered accurate or descriptive column names.<br\/># Why D is FALSE<br\/>The dataset is already denormalized, not normalized.<br\/>Denormalized data means combining multiple attributes (like multiple years) into one table, which is exactly what this dataset already does.<br\/>Tableau documentation explains that wide data is already denormalized, and the recommended fix is pivoting, not further denormalization.<br\/>Therefore, D is incorrect.<\/div><input type='button' class='showchecked' style='margin: 10px 0;' onclick='showanswer1(2,this)' id='btn-2' value='See Answer'  \/><input type='hidden' id='questionType2' value='checkbox' class=''><\/div><div class='watu-question' id='question-3'><div class='question-content'><p><strong>Q46.<\/strong> A consultant creates a histogram that presents the distribution of profits across a client&#8217;s customers. The labels on the bars show percent shares. The consultant used a quick table calculation to create the labels.<br \/>Now, the client wants to limit the view to the bins that have at least a 15% share. The consultant creates a profit filter but it changes the percent labels.<br \/>Which approach should the consultant use to produce the desired result?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='24879' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96246' \/><div class='watu-question-choice'><input type='radio' name='answer-24879[]' id='answer-id-96246' class='answer answer-3 js-answer-label answerof-24879' value='96246' \/>&nbsp;<label for='answer-id-96246' id='answer-label-96246' class='js-answer-label answer label-3'><span class='answer'>Use a calculation with TOTAL() function instead of a quick table calculation.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96247' \/><div class='watu-question-choice'><input type='radio' name='answer-24879[]' id='answer-id-96247' class='answer answer-3 php-answer-label answerof-24879' value='96247' \/>&nbsp;<label for='answer-id-96247' id='answer-label-96247' class='php-answer-label answer label-3'><span class='answer'>Add the [Profit] filter to the context.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96248' \/><div class='watu-question-choice'><input type='radio' name='answer-24879[]' id='answer-id-96248' class='answer answer-3 js-answer-label answerof-24879' value='96248' \/>&nbsp;<label for='answer-id-96248' id='answer-label-96248' class='js-answer-label answer label-3'><span class='answer'>Filter with a table calculation WINDOW_AVG(MIN([Profit]), first(), last())<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96249' \/><div class='watu-question-choice'><input type='radio' name='answer-24879[]' id='answer-id-96249' class='answer answer-3 js-answer-label answerof-24879' value='96249' \/>&nbsp;<label for='answer-id-96249' id='answer-label-96249' class='js-answer-label answer label-3'><span class='answer'>Filter with the table calculation used to create labels.<\/span><\/label><\/div>\n<\/div><div class='show-question-feedback' style='display:none;'>When a filter is applied directly to the view, it can affect the calculation of percentages in a histogram because it changes the underlying data that the quick table calculation is based on. To avoid this, adding the [Profit] filter to the context will maintain the original calculation of percent shares while filtering out bins with less than a 15% share. This is because context filters are applied before any other calculations, so the percent shares calculated will be based on the context-filtered data, thus preserving the integrity of the original percent labels.<br\/>References: The solution is based on the principles of context filters and their order of operations in Tableau, which are documented in Tableau&#8217;s official resources and community discussions123.<br\/>When a histogram is created showing the distribution of profits with labels indicating percent shares using a quick table calculation, and a need arises to limit the view to bins with at least a 15% share, applying a standard profit filter directly may undesirably alter how the percent labels calculate because they depend on the overall distribution of data. Placing the [Profit] filter into the context makes it a &#8220;context filter,&#8221; which effectively changes how data is filtered in calculations:<br\/>Create a Context Filter: Right-click on the profit filter and select &#8220;Add to Context&#8221;. This action changes the order of operations in filtering, meaning the context filter is applied first.<br\/>Adjust the Percent Calculation: With the profit filter set in the context, it first reduces the data set to only those profits that meet the filter criteria. Subsequently, any table calculations (like the percent share labels) are computed based on this reduced data set.<br\/>View Update: The view now updates to display only those bins where the profits are at least 15%, and the percent share labels recalculated to reflect the distribution of only the filtered (contextual) data.<br\/>References:<br\/>Context Filters in Tableau: Context filters are used to filter the data passed down to other filters, calculations, the marks card, and the view. By setting the profit filter as a context filter, it ensures that calculations such as the percentage shares are based only on the filtered subset of the data.<\/div><input type='button' class='showchecked' style='margin: 10px 0;' onclick='showanswer1(3,this)' id='btn-3' value='See Answer'  \/><input type='hidden' id='questionType3' value='radio' class=''><\/div><div class='watu-question' id='question-4'><div class='question-content'><p><strong>Q47.<\/strong> From the desktop, open the CC workbook.<br \/>Open the Incremental worksheet.<br \/>You need to add a line to the chart that<br \/>shows the cumulative percentage of sales<br \/>contributed by each product to the<br \/>incremental sales.<br \/>From the File menu in Tableau Desktop, click<br \/>Save.<\/p>\n<\/div><input type='hidden' name='question_id[]' value='24880' \/><textarea name='answer-24880[]' rows='5' cols='40' id='textarea_q_24880' class='watu-textarea watu-textarea-4'><\/textarea><div class='watu-questions-wrap '><\/div><div class='show-question-feedback' style='display:none;'>See the complete Steps below in Explanation:<br\/>Explanation:<br\/>To add a line showing the cumulative percentage of sales contributed by each product to the incremental sales in the Incremental worksheet of your Tableau Desktop, follow these detailed steps:<br\/>* Open the CC Workbook and Access the Worksheet:<br\/>* From the desktop, double-click on the CC workbook to open it in Tableau Desktop.<br\/>* Navigate to the Incremental worksheet by clicking on its tab at the bottom of the window.<br\/>* Calculate Cumulative Sales Percentage:<br\/>* Create a new calculated field to compute the cumulative percentage of sales. Right-click in the Data pane and select &#8216;Create Calculated Field&#8217;.<br\/>* Name this field &#8220;Cumulative Sales Percentage&#8221;.<br\/>* Enter the following formula to calculate the running sum of sales as a percentage of the total sales:<br\/>(RUNNING_SUM(SUM([Sales])) \/ TOTAL(SUM([Sales])) [Sales]))<br\/>* Click &#8216;OK&#8217; to save the calculated field.<br\/>* Add the Cumulative Sales Percentage Line to the Chart:<br\/>* Drag the &#8220;Cumulative Sales Percentage&#8221; field to the Rows shelf, placing it next to the existing Sales measure.<br\/>* Ensure that the cumulative line appears as a continuous line. Right-click on the &#8220;Cumulative Sales Percentage&#8221; field on the Rows shelf, select &#8216;Change Chart Type&#8217;, and choose &#8216;Line&#8217;.<br\/>* Adjust the axis to synchronize or dual-axis if necessary. Right-click on the axis of the<br\/>&#8220;Cumulative Sales Percentage&#8221; and select &#8216;Synchronize Axis&#8217; if it&#8217;s on a dual-axis setup.<br\/>* Format the Cumulative Sales Percentage Line:<br\/>* Click on the &#8220;Cumulative Sales Percentage&#8221; line in the visualization.<br\/>* Navigate to the &#8216;Format&#8217; pane to adjust the line style, thickness, and color to make it distinct from other data in the chart.<br\/>* Save Your Changes:<br\/>* From the File menu, click &#8216;Save&#8217; to ensure all your changes are stored.<br\/>References:<br\/>Tableau Help: Provides additional details on creating calculated fields and customizing line charts.<br\/>Tableau User Guide: Offers extensive instructions on formatting charts, including line types and axis synchronization.<br\/>By following these steps, you will successfully add a cumulative sales percentage line to your chart, enhancing the visualization to reflect the incremental contribution of each product to the overall sales in a dynamic and informative manner.<\/div><input type='button' class='showchecked' style='margin: 10px 0;' onclick='showanswer1(4,this)' id='btn-4' value='See Answer'  \/><input type='hidden' id='questionType4' value='textarea' class=''><\/div><div class='watu-question' id='question-5'><div class='question-content'><p><strong>Q48.<\/strong> A Tableau Server customer is interested in measuring content and platform usage. Which two features should the consultant use? Choose two.<\/p>\n<\/div><input type='hidden' name='question_id[]' value='24881' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96250' \/><div class='watu-question-choice'><input type='checkbox' name='answer-24881[]' id='answer-id-96250' class='answer answer-5 js-answer-label answerof-24881' value='96250' \/>&nbsp;<label for='answer-id-96250' id='answer-label-96250' class='js-answer-label answer label-5'><span class='answer'>Tableau Pulse<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96251' \/><div class='watu-question-choice'><input type='checkbox' name='answer-24881[]' id='answer-id-96251' class='answer answer-5 php-answer-label answerof-24881' value='96251' \/>&nbsp;<label for='answer-id-96251' id='answer-label-96251' class='php-answer-label answer label-5'><span class='answer'>Tableau Server repository<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96252' \/><div class='watu-question-choice'><input type='checkbox' name='answer-24881[]' id='answer-id-96252' class='answer answer-5 php-answer-label answerof-24881' value='96252' \/>&nbsp;<label for='answer-id-96252' id='answer-label-96252' class='php-answer-label answer label-5'><span class='answer'>Admin Insights page<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96253' \/><div class='watu-question-choice'><input type='checkbox' name='answer-24881[]' id='answer-id-96253' class='answer answer-5 js-answer-label answerof-24881' value='96253' \/>&nbsp;<label for='answer-id-96253' id='answer-label-96253' class='js-answer-label answer label-5'><span class='answer'>Server Status page<\/span><\/label><\/div>\n<\/div><div class='show-question-feedback' style='display:none;'>Comprehensive and Detailed Explanation From Exact Extract:<br\/>Two Tableau Server features provide usage and adoption insights:<br\/>Tableau Server Repository<br\/>* Stores all metadata about:<br\/>* Workbooks<br\/>* Data sources<br\/>* User activity<br\/>* View traffic<br\/>* Can be queried directly for content usage and platform metrics.<br\/>Admin Insights Page<br\/>* Built-in dashboards showing:<br\/>* User activity<br\/>* Content usage<br\/>* Data source usage<br\/>* Performance metrics<br\/>* Designed specifically for monitoring platform adoption.<br\/>These two together give complete content and usage visibility.<br\/>Why A and D are incorrect:<br\/>A). Tableau Pulse<br\/>* Available only in Tableau Cloud, not Tableau Server.<br\/>* Focuses on personalized metric insights, not platform reporting.<br\/>D). Server Status Page<br\/>* Shows node health and process status, not content usage or adoption analytics.<br\/>Thus, correct answers are B and C.<br\/>* Tableau Server auditing and usage documentation describing repository tables.<br\/>* Admin Insights documentation describing built-in content and user monitoring.<\/div><input type='button' class='showchecked' style='margin: 10px 0;' onclick='showanswer1(5,this)' id='btn-5' value='See Answer'  \/><input type='hidden' id='questionType5' value='checkbox' class=''><\/div><div class='watu-question' id='question-6'><div class='question-content'><p><strong>Q49.<\/strong> A client wants to see data for only the last day in a dataset and the last day is always yesterday. The date is represented with the field Ship Date.<br \/>The client is not concerned about the daily refresh results. The volume of data is so large that performance is their priority. In the future, the client will be able to move the calculation to the underlying database, but not at this time.<br \/>The solution should offer the best performance.<br \/>Which approach should the consultant use to produce the desired results?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='24882' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96254' \/><div class='watu-question-choice'><input type='radio' name='answer-24882[]' id='answer-id-96254' class='answer answer-6 js-answer-label answerof-24882' value='96254' \/>&nbsp;<label for='answer-id-96254' id='answer-label-96254' class='js-answer-label answer label-6'><span class='answer'>Filter MONTH\/DAY\/YEAR on [Ship Date] field and use an option to filter to the latest date value when the workbook opens.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96255' \/><div class='watu-question-choice'><input type='radio' name='answer-24882[]' id='answer-id-96255' class='answer answer-6 php-answer-label answerof-24882' value='96255' \/>&nbsp;<label for='answer-id-96255' id='answer-label-96255' class='php-answer-label answer label-6'><span class='answer'>Filter on calculation [Ship Date]=TODAY()-1.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96256' \/><div class='watu-question-choice'><input type='radio' name='answer-24882[]' id='answer-id-96256' class='answer answer-6 js-answer-label answerof-24882' value='96256' \/>&nbsp;<label for='answer-id-96256' id='answer-label-96256' class='js-answer-label answer label-6'><span class='answer'>Filter on Ship Date field using the Yesterday option.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96257' \/><div class='watu-question-choice'><input type='radio' name='answer-24882[]' id='answer-id-96257' class='answer answer-6 js-answer-label answerof-24882' value='96257' \/>&nbsp;<label for='answer-id-96257' id='answer-label-96257' class='js-answer-label answer label-6'><span class='answer'>Filter on calculation [Ship Date]={MAX([Ship Date])}.<\/span><\/label><\/div>\n<\/div><div class='show-question-feedback' style='display:none;'>The best approach to ensure performance while providing data for only the last day (yesterday) in the dataset is to use a calculated field that filters the data to include only yesterday&#8217;s date:<br\/>Filter on calculation [Ship Date]=TODAY()-1: This calculated field dynamically computes yesterday&#8217;s date by subtracting one day from today&#8217;s date. This approach ensures that each day, only the data for the previous day is loaded, which keeps the volume of data minimal and improves performance.<br\/>Dynamic Date Calculation: The use of TODAY()-1 ensures the filter remains up-to-date with the changing dates, without the need for manual updates, providing accuracy and timeliness in the dashboard.<br\/>This approach is efficient because it avoids the overhead of processing the entire dataset and focuses only on the relevant day&#8217;s data. It also aligns with Tableau&#8217;s capabilities for creating dynamic filters using date functions, as highlighted in the Tableau help documentation on date calculations and filters.<br\/>References<br\/>This solution utilizes Tableau&#8217;s built-in date functions and dynamic calculations to optimize performance, as recommended in Tableau&#8217;s performance optimization resources and date calculation guidelines.<\/div><input type='button' class='showchecked' style='margin: 10px 0;' onclick='showanswer1(6,this)' id='btn-6' value='See Answer'  \/><input type='hidden' id='questionType6' value='radio' class=''><\/div><div class='watu-question' id='question-7'><div class='question-content'><p><strong>Q50.<\/strong> A worksheet uses a LOOKUP function to display Sales by Month, Year of Order Date, and sales from the last<br \/>12 months. A consultant wants to use a Relative Date Filter to filter for data from the last 12 months.<br \/>However, when the consultant does this, the prior year&#8217;s data is removed from the sheet.<br \/>Which two actions should the consultant take to retain the prior year&#8217;s data after applying the filter? Choose two.<\/p>\n<\/div><input type='hidden' name='question_id[]' value='24883' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96258' \/><div class='watu-question-choice'><input type='checkbox' name='answer-24883[]' id='answer-id-96258' class='answer answer-7 js-answer-label answerof-24883' value='96258' \/>&nbsp;<label for='answer-id-96258' id='answer-label-96258' class='js-answer-label answer label-7'><span class='answer'>Replace the LOOKUP function with a FIXED Level of Detail (LOD) expression.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96259' \/><div class='watu-question-choice'><input type='checkbox' name='answer-24883[]' id='answer-id-96259' class='answer answer-7 php-answer-label answerof-24883' value='96259' \/>&nbsp;<label for='answer-id-96259' id='answer-label-96259' class='php-answer-label answer label-7'><span class='answer'>Set the Relative Date filter as a Context Filter instead of Measure Filter.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96260' \/><div class='watu-question-choice'><input type='checkbox' name='answer-24883[]' id='answer-id-96260' class='answer answer-7 php-answer-label answerof-24883' value='96260' \/>&nbsp;<label for='answer-id-96260' id='answer-label-96260' class='php-answer-label answer label-7'><span class='answer'>Create the following calculation: LOOKUP(MIN([Order Date]),0). Filter on that calculation instead of Order Date.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96261' \/><div class='watu-question-choice'><input type='checkbox' name='answer-24883[]' id='answer-id-96261' class='answer answer-7 js-answer-label answerof-24883' value='96261' \/>&nbsp;<label for='answer-id-96261' id='answer-label-96261' class='js-answer-label answer label-7'><span class='answer'>Create the following calculation: DATEDIFF(&#8216;month&#8217;, [Order Date], {MAX([Order Date])}) &lt; 12. Hide all False values.<\/span><\/label><\/div>\n<\/div><div class='show-question-feedback' style='display:none;'>Comprehensive and Detailed Explanation From Exact Extract:<br\/>A LOOKUP table calculation requires access to rows outside the filtered date range so that the calculation can reference prior data. When a Relative Date Filter removes older data before the table calculation is evaluated, the LOOKUP loses the needed rows, causing the prior year&#8217;s data to disappear.<br\/>Tableau&#8217;s order of operations states:<br\/>* Relative Date Filters act early (at the dimension filter stage).<br\/>* Table calculations act very late.<br\/>* To preserve table calculation context, filters must not remove necessary rows.<br\/>Two Tableau-documented approaches address this:<br\/>Explanation for B<br\/>Setting the Relative Date Filter as a Context Filter allows table calculations to operate on the full dataset needed for LOOKUP. Context filters create a separate temporary table, and subsequent filters like table calculations evaluate after the context is established.<br\/>This ensures older rows are still available to the LOOKUP function.<br\/>Explanation for C<br\/>Creating a field such as:<br\/>LOOKUP(MIN([Order Date]), 0)<br\/>and filtering on this field instead of Order Date converts the filter into a table calculation filter, which occurs after the LOOKUP computation. Tableau documentation explains that table calculation filters preserve the full dataset required for the LOOKUP window.<br\/>This ensures that the LOOKUP still has access to last year&#8217;s values even when filtering for the current 12 months.<br\/>Why A is incorrect<br\/>Replacing LOOKUP with an LOD changes the logic entirely.<br\/>LOD expressions cannot replicate moving-window or lag-type behavior.<br\/>Why D is incorrect<br\/>DATEDIFF logic can replicate a rolling window, but hiding False values is essentially a manual filter and does not preserve the integrity of the LOOKUP&#8217;s required partitioning. It also contradicts Tableau&#8217;s recommended approach for maintaining table calculation context.<br\/>* Tableau Order of Operations explaining why table calculation filters preserve data for LOOKUP.<br\/>* Tableau documentation on context filters and how they allow more data to remain available for downstream table calculations.<br\/>* Tableau guidance on how Relative Date Filters interact with table calculations.<br\/>* Best practices for preserving table calculation window rows when filtering.<\/div><input type='button' class='showchecked' style='margin: 10px 0;' onclick='showanswer1(7,this)' id='btn-7' value='See Answer'  \/><input type='hidden' id='questionType7' value='checkbox' class=''><\/div><div class='watu-question' id='question-8'><div class='question-content'><p><strong>Q51.<\/strong> A client wants to produce a visualization to show quarterly profit growth and aggregated sales totals across a number of product categories from the data provided below.<br \/><img decoding=\"async\" src=\"https:\/\/blog.examboosts.com\/wp-content\/uploads\/2026\/03\/Analytics-Con-301-afe72be29265fe697d389499123b0580.jpg\"\/><br \/>Which set of charts should the consultant use to meet the client&#8217;s requirements?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='24884' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96262' \/><div class='watu-question-choice'><input type='radio' name='answer-24884[]' id='answer-id-96262' class='answer answer-8 js-answer-label answerof-24884' value='96262' \/>&nbsp;<label for='answer-id-96262' id='answer-label-96262' class='js-answer-label answer label-8'><span class='answer'>Line and bubble charts<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96263' \/><div class='watu-question-choice'><input type='radio' name='answer-24884[]' id='answer-id-96263' class='answer answer-8 php-answer-label answerof-24884' value='96263' \/>&nbsp;<label for='answer-id-96263' id='answer-label-96263' class='php-answer-label answer label-8'><span class='answer'>Waterfall chart and tree map<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96264' \/><div class='watu-question-choice'><input type='radio' name='answer-24884[]' id='answer-id-96264' class='answer answer-8 js-answer-label answerof-24884' value='96264' \/>&nbsp;<label for='answer-id-96264' id='answer-label-96264' class='js-answer-label answer label-8'><span class='answer'>Gantt and bar charts<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96265' \/><div class='watu-question-choice'><input type='radio' name='answer-24884[]' id='answer-id-96265' class='answer answer-8 js-answer-label answerof-24884' value='96265' \/>&nbsp;<label for='answer-id-96265' id='answer-label-96265' class='js-answer-label answer label-8'><span class='answer'>Scatter plot and pie chart<\/span><\/label><\/div>\n<\/div><div class='show-question-feedback' style='display:none;'>To effectively display quarterly profit growth and aggregated sales totals across different product categories, a combination of a Waterfall chart and a Tree Map is recommended:<br\/>* Waterfall Chart: This chart type is excellent for visualizing the sequential growth or decline of profits across different quarters for each sub-category. It clearly shows how profits accumulate over time, highlighting both positive and negative changes, which makes it ideal for tracking profit growth or decline through the quarters.<br\/>* Tree Map: A Tree Map can efficiently display aggregated sales totals where each block size represents the total sales of a product category, providing a quick, visually impactful comparison across categories. This is especially useful when the client wants to understand which categories contribute most to sales in a glanceable format.<br\/>Together, these charts provide a comprehensive overview of both profit trends over time (Waterfall Chart) and a comparative snapshot of sales performance across categories (Tree Map), meeting the client&#8217;s need to analyze performance dynamics in a detailed yet consolidated manner.<br\/>References<br\/>These recommendations are based on common best practices for data visualization in Tableau, where specific chart types are chosen for their strengths in communicating certain types of data relationships and dynamics, as detailed in Tableau&#8217;s official visualization guides.<\/div><input type='button' class='showchecked' style='margin: 10px 0;' onclick='showanswer1(8,this)' id='btn-8' value='See Answer'  \/><input type='hidden' id='questionType8' value='radio' class=''><\/div><div class='watu-question' id='question-9'><div class='question-content'><p><strong>Q52.<\/strong> A company&#8217;s Tableau Cloud admin wants to maintain control over what content gets published to its site for viewers, while also supporting self-service for dashboard creators.<br \/>Which governance strategy should the admin implement?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='24885' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96266' \/><div class='watu-question-choice'><input type='radio' name='answer-24885[]' id='answer-id-96266' class='answer answer-9 php-answer-label answerof-24885' value='96266' \/>&nbsp;<label for='answer-id-96266' id='answer-label-96266' class='php-answer-label answer label-9'><span class='answer'>Create sandbox projects to contain ad hoc content and production projects for validated content.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96267' \/><div class='watu-question-choice'><input type='radio' name='answer-24885[]' id='answer-id-96267' class='answer answer-9 js-answer-label answerof-24885' value='96267' \/>&nbsp;<label for='answer-id-96267' id='answer-label-96267' class='js-answer-label answer label-9'><span class='answer'>Maintain a separate sandbox site and use the Content Migration Tool to promote content between sites.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96268' \/><div class='watu-question-choice'><input type='radio' name='answer-24885[]' id='answer-id-96268' class='answer answer-9 js-answer-label answerof-24885' value='96268' \/>&nbsp;<label for='answer-id-96268' id='answer-label-96268' class='js-answer-label answer label-9'><span class='answer'>Allow dashboard creators to publish to their Personal Space and for site administrators to move content to projects.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96269' \/><div class='watu-question-choice'><input type='radio' name='answer-24885[]' id='answer-id-96269' class='answer answer-9 js-answer-label answerof-24885' value='96269' \/>&nbsp;<label for='answer-id-96269' id='answer-label-96269' class='js-answer-label answer label-9'><span class='answer'>Restrict users&#8217; permission to view data sources used in uncertified dashboards.<\/span><\/label><\/div>\n<\/div><div class='show-question-feedback' style='display:none;'>Comprehensive and Detailed Explanation From Exact Extract:<br\/>Tableau&#8217;s recommended content governance model for Server and Cloud emphasizes project-based separation between development (&#8220;sandbox&#8221;) content and certified, production-ready content.<br\/>Key points from Tableau governance guidance:<br\/>* Organizations should define sandbox projects where creators can freely publish and iterate on workbooks and data sources.<br\/>* Once content is reviewed and validated, it is promoted into &#8220;production&#8221; projects that are designated for trusted content for viewers.<br\/>* This model allows self-service authoring while keeping tight control over what is exposed to broad viewer audiences.<br\/>Option A exactly reflects this model: sandbox projects for ad hoc content, and production projects for validated content.<br\/>Option B uses separate sites and the Content Migration Tool, which is heavier to manage and usually reserved for cross-environment moves (such as dev to prod), not necessary for basic project-level governance in a single Tableau Cloud site.<br\/>Option C relies on Personal Space. Tableau recommends Personal Space for private drafts, not as the main promotion path, and it is not the primary governance pattern for viewer-facing content.<br\/>Option D restricts data source viewing but does not provide a full governance strategy for managing ad hoc versus production dashboards.<br\/>Therefore, the correct strategy is sandbox projects plus production projects, which is option A.<br\/>* Tableau governance whitepapers describing sandbox versus production projects as a best-practice pattern.<br\/>* Tableau Cloud site administration guidance recommending project structure for self-service and controlled promotion of content.<\/div><input type='button' class='showchecked' style='margin: 10px 0;' onclick='showanswer1(9,this)' id='btn-9' value='See Answer'  \/><input type='hidden' id='questionType9' value='radio' class=''><\/div><div class='watu-question' id='question-10'><div class='question-content'><p><strong>Q53.<\/strong> A client has a database that stores widget inventory by day and it is updated on a nonstandard schedule as shown below.<br \/><img decoding=\"async\" src=\"https:\/\/blog.examboosts.com\/wp-content\/uploads\/2026\/03\/Analytics-Con-301-31062212c1c44f0622d53479dbd075f5.jpg\"\/><br \/>They want a data visualization that shows widget inventory daily, however their business unit does not have the ability to modify the data warehouse structure.<br \/>What should the client do to achieve the desired result?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='24886' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96270' \/><div class='watu-question-choice'><input type='radio' name='answer-24886[]' id='answer-id-96270' class='answer answer-10 js-answer-label answerof-24886' value='96270' \/>&nbsp;<label for='answer-id-96270' id='answer-label-96270' class='js-answer-label answer label-10'><span class='answer'>Create a temporary table in the database.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96271' \/><div class='watu-question-choice'><input type='radio' name='answer-24886[]' id='answer-id-96271' class='answer answer-10 js-answer-label answerof-24886' value='96271' \/>&nbsp;<label for='answer-id-96271' id='answer-label-96271' class='js-answer-label answer label-10'><span class='answer'>Use Tableau Desktop to visualize null values.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96272' \/><div class='watu-question-choice'><input type='radio' name='answer-24886[]' id='answer-id-96272' class='answer answer-10 js-answer-label answerof-24886' value='96272' \/>&nbsp;<label for='answer-id-96272' id='answer-label-96272' class='js-answer-label answer label-10'><span class='answer'>Update the Widget Inventory Table to be a daily snapshot.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96273' \/><div class='watu-question-choice'><input type='radio' name='answer-24886[]' id='answer-id-96273' class='answer answer-10 php-answer-label answerof-24886' value='96273' \/>&nbsp;<label for='answer-id-96273' id='answer-label-96273' class='php-answer-label answer label-10'><span class='answer'>Use Tableau Prep to add new rows.<\/span><\/label><\/div>\n<\/div><div class='show-question-feedback' style='display:none;'>For a client who needs a daily visualization of widget inventory but cannot modify the data warehouse structure, the best approach is to use Tableau Prep to add new rows. Tableau Prep can be used to manipulate the existing dataset by adding missing date entries and appropriately adjusting inventory counts based on available data. This allows the creation of a complete daily snapshot for visualization without needing changes to the underlying database structure.<\/div><input type='button' class='showchecked' style='margin: 10px 0;' onclick='showanswer1(10,this)' id='btn-10' value='See Answer'  \/><input type='hidden' id='questionType10' value='radio' class=''><\/div><div class='watu-question' id='question-11'><div class='question-content'><p><strong>Q54.<\/strong> A client requests a published Tableau data source that is connected to SQL Server. The client needs to leverage the multiple tables option to create an extract. The extract will include partial data from the SQL Server data source.<br \/>Which action will reduce the amount of data in the extract?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='24887' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96274' \/><div class='watu-question-choice'><input type='radio' name='answer-24887[]' id='answer-id-96274' class='answer answer-11 php-answer-label answerof-24887' value='96274' \/>&nbsp;<label for='answer-id-96274' id='answer-label-96274' class='php-answer-label answer label-11'><span class='answer'>Use an extract filter.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96275' \/><div class='watu-question-choice'><input type='radio' name='answer-24887[]' id='answer-id-96275' class='answer answer-11 js-answer-label answerof-24887' value='96275' \/>&nbsp;<label for='answer-id-96275' id='answer-label-96275' class='js-answer-label answer label-11'><span class='answer'>Aggregate the extract to the visible dimensions.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96276' \/><div class='watu-question-choice'><input type='radio' name='answer-24887[]' id='answer-id-96276' class='answer answer-11 js-answer-label answerof-24887' value='96276' \/>&nbsp;<label for='answer-id-96276' id='answer-label-96276' class='js-answer-label answer label-11'><span class='answer'>Define the filters by using custom SQL.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96277' \/><div class='watu-question-choice'><input type='radio' name='answer-24887[]' id='answer-id-96277' class='answer answer-11 js-answer-label answerof-24887' value='96277' \/>&nbsp;<label for='answer-id-96277' id='answer-label-96277' class='js-answer-label answer label-11'><span class='answer'>Set up the extract as an incremental refresh.<\/span><\/label><\/div>\n<\/div><div class='show-question-feedback' style='display:none;'>Using an extract filter is an effective way to reduce the amount of data in a Tableau extract. Extract filters allow you to specify a subset of the data to include, which can significantly decrease the size of the extract by excluding unnecessary data. This is particularly useful when you only need partial data from a larger SQL Server data source.<br\/>References: The recommendation to use extract filters to reduce data size is supported by Tableau&#8217;s best practices for optimizing extracts. These practices suggest keeping the extract&#8217;s data set short through filtering1. Additionally, discussions in the Tableau Community confirm that hiding fields and using extract filters before extracting data can help reduce the extract size2.<br\/>When dealing with large datasets in SQL Server and needing to create a manageable extract in Tableau, using an extract filter is the most direct and effective method to limit the data included:<br\/>Extract Filter: This involves setting filters that apply directly when the data is extracted from the source. This means that only the data meeting the specified criteria will be extracted and loaded into Tableau, significantly reducing the size of the extract.<br\/>To apply an extract filter, in the Data Source page in Tableau, drag the fields you want to filter by to the Filters shelf. Then, configure the desired filter criteria. When you create the extract, choose the option to &#8220;Add Filters to Extract&#8221; and select the configured filters. This ensures that only the data that meets these conditions is extracted from the SQL Server.<br\/>This approach not only minimizes the data volume but also speeds up performance in Tableau because it processes a smaller subset of the full dataset.<br\/>References<br\/>This procedure is described in detail in Tableau&#8217;s help documentation on managing extracts and optimizing performance by using extract filters, which is recommended for scenarios involving large datasets or when specific subsets of data are required for analysis.<\/div><input type='button' class='showchecked' style='margin: 10px 0;' onclick='showanswer1(11,this)' id='btn-11' value='See Answer'  \/><input type='hidden' id='questionType11' value='radio' class=''><\/div><div class='watu-question' id='question-12'><div class='question-content'><p><strong>Q55.<\/strong> Sales managers use a daily extract from Snowflake to see the previous day&#8217;s snapshot.<br \/>Sales managers should only see statistics for their direct reports.<br \/>The company has Tableau Data Management on Tableau Cloud.<br \/>A consultant must design a centralized, low-maintenance RLS strategy.<br \/>What should the consultant implement?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='24888' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96278' \/><div class='watu-question-choice'><input type='radio' name='answer-24888[]' id='answer-id-96278' class='answer answer-12 js-answer-label answerof-24888' value='96278' \/>&nbsp;<label for='answer-id-96278' id='answer-label-96278' class='js-answer-label answer label-12'><span class='answer'>Built-in RLS security in Snowflake<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96279' \/><div class='watu-question-choice'><input type='radio' name='answer-24888[]' id='answer-id-96279' class='answer answer-12 php-answer-label answerof-24888' value='96279' \/>&nbsp;<label for='answer-id-96279' id='answer-label-96279' class='php-answer-label answer label-12'><span class='answer'>Data policy<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96280' \/><div class='watu-question-choice'><input type='radio' name='answer-24888[]' id='answer-id-96280' class='answer answer-12 js-answer-label answerof-24888' value='96280' \/>&nbsp;<label for='answer-id-96280' id='answer-label-96280' class='js-answer-label answer label-12'><span class='answer'>Manual user filter<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96281' \/><div class='watu-question-choice'><input type='radio' name='answer-24888[]' id='answer-id-96281' class='answer answer-12 js-answer-label answerof-24888' value='96281' \/>&nbsp;<label for='answer-id-96281' id='answer-label-96281' class='js-answer-label answer label-12'><span class='answer'>Dynamic user filter<\/span><\/label><\/div>\n<\/div><div class='show-question-feedback' style='display:none;'>Comprehensive and Detailed Explanation From Exact Extract:<br\/>The key requirements:<br\/>* Tableau Cloud<br\/>* Extracts (not live data)<br\/>* Need RLS<br\/>* Want low maintenance<br\/>* Have Tableau Data Management<br\/>These requirements point directly to:<br\/>Data Policies (Virtual Connections RLS)<br\/>Tableau Data Management enables Virtual Connections and Data Policies, which provide:<br\/>* Centralized row-level security<br\/>* Integration with user identity via USERNAME()<br\/>* Reusable RLS logic across all downstream workbooks<br\/>* Works with extracts, unlike database RLS<br\/>* Minimal long-term maintenance<br\/>This is Tableau&#8217;s recommended enterprise RLS method for Tableau Cloud with extracts.<br\/>Why the other options are incorrect:<br\/>A). Built-in RLS in Snowflake<br\/>Only works with live connections.<br\/>This client uses daily extracts, so database RLS is bypassed.<br\/>C). Manual user filter<br\/>High maintenance, must be edited manually per user &#8211; not scalable.<br\/>D). Dynamic user filter<br\/>Functional but must be recreated in each workbook, not centralized.<br\/>More maintenance than a data policy.<br\/>Therefore, Data Policy is the only low-maintenance, centralized RLS solution.<br\/>* Data Policies and Virtual Connections documentation describing centralized RLS<br\/>* Tableau Cloud &amp; Extracts guidelines showing that database RLS cannot be reused<br\/>* RLS strategy best practices recommending Data Policies for scalable governance<\/div><input type='button' class='showchecked' style='margin: 10px 0;' onclick='showanswer1(12,this)' id='btn-12' value='See Answer'  \/><input type='hidden' id='questionType12' value='radio' class=''><\/div><div class='watu-question' id='question-13'><div class='question-content'><p><strong>Q56.<\/strong> A stakeholder has multiple files saved (CSV\/Tables) in a single location. A few files from the location are required for analysis. Data transformation (calculations) is required for the files before designing the visuals. The files have the following attributes:<br \/>. All files have the same schema.<br \/>. Multiple files have something in common among their file names.<br \/>. Each file has a unique key column.<br \/>Which data transformation strategy should the consultant use to deliver the best optimized result?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='24889' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96282' \/><div class='watu-question-choice'><input type='radio' name='answer-24889[]' id='answer-id-96282' class='answer answer-13 js-answer-label answerof-24889' value='96282' \/>&nbsp;<label for='answer-id-96282' id='answer-label-96282' class='js-answer-label answer label-13'><span class='answer'>Use join option to combine\/merge all the files together before doing the data transformation (calculations).<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96283' \/><div class='watu-question-choice'><input type='radio' name='answer-24889[]' id='answer-id-96283' class='answer answer-13 php-answer-label answerof-24889' value='96283' \/>&nbsp;<label for='answer-id-96283' id='answer-label-96283' class='php-answer-label answer label-13'><span class='answer'>Use wildcard Union option to combine\/merge all the files together before doing the data transformation (calculations).<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96284' \/><div class='watu-question-choice'><input type='radio' name='answer-24889[]' id='answer-id-96284' class='answer answer-13 js-answer-label answerof-24889' value='96284' \/>&nbsp;<label for='answer-id-96284' id='answer-label-96284' class='js-answer-label answer label-13'><span class='answer'>Apply the data transformation (calculations) in each require file and do the wildcard union to combine<br \/>\/merge before designing the visuals.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96285' \/><div class='watu-question-choice'><input type='radio' name='answer-24889[]' id='answer-id-96285' class='answer answer-13 js-answer-label answerof-24889' value='96285' \/>&nbsp;<label for='answer-id-96285' id='answer-label-96285' class='js-answer-label answer label-13'><span class='answer'>Apply the data transformation (calculations) in each require file and do the join to combine\/merge before designing the visuals.<\/span><\/label><\/div>\n<\/div><div class='show-question-feedback' style='display:none;'>Moving calculations to the data layer and materializing them in the extract can significantly improve the performance of reports in Tableau. The calculation ZN([Sales])*(1 &#8211; ZN([Discount])) is a basic calculation that can be easily computed in advance and stored in the extract, speeding up future queries. This type of calculation is less complex than table calculations or LOD expressions, which are better suited for dynamic analysis and may not benefit as much from materialization12.<br\/>References: The answer is based on the best practices for creating efficient calculations in Tableau, as described in Tableau&#8217;s official documentation, which suggests using basic and aggregate calculations to improve performance1. Additionally, the process of materializing calculations in extracts is detailed in Tableau&#8217;s resources2.<br\/>Given that all files share the same schema and have a common element in their file names, the wildcard union is an optimal approach to combine these files before performing any transformations. This strategy offers the following advantages:<br\/>Efficient Data Combination: Wildcard union allows multiple files with a common naming scheme to be combined into a single dataset in Tableau, streamlining the data preparation process.<br\/>Uniform Schema Handling: Since all files share the same schema, wildcard union ensures that the combined dataset maintains consistency in data structure, making further data manipulation more straightforward.<br\/>Pre-Transformation Combination: Combining the files before applying transformations is generally more efficient as it reduces redundancy in transformation logic across multiple files. This means transformations are written and processed once on the unified dataset, rather than repeatedly for each individual file.<br\/>References:<br\/>Wildcard Union in Tableau: This feature simplifies the process of combining multiple similar files into a single Tableau data source, ensuring a seamless and efficient approach to data integration and preparation.<\/div><input type='button' class='showchecked' style='margin: 10px 0;' onclick='showanswer1(13,this)' id='btn-13' value='See Answer'  \/><input type='hidden' id='questionType13' value='radio' class=''><\/div><div class='watu-question' id='question-14'><div class='question-content'><p><strong>Q57.<\/strong> A client wants to report Saturday and Sunday regardless of the workbook&#8217;s data source&#8217;s locale settings.<br \/>Which calculation should the consultant recommend?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='24890' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96286' \/><div class='watu-question-choice'><input type='radio' name='answer-24890[]' id='answer-id-96286' class='answer answer-14 js-answer-label answerof-24890' value='96286' \/>&nbsp;<label for='answer-id-96286' id='answer-label-96286' class='js-answer-label answer label-14'><span class='answer'>DATEPART(&#8216;weekday&#8217;, [Order Date])&gt;=6<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96287' \/><div class='watu-question-choice'><input type='radio' name='answer-24890[]' id='answer-id-96287' class='answer answer-14 js-answer-label answerof-24890' value='96287' \/>&nbsp;<label for='answer-id-96287' id='answer-label-96287' class='js-answer-label answer label-14'><span class='answer'>DATEPART(&#8216;iso-weekday&#8217;, [Order Date])&gt;=6<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96288' \/><div class='watu-question-choice'><input type='radio' name='answer-24890[]' id='answer-id-96288' class='answer answer-14 js-answer-label answerof-24890' value='96288' \/>&nbsp;<label for='answer-id-96288' id='answer-label-96288' class='js-answer-label answer label-14'><span class='answer'>DATENAME(&#8216;iso-weekday&#8217;, [Order Date])&gt;=6<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96289' \/><div class='watu-question-choice'><input type='radio' name='answer-24890[]' id='answer-id-96289' class='answer answer-14 php-answer-label answerof-24890' value='96289' \/>&nbsp;<label for='answer-id-96289' id='answer-label-96289' class='php-answer-label answer label-14'><span class='answer'>DATEPART(&#8216;iso-weekday&#8217;, [Order Date])=1 or DATEPART(&#8216;iso-weekday&#8217;, [Order Date])=7<\/span><\/label><\/div>\n<\/div><div class='show-question-feedback' style='display:none;'>The calculation DATEPART(&#8216;iso-weekday&#8217;, [Order Date])=1 or DATEPART(&#8216;iso-weekday&#8217;, [Order Date])=7 is recommended because the ISO standard considers Monday as the first day of the week (1) and Sunday as the last day (7). This calculation will correctly identify Saturdays and Sundays regardless of the locale settings of the workbook&#8217;s data source, ensuring that the report includes these days as specified by the client.<br\/>References: The use of the &#8216;iso-weekday&#8217; part in the DATEPART function is consistent with the ISO 8601 standard, which is independent of locale settings. This approach is supported by Tableau&#8217;s documentation on date functions and their behavior with different locale settings123.<br\/>To accurately identify weekends across different locale settings, using the &#8216;iso-weekday&#8217; component is reliable as it is consistent across various locales:<br\/>ISO Weekday Function: The ISO standard treats Monday as the first day of the week (1), which makes Sunday the seventh day (7). This standardization helps avoid discrepancies in weekday calculations that might arise due to locale-specific settings.<br\/>Identifying Weekends: The calculation checks if the &#8216;iso-weekday&#8217; part of the date is either 1 (Sunday) or 7 (Saturday), thereby correctly identifying weekends regardless of the locale settings.<br\/>References:<br\/>Handling Locale-Specific Settings: Using ISO standards in date functions allows for uniform results across systems with differing locale settings, essential for consistent reporting in global applications.<\/div><input type='button' class='showchecked' style='margin: 10px 0;' onclick='showanswer1(14,this)' id='btn-14' value='See Answer'  \/><input type='hidden' id='questionType14' value='radio' class=''><\/div><div class='watu-question' id='question-15'><div class='question-content'><p><strong>Q58.<\/strong> A new Tableau user created a simple dashboard on Tableau Server using supply chain data. Now, the user wants to know if they created the dashboard in accordance with specific performance best practices.<br \/>Which approach should the consultant recommend for the client to make this determination?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='24891' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96290' \/><div class='watu-question-choice'><input type='radio' name='answer-24891[]' id='answer-id-96290' class='answer answer-15 js-answer-label answerof-24891' value='96290' \/>&nbsp;<label for='answer-id-96290' id='answer-label-96290' class='js-answer-label answer label-15'><span class='answer'>Use inbuilt dashboards in Tableau Server to troubleshoot the performance.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96291' \/><div class='watu-question-choice'><input type='radio' name='answer-24891[]' id='answer-id-96291' class='answer answer-15 js-answer-label answerof-24891' value='96291' \/>&nbsp;<label for='answer-id-96291' id='answer-label-96291' class='js-answer-label answer label-15'><span class='answer'>Use Performance Recording on Tableau Server.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96292' \/><div class='watu-question-choice'><input type='radio' name='answer-24891[]' id='answer-id-96292' class='answer answer-15 js-answer-label answerof-24891' value='96292' \/>&nbsp;<label for='answer-id-96292' id='answer-label-96292' class='js-answer-label answer label-15'><span class='answer'>Use Performance Recording in Tableau Desktop.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96293' \/><div class='watu-question-choice'><input type='radio' name='answer-24891[]' id='answer-id-96293' class='answer answer-15 php-answer-label answerof-24891' value='96293' \/>&nbsp;<label for='answer-id-96293' id='answer-label-96293' class='php-answer-label answer label-15'><span class='answer'>Run Workbook Optimizer.<\/span><\/label><\/div>\n<\/div><div class='show-question-feedback' style='display:none;'>The Workbook Optimizer is a tool specifically designed to evaluate a workbook against performance best practices. It provides feedback on key design characteristics and offers concrete guidance on how to improve workbook performance. This tool is beneficial for both new and experienced Tableau users to ensure their dashboards are optimized for performance1.<br\/>References: The Workbook Optimizer&#8217;s functionality is detailed in Tableau&#8217;s official documentation, which explains how it assesses workbooks against a set of rules derived from best practices1. Additionally, the Performance Recording feature in Tableau Desktop and Server can be used to identify performance issues, but the Workbook Optimizer gives a more comprehensive analysis of the workbook&#8217;s adherence to best practices23.<\/div><input type='button' class='showchecked' style='margin: 10px 0;' onclick='showanswer1(15,this)' id='btn-15' value='See Answer'  \/><input type='hidden' id='questionType15' value='radio' class=''><\/div><div class='watu-question' id='question-16'><div class='question-content'><p><strong>Q59.<\/strong> A client wants to flag orders that have sales higher than the regional average.<br \/>Which calculated field will produce the required result?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='24892' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96294' \/><div class='watu-question-choice'><input type='radio' name='answer-24892[]' id='answer-id-96294' class='answer answer-16 js-answer-label answerof-24892' value='96294' \/>&nbsp;<label for='answer-id-96294' id='answer-label-96294' class='js-answer-label answer label-16'><span class='answer'>[Sales]<br \/>&gt;<br \/>{ FIXED [Order ID] : SUM([Sales]) }<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96295' \/><div class='watu-question-choice'><input type='radio' name='answer-24892[]' id='answer-id-96295' class='answer answer-16 js-answer-label answerof-24892' value='96295' \/>&nbsp;<label for='answer-id-96295' id='answer-label-96295' class='js-answer-label answer label-16'><span class='answer'>{ FIXED [Order ID] : SUM([Sales]) }<br \/>&gt;<br \/>{ FIXED [Region] : SUM([Sales]) }<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96296' \/><div class='watu-question-choice'><input type='radio' name='answer-24892[]' id='answer-id-96296' class='answer answer-16 php-answer-label answerof-24892' value='96296' \/>&nbsp;<label for='answer-id-96296' id='answer-label-96296' class='php-answer-label answer label-16'><span class='answer'>{ FIXED [Order ID] : SUM([Sales]) }<br \/>&gt;<br \/>{ FIXED [Region] : AVG({ FIXED [Order ID] : SUM([Sales]) }) }<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96297' \/><div class='watu-question-choice'><input type='radio' name='answer-24892[]' id='answer-id-96297' class='answer answer-16 js-answer-label answerof-24892' value='96297' \/>&nbsp;<label for='answer-id-96297' id='answer-label-96297' class='js-answer-label answer label-16'><span class='answer'>{ FIXED [Order ID] : SUM([Sales]) }<br \/>&gt;<br \/>{ INCLUDE [Region] : AVG({ FIXED [Order ID] : SUM([Sales]) }) }<\/span><\/label><\/div>\n<\/div><div class='show-question-feedback' style='display:none;'>To flag orders with sales higher than the regional average, the correct calculated field would compare the sum of sales for each order against the average sales of all orders within the same region:<br\/>* Correct Formula: { FIXED [Order ID] : SUM([Sales]) } &gt; { FIXED [Region] : AVG({ FIXED<br\/>[Order ID] : SUM([Sales]) }) }<br\/>* This calculation uses a Level of Detail (LOD) expression:<br\/>* The left part of the formula { FIXED [Order ID] : SUM([Sales]) } calculates the total sales for each individual order.<br\/>* The right part { FIXED [Region] : AVG({ FIXED [Order ID] : SUM([Sales]) }) } calculates the average sales per order within each region.<br\/>* The &gt; operator is used to compare these two values to determine if the sales for each order exceed the regional average.<br\/>References<br\/>This formula utilizes Tableau&#8217;s LOD expressions to perform complex comparisons across different dimensions of the data, as explained in Tableau&#8217;s official training materials on LOD calculations.<\/div><input type='button' class='showchecked' style='margin: 10px 0;' onclick='showanswer1(16,this)' id='btn-16' value='See Answer'  \/><input type='hidden' id='questionType16' value='radio' class=''><\/div><div class='watu-question' id='question-17'><div class='question-content'><p><strong>Q60.<\/strong> A company has a data source for sales transactions. The data source has the following characteristics:<br \/>. Millions of transactions occur weekly.<br \/>. The transactions are added nightly.<br \/>. Incorrect transactions are revised every week on Saturday.<br \/>* The end users need to see up-to-date data daily.<br \/>A consultant needs to publish a data source in Tableau Server to ensure that all the transactions in the data source are available.<br \/>What should the consultant do to create and publish the data?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='24893' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96298' \/><div class='watu-question-choice'><input type='radio' name='answer-24893[]' id='answer-id-96298' class='answer answer-17 php-answer-label answerof-24893' value='96298' \/>&nbsp;<label for='answer-id-96298' id='answer-label-96298' class='php-answer-label answer label-17'><span class='answer'>Publish an incremental extract refresh every day and perform a full extract refresh every Saturday.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96299' \/><div class='watu-question-choice'><input type='radio' name='answer-24893[]' id='answer-id-96299' class='answer answer-17 js-answer-label answerof-24893' value='96299' \/>&nbsp;<label for='answer-id-96299' id='answer-label-96299' class='js-answer-label answer label-17'><span class='answer'>Publish a live connection to Tableau Server.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96300' \/><div class='watu-question-choice'><input type='radio' name='answer-24893[]' id='answer-id-96300' class='answer answer-17 js-answer-label answerof-24893' value='96300' \/>&nbsp;<label for='answer-id-96300' id='answer-label-96300' class='js-answer-label answer label-17'><span class='answer'>Publish an incremental refresh every Saturday.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96301' \/><div class='watu-question-choice'><input type='radio' name='answer-24893[]' id='answer-id-96301' class='answer answer-17 js-answer-label answerof-24893' value='96301' \/>&nbsp;<label for='answer-id-96301' id='answer-label-96301' class='js-answer-label answer label-17'><span class='answer'>Publish an incremental extract refresh every day and publish a secondary data set containing data revisions.<\/span><\/label><\/div>\n<\/div><div class='show-question-feedback' style='display:none;'>Given the need for up-to-date data on a daily basis and weekly revisions, the best approach is to use an incremental extract refresh daily to update the data source with new transactions. On Saturdays, when incorrect transactions are revised, a full extract refresh should be performed to incorporate all revisions and ensure the data&#8217;s accuracy. This strategy allows end users to have access to the most current data throughout the week while also accounting for any necessary corrections12.<br\/>References: The solution is based on best practices for managing data sources in Tableau Server, which recommend using incremental refreshes for frequent updates and full refreshes when significant changes or corrections are made to the data12.<\/div><input type='button' class='showchecked' style='margin: 10px 0;' onclick='showanswer1(17,this)' id='btn-17' value='See Answer'  \/><input type='hidden' id='questionType17' value='radio' class=''><\/div><div class='watu-question' id='question-18'><div class='question-content'><p><strong>Q61.<\/strong> SIMULATION<br \/>From the desktop, open the CC workbook.<br \/>Open the Manufacturers worksheet.<br \/>The Manufacturers worksheet is used to<br \/>analyze the quantity of items contributed by<br \/>each manufacturer.<br \/>You need to modify the Percent<br \/>Contribution calculated field to use a Level<br \/>of Detail (LOD) expression that calculates<br \/>the percentage contribution of each<br \/>manufacturer to the total quantity.<br \/>Enter the percentage for Newell to the<br \/>nearest hundredth of a percent into the<br \/>Newell % Contribution parameter.<br \/>From the File menu in Tableau Desktop, click<br \/>Save.<\/p>\n<\/div><input type='hidden' name='question_id[]' value='24894' \/><textarea name='answer-24894[]' rows='5' cols='40' id='textarea_q_24894' class='watu-textarea watu-textarea-18'><\/textarea><div class='watu-questions-wrap '><\/div><div class='show-question-feedback' style='display:none;'>See the complete Steps below in Explanation<br\/>Explanation:<br\/>To modify the Percent Contribution calculated field to use a Level of Detail (LOD) expression and accurately calculate the percentage contribution of each manufacturer to the total quantity, follow these steps:<br\/>Open the CC Workbook and Access the Worksheet:<br\/>Double-click on the CC workbook from the desktop to open it in Tableau Desktop.<br\/>Navigate to the Manufacturers worksheet by selecting its tab at the bottom of the window.<br\/>Modify the Percent Contribution Calculated Field:<br\/>Navigate to the Data pane and find the &#8220;Percent Contribution&#8221; calculated field.<br\/>Right-click on the &#8220;Percent Contribution&#8221; field and select &#8216;Edit&#8217;.<br\/>Modify the formula to incorporate an LOD expression that calculates the total quantity across all manufacturers and the specific quantity per manufacturer:<br\/>{FIXED [Manufacturer]: SUM([Quantity])} \/ {SUM([Quantity])}Quantity])}<br\/>This formula uses {FIXED [Manufacturer]: SUM([Quantity])} to compute the total quantity contributed by each manufacturer, regardless of other dimensions in the view. The total quantity {SUM([Quantity])} calculates the grand total across all manufacturers. The division calculates the percentage contribution.<br\/>Click &#8216;OK&#8217; to save the updated calculated field.<br\/>Enter Percentage for Newell:<br\/>With the updated &#8220;Percent Contribution&#8221; field, drag it onto the view to update the chart or table.<br\/>Identify the value corresponding to &#8216;Newell&#8217; in the updated visualization.<br\/>Round this value to the nearest hundredth of a percent as required.<br\/>Enter this value into the &#8220;Newell % Contribution&#8221; parameter. To do this, locate the parameter in the Data pane or on the dashboard, right-click it, and choose &#8216;Edit&#8217;. Enter the calculated percentage for Newell.<br\/>Save Your Changes:<br\/>From the File menu, click &#8216;Save&#8217; to store all the modifications you have made to the workbook.<br\/>References:<br\/>Tableau Help: Offers detailed guidance on using LOD expressions for precise and context-independent aggregations.<br\/>Tableau Desktop User Guide: Provides comprehensive instructions on managing calculated fields and parameters, ensuring accurate data analysis.<br\/>By following these steps, you will have successfully updated the calculation for percent contribution using LOD expressions, providing a more accurate analysis of each manufacturer&#8217;s contribution to the total quantity. Moreover, updating the parameter with Newell&#8217;s specific contribution rounds out the task by reflecting precise data inputs for reporting or further analysis.<\/div><input type='button' class='showchecked' style='margin: 10px 0;' onclick='showanswer1(18,this)' id='btn-18' value='See Answer'  \/><input type='hidden' id='questionType18' value='textarea' class=''><\/div><div class='watu-question' id='question-19'><div class='question-content'><p><strong>Q62.<\/strong> From the desktop, open the CC workbook. Use the US Population Estimates data source.<br \/>You need to shape the data in US Population Estimates by using Tableau Desktop. The data must be formatted as shown in the following table.<br \/><img decoding=\"async\" src=\"https:\/\/blog.examboosts.com\/wp-content\/uploads\/2026\/03\/Analytics-Con-301-28450dd8b7a36faacb8007b6b6aa851e.jpg\"\/><br \/>Open the Population worksheet. Enter the total number of records contained in the data set into the Total Records parameter.<br \/>From the File menu in Tableau Desktop, click Save.<\/p>\n<\/div><input type='hidden' name='question_id[]' value='24895' \/><textarea name='answer-24895[]' rows='5' cols='40' id='textarea_q_24895' class='watu-textarea watu-textarea-19'><\/textarea><div class='watu-questions-wrap '><\/div><div class='show-question-feedback' style='display:none;'>See the complete Steps below in Explanation:<br\/>Explanation:<br\/>To shape the data in the &#8220;US Population Estimates&#8221; data source and enter the total number of records into the<br\/>&#8220;Total Records&#8221; parameter in Tableau Desktop, follow these steps:<br\/>* Open the CC Workbook and Access the Worksheet:<br\/>* From the desktop, double-click on the CC workbook to open it in Tableau Desktop.<br\/>* Navigate to the Population worksheet by selecting its tab at the bottom of the window.<br\/>* Format and Shape the Data:<br\/>* Ensure the data types match those specified in the requirements: Sex, Origin, Race as strings; Year, Age, Population as whole numbers.<br\/>* To verify or change the data type, click on the dropdown arrow next to each field name in the Data pane and select &#8220;Change Data Type&#8221; if necessary.<br\/>* Calculate Total Number of Records:<br\/>* Create a new calculated field named &#8220;Total Records&#8221;. To do this, right-click in the Data pane and select &#8220;Create Calculated Field&#8221;.<br\/>* Enter the formula COUNT([Record ID]) or SUM([Number of Records]) depending on how the data source identifies each row uniquely.<br\/>* Drag this new calculated field onto the worksheet to display the total number of records.<br\/>* Enter the Value into the Total Records Parameter:<br\/>* Locate the &#8220;Total Records&#8221; parameter in the Data pane. Right-click on the parameter and select<br\/>&#8220;Edit&#8221;.<br\/>* Manually enter the number displayed from the calculated field into the parameter, ensuring accuracy to meet the data shaping requirement.<br\/>* Save Your Changes:<br\/>* From the File menu, click &#8216;Save&#8217; to ensure all your changes are stored.<br\/>References:<br\/>Tableau Desktop Guide: Provides detailed instructions on managing data types, creating calculated fields, and updating parameters.<br\/>Tableau Data Shaping Techniques: Outlines effective methods for manipulating and structuring data for analysis.<br\/>This process will ensure the data in the &#8220;US Population Estimates&#8221; is accurately shaped according to the specified format and that the total number of records is correctly calculated and entered into the designated parameter. This thorough approach ensures data integrity and accuracy in reporting.<\/div><input type='button' class='showchecked' style='margin: 10px 0;' onclick='showanswer1(19,this)' id='btn-19' value='See Answer'  \/><input type='hidden' id='questionType19' value='textarea' class=''><\/div><div class='watu-question' id='question-20'><div class='question-content'><p><strong>Q63.<\/strong> A consultant used Tableau Data Catalog to determine which workbooks will be affected by a field change.<br \/>Catalog shows:<br \/>* Published Data Source # 7 connected workbooks<br \/>* Field search (Lineage tab) # 6 impacted workbooks<br \/>The client asks: Why 7 connected, but only 6 impacted?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='24896' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96302' \/><div class='watu-question-choice'><input type='radio' name='answer-24896[]' id='answer-id-96302' class='answer answer-20 js-answer-label answerof-24896' value='96302' \/>&nbsp;<label for='answer-id-96302' id='answer-label-96302' class='js-answer-label answer label-20'><span class='answer'>The field is used twice in a single workbook.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96303' \/><div class='watu-question-choice'><input type='radio' name='answer-24896[]' id='answer-id-96303' class='answer answer-20 js-answer-label answerof-24896' value='96303' \/>&nbsp;<label for='answer-id-96303' id='answer-label-96303' class='js-answer-label answer label-20'><span class='answer'>The consultant lacked sufficient permissions to see the seventh workbook.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96304' \/><div class='watu-question-choice'><input type='radio' name='answer-24896[]' id='answer-id-96304' class='answer answer-20 php-answer-label answerof-24896' value='96304' \/>&nbsp;<label for='answer-id-96304' id='answer-label-96304' class='php-answer-label answer label-20'><span class='answer'>The field being altered is not used in the seventh workbook.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='96305' \/><div class='watu-question-choice'><input type='radio' name='answer-24896[]' id='answer-id-96305' class='answer answer-20 js-answer-label answerof-24896' value='96305' \/>&nbsp;<label for='answer-id-96305' id='answer-label-96305' class='js-answer-label answer label-20'><span class='answer'>The seventh workbook is connected via Custom SQL so it didn&#8217;t appear in the list.<\/span><\/label><\/div>\n<\/div><div class='show-question-feedback' style='display:none;'>Comprehensive and Detailed Explanation From Exact Extract:<br\/>Key Tableau Catalog behaviors:<br\/>* Connected workbooks = any workbook linked to the published data source.<br\/>* Impacted workbooks = only workbooks that use the specific field.<br\/>* If a workbook connects to the data source but never uses the field, it appears as &#8220;connected&#8221; but not impacted.<br\/>This explains EXACTLY why:<br\/>* 7 workbooks are connected<br\/>* Only 6 use the changed field<br\/>* Therefore only 6 are impacted<br\/>This matches Option C.<br\/>Why the other options are incorrect:<br\/>A). Field used twice<br\/>Still counts as one workbook &#8211; does not explain discrepancy.<br\/>B). Permission issue<br\/>If permissions blocked visibility, the data source would not list 7 connections.<br\/>D). Custom SQL use<br\/>Catalog can still detect field usage through metadata lineage; Custom SQL does NOT hide workbook dependency.<br\/>Thus, only Option C logically explains the scenario.<br\/>* Data Catalog lineage rules: &#8220;Connected vs. Impacted&#8221; distinction.<br\/>* Field-level impact analysis documentation.<br\/>* Workbook dependency logic within Tableau Catalog.<\/div><input type='button' class='showchecked' style='margin: 10px 0;' onclick='showanswer1(20,this)' id='btn-20' value='See Answer'  \/><input type='hidden' id='questionType20' value='radio' class=''><\/div><div style='display:none' id='question-21'><br \/><div class='question-content'><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/blog.examboosts.com\/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\" style=\"margin:0 auto 20px auto;\" value=\"View Results\"  class=\"watu-submit-button\" \/>\n<input type=\"hidden\" name=\"no_ajax\" value=\"0\"><input type=\"hidden\" name=\"quiz_id\" value=\"1256\" \/>\n<input type=\"hidden\" id=\"watuStartTime\" name=\"start_time\" value=\"2026-09-23 16:49:23\" \/>\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:\/\/blog.examboosts.com\/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 = \"24877,24878,24879,24880,24881,24882,24883,24884,24885,24886,24887,24888,24889,24890,24891,24892,24893,24894,24895,24896\";\nexam_id = 1256;\nWatu.exam_id = exam_id;\nWatu.qArr = question_ids.split(',');\nWatu.post_id = 3319;\nWatu.singlePage = '1';\nWatu.hAppID = \"0.99438900 1790182163\";\nwatuURL = \"https:\/\/blog.examboosts.com\/wp-admin\/admin-ajax.php\";\nWatu.noAlertUnanswered = 0;\n});\n\nfunction showanswer1(e,q) {\n\tvar check = new Array();\n\tjQuery('.answer-' + e).each(function (i) {\n\t\tcheck.push(this.checked)\n\t})\n\tlet textval = jQuery('.watu-textarea-' + e).val()\n\tif (jQuery.inArray(true, check) >= 0 || textval !== '' && textval !== undefined) {\n\t\tjQuery(q).stop().fadeOut(300)\n\t\tjQuery('.php-answer-label.label-' + e).addClass(\n\t\t\t'correct-answer'\n\t\t)\n\t\tjQuery('.answer-' + e).each(function (i) {\n\t\t\tif (this.checked && this.className.match(\/js\\-answer\/)) {\n\t\t\t\tvar number = this.id.toString().replace(\/\\D\/g, '')\n\t\t\t\tif (number) {\n\t\t\t\t\tjQuery('#answer-label-' + number).addClass('user-answer')\n\t\t\t\t}\n\t\t\t}\n\t\t})\n\t\tjQuery(q).siblings('.show-question-feedback').stop().fadeIn(300)\n\t\ttextval = ''\n\t} else if (textval == '' || textval == undefined){\n\t\t\/\/jQuery(\".hint\").stop().fadeIn(300)\n\t\talert('Please first answer the question');\n\t}\n}\nvar btnisshow = jQuery(\".php-answer-label\").length\nif (btnisshow > 0) {\n\tjQuery('.showchecked').show()\n} else {\n\tjQuery('.showchecked').hide()\n}\n<\/script>\n<p><strong>Most Reliable Salesforce Analytics-Con-301 Training Materials: <a href=\"https:\/\/www.examboosts.com\/Salesforce\/Analytics-Con-301-practice-exam-dumps.html\" target=\"_blank\">https:\/\/www.examboosts.com\/Salesforce\/Analytics-Con-301-practice-exam-dumps.html<\/a><\/strong><\/p>\n\n","protected":false},"excerpt":{"rendered":"<p>Analytics-Con-301 Questions Prepare with Learning Information! 2026 Regularly updated Get Analytics-Con-301 Products Practice Material for Analytics-Con-301 Exam Question Preparation Salesforce Analytics-Con-301 Exam Syllabus Topics: Topic Details Topic 1 Data Analysis: This domain targets Tableau Consultants to plan and prepare data connections effectively. It includes recommending data transformation strategies, designing row-level security (RLS) data structures, and implementing advanced data connections such as Web Data Connectors and Tableau Bridge. Skills in specifying granularity and aggregation strategies for data sources across Tableau products are emphasized. Topic 2 Data Management: This part focuses on establishing governance and support for published content. Tableau Consultants are expected to manage data security, publish and maintain data sources&hellip; <br \/> <a class=\"button small blue\" href=\"https:\/\/blog.examboosts.com\/ja\/2026\/03\/analytics-con-301-questions-prepare-with-learning-information-2026-regularly-updated-q44-q63\/\">\u7d9a\u304d\u3092\u8aad\u3080<\/a><\/p>","protected":false},"author":1,"featured_media":3320,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8652,18],"tags":[8651,8648,8650,8649],"class_list":["post-3319","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-analytics-con-301","category-salesforce","tag-analytics-con-301-accurate-test","tag-analytics-con-301-exam-forum","tag-analytics-con-301-exam-study-solutions","tag-analytics-con-301-study-tool"],"_links":{"self":[{"href":"https:\/\/blog.examboosts.com\/ja\/wp-json\/wp\/v2\/posts\/3319","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.examboosts.com\/ja\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.examboosts.com\/ja\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.examboosts.com\/ja\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.examboosts.com\/ja\/wp-json\/wp\/v2\/comments?post=3319"}],"version-history":[{"count":1,"href":"https:\/\/blog.examboosts.com\/ja\/wp-json\/wp\/v2\/posts\/3319\/revisions"}],"predecessor-version":[{"id":3340,"href":"https:\/\/blog.examboosts.com\/ja\/wp-json\/wp\/v2\/posts\/3319\/revisions\/3340"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.examboosts.com\/ja\/wp-json\/wp\/v2\/media\/3320"}],"wp:attachment":[{"href":"https:\/\/blog.examboosts.com\/ja\/wp-json\/wp\/v2\/media?parent=3319"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.examboosts.com\/ja\/wp-json\/wp\/v2\/categories?post=3319"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.examboosts.com\/ja\/wp-json\/wp\/v2\/tags?post=3319"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}