{"id":14866,"date":"2026-09-17T07:43:37","date_gmt":"2026-09-17T07:43:37","guid":{"rendered":"https:\/\/www.examlabs.com\/certification\/?p=14866"},"modified":"2026-09-17T07:43:37","modified_gmt":"2026-09-17T07:43:37","slug":"microsoft-pl-300-practice-test-questions-and-exam-dumps-part17-q321-340","status":"publish","type":"post","link":"https:\/\/www.examlabs.com\/certification\/microsoft-pl-300-practice-test-questions-and-exam-dumps-part17-q321-340\/","title":{"rendered":"Microsoft PL-300 Practice Test Questions and Exam Dumps Part17 Q321-340"},"content":{"rendered":"

<\/h1>\n

View Full <\/b>Microsoft PL-300 Exam Dumps<\/b><\/a> and Practice Test Dumps.<\/b><\/h2>\n

 <\/p>\n

Question 321<\/b><\/h3>\n

Which DAX function can return the number of days between two dates?<\/b><\/p>\n

    \n
  1. DATEDIFF<\/span><\/li>\n
  2. DATE<\/span><\/li>\n
  3. DAY<\/span><\/li>\n
  4. DAYS<\/span><\/li>\n<\/ol>\n

    Correct Answer: 1<\/b><\/p>\n

    Explanation<\/b><\/p>\n

    DATEDIFF calculates the difference between two dates using a specified interval, such as day, month, quarter, or year. It is useful for measuring durations such as delivery time, customer tenure, subscription length, or the number of days between an order and shipment. For example, DATEDIFF([OrderDate], [ShipDate], DAY) returns the number of days between those dates. DATE creates a date value, DAY extracts the day component, and DAYS is not the standard DAX function for this purpose. Therefore, DATEDIFF is correct.<\/span><\/p>\n

    Question 322<\/b><\/h3>\n

    Which Power Query feature allows a user to combine data from several files that have a similar structure?<\/b><\/p>\n

      \n
    1. Group By<\/span><\/li>\n
    2. Combine Files<\/span><\/li>\n
    3. Split Column<\/span><\/li>\n
    4. Transpose<\/span><\/li>\n<\/ol>\n

      Correct Answer: 2<\/b><\/p>\n

      Explanation<\/b><\/p>\n

      Combine Files is useful when multiple files have a similar structure and their contents need to be brought together into one dataset. This is common when monthly reports, regional files, or recurring exports are stored separately but contain matching columns. Power Query can create a process that combines the files and applies transformations consistently. Group By summarizes data, Split Column separates values, and Transpose changes the orientation of a table. Therefore, Combine Files is the appropriate feature for consolidating similarly structured files.<\/span><\/p>\n

      Question 323<\/b><\/h3>\n

      Which DAX function can return the selected value when one value exists and a specified alternative when multiple values exist?<\/b><\/p>\n

        \n
      1. VALUES<\/span><\/li>\n
      2. HASONEVALUE<\/span><\/li>\n
      3. SELECTEDVALUE<\/span><\/li>\n
      4. DISTINCT<\/span><\/li>\n<\/ol>\n

        Correct Answer: 3<\/b><\/p>\n

        Explanation<\/b><\/p>\n

        SELECTEDVALUE returns the single value from a column when exactly one distinct value is present in the current filter context. It can also return a specified alternate result when zero or multiple values are selected. This makes it useful for dynamic report titles, labels, and calculations that depend on user selections. HASONEVALUE only tests whether one value exists, while VALUES and DISTINCT return tables containing values rather than directly providing an alternate-result mechanism. Therefore, SELECTEDVALUE is the correct DAX function for this requirement.<\/span><\/p>\n

        Question 324<\/b><\/h3>\n

        Which Power BI modeling feature allows a relationship to be created between tables using columns that do not contain matching unique values on both sides?<\/b><\/p>\n

          \n
        1. One-to-one<\/span><\/li>\n
        2. One-to-many<\/span><\/li>\n
        3. Many-to-many<\/span><\/li>\n
        4. One-to-zero<\/span><\/li>\n<\/ol>\n

          Correct Answer: 3<\/b><\/p>\n

          Explanation<\/b><\/p>\n

          Many-to-many cardinality allows multiple records on both sides of a relationship to correspond with each other. It can be useful when neither participating column contains unique values and the business scenario genuinely requires multiple matches. For example, a customer can belong to multiple groups while each group can contain multiple customers. One-to-one requires unique matching records on both sides, while one-to-many expects uniqueness on one side. Therefore, many-to-many is the appropriate relationship cardinality when multiple records can match on both sides.<\/span><\/p>\n

          Question 325<\/b><\/h3>\n

          Which DAX function can change the filter context by using an inactive relationship between two tables?<\/b><\/p>\n

            \n
          1. USERELATIONSHIP<\/span><\/li>\n
          2. RELATED<\/span><\/li>\n
          3. CROSSFILTER<\/span><\/li>\n
          4. LOOKUPVALUE<\/span><\/li>\n<\/ol>\n

            Correct Answer: 1<\/b><\/p>\n

            Explanation<\/b><\/p>\n

            USERELATIONSHIP activates an existing inactive relationship for the duration of a calculation. This is useful when a model contains multiple possible relationships between tables, such as an Orders table connected to a Date table through both Order Date and Ship Date. One relationship can remain active while another is activated within a specific measure. RELATED retrieves a related value, CROSSFILTER changes filter direction, and LOOKUPVALUE performs value searches. Therefore, USERELATIONSHIP is the appropriate DAX function for using an inactive relationship during a calculation.<\/span><\/p>\n

            Question 326<\/b><\/h3>\n

            Which Power Query option allows a user to keep only rows that meet a specified condition?<\/b><\/p>\n

              \n
            1. Remove Rows<\/span><\/li>\n
            2. Filter Rows<\/span><\/li>\n
            3. Keep Columns<\/span><\/li>\n
            4. Group By<\/span><\/li>\n<\/ol>\n

              Correct Answer: 2<\/b><\/p>\n

              Explanation<\/b><\/p>\n

              Filter Rows keeps records that satisfy specified conditions and excludes records that do not meet those conditions. For example, a Power Query table can be filtered to retain only sales from a particular region or transactions above a specific amount. This helps prepare a focused dataset before loading it into the Power BI model. Remove Rows can eliminate records according to selected row operations, Keep Columns controls fields rather than records, and Group By creates summaries. Therefore, Filter Rows is the appropriate transformation for this requirement.<\/span><\/p>\n

              Question 327<\/b><\/h3>\n

              Which DAX function can return the average of an expression evaluated for each row of a table?<\/b><\/p>\n

                \n
              1. AVERAGE<\/span><\/li>\n
              2. AVERAGEX<\/span><\/li>\n
              3. MEDIAN<\/span><\/li>\n
              4. SUMX<\/span><\/li>\n<\/ol>\n

                Correct Answer: 2<\/b><\/p>\n

                Explanation<\/b><\/p>\n

                AVERAGEX evaluates an expression for every row of a specified table and then calculates the average of the resulting values. It is useful when the required average depends on a row-level calculation rather than simply averaging an existing column. For example, AVERAGEX can calculate average revenue per transaction by evaluating Quantity multiplied by Unit Price for each row. AVERAGE directly averages a column, MEDIAN returns the middle value, and SUMX performs row-level calculations followed by summation. Therefore, AVERAGEX is correct.<\/span><\/p>\n

                Question 328<\/b><\/h3>\n

                Which Power BI visual is designed to show progress toward a target value?<\/b><\/p>\n

                  \n
                1. Gauge<\/span><\/li>\n
                2. Treemap<\/span><\/li>\n
                3. Scatter chart<\/span><\/li>\n
                4. Matrix<\/span><\/li>\n<\/ol>\n

                  Correct Answer: 1<\/b><\/p>\n

                  Explanation<\/b><\/p>\n

                  A Gauge visual displays a current value in relation to a target or goal. It is useful for metrics such as sales performance, production progress, budget utilization, or service-level achievement. The visual provides an immediate indication of how close the current result is to the defined target. A Treemap compares categories using rectangular areas, a Scatter chart analyzes relationships between numerical variables, and a Matrix displays structured data. Therefore, Gauge is the appropriate visual when the objective is to show progress toward a target.<\/span><\/p>\n

                  Question 329<\/b><\/h3>\n

                  Which DAX function can remove filters from a calculation while still allowing the expression to return a table?<\/b><\/p>\n

                    \n
                  1. ALL<\/span><\/li>\n
                  2. FILTER<\/span><\/li>\n
                  3. VALUES<\/span><\/li>\n
                  4. DISTINCT<\/span><\/li>\n<\/ol>\n

                    Correct Answer: 1<\/b><\/p>\n

                    Explanation<\/b><\/p>\n

                    ALL returns all rows or values from a specified table or column while removing filters applied to that table or column. It is commonly used in calculations such as percentage of total, where the denominator must ignore a particular filter while retaining other relevant context. For example, ALL(Product[Category]) can remove the category filter from a calculation. FILTER creates a filtered table, VALUES returns values under the current context, and DISTINCT returns unique values. Therefore, ALL is appropriate when filters need to be removed while producing a table expression.<\/span><\/p>\n

                    Question 330<\/b><\/h3>\n

                    Which Power Query transformation changes a column containing combined information into multiple separate columns?<\/b><\/p>\n

                      \n
                    1. Merge Columns<\/span><\/li>\n
                    2. Split Column<\/span><\/li>\n
                    3. Pivot Column<\/span><\/li>\n
                    4. Append Queries<\/span><\/li>\n<\/ol>\n

                      Correct Answer: 2<\/b><\/p>\n

                      Explanation<\/b><\/p>\n

                      Split Column separates the contents of one column into multiple columns according to a selected method, such as a delimiter, number of characters, or position. For example, a column containing “Lahore – Punjab” can be split into separate City and Province columns using a delimiter. Merge Columns performs the opposite operation by combining fields. Pivot Column restructures values into columns, while Append Queries combines rows from multiple queries. Therefore, Split Column is the appropriate transformation when one combined field needs to be separated.<\/span><\/p>\n

                      Question 331<\/b><\/h3>\n

                      Which DAX function can return the end date of a month after applying a specified number of months to a date?<\/b><\/p>\n

                        \n
                      1. EDATE<\/span><\/li>\n
                      2. EOMONTH<\/span><\/li>\n
                      3. DATEADD<\/span><\/li>\n
                      4. LASTDATE<\/span><\/li>\n<\/ol>\n

                        Correct Answer: 2<\/b><\/p>\n

                        Explanation<\/b><\/p>\n

                        EOMONTH returns the last date of the month that occurs a specified number of months before or after a starting date. It is useful for calculations involving monthly reporting periods, billing cycles, deadlines, and period-end dates. For example, EOMONTH([StartDate], 1) can return the final day of the following month. EDATE shifts an individual date without necessarily returning month-end, DATEADD shifts a date context, and LASTDATE returns the last date in the current context. Therefore, EOMONTH is correct.<\/span><\/p>\n

                        Question 332<\/b><\/h3>\n

                        Which Power BI feature allows a user to change the visual interaction between two visuals on the same page?<\/b><\/p>\n

                          \n
                        1. Edit Interactions<\/span><\/li>\n
                        2. Selection Pane<\/span><\/li>\n
                        3. Performance Analyzer<\/span><\/li>\n
                        4. Sync Slicers<\/span><\/li>\n<\/ol>\n

                          Correct Answer: 1<\/b><\/p>\n

                          Explanation<\/b><\/p>\n

                          Edit Interactions allows report authors to control how one visual affects another visual when users make selections. Depending on the desired behavior, a visual can filter another visual, highlight it, or have no interaction. This is useful when a report needs customized cross-filtering behavior instead of the default interactions. Selection Pane controls object visibility and ordering, Performance Analyzer examines report performance, and Sync Slicers synchronizes slicer selections across pages. Therefore, Edit Interactions is the correct Power BI feature.<\/span><\/p>\n

                          Question 333<\/b><\/h3>\n

                          Which DAX function can return the number of rows in a table expression?<\/b><\/p>\n

                            \n
                          1. COUNT<\/span><\/li>\n
                          2. COUNTA<\/span><\/li>\n
                          3. COUNTROWS<\/span><\/li>\n
                          4. DISTINCTCOUNT<\/span><\/li>\n<\/ol>\n

                            Correct Answer: 3<\/b><\/p>\n

                            Explanation<\/b><\/p>\n

                            COUNTROWS returns the number of rows in a table or table expression. It is especially useful when the table being counted is produced dynamically by another DAX function. For example, COUNTROWS(FILTER(Sales, Sales[Amount] > 500)) can count sales transactions whose amount exceeds 500. COUNT counts numeric values in a column, COUNTA counts nonblank values, and DISTINCTCOUNT counts unique values in a column. Therefore, COUNTROWS is the appropriate function when the requirement is to count records in a table expression.<\/span><\/p>\n

                            Question 334<\/b><\/h3>\n

                            Which Power BI feature can display a visual with categories arranged according to their contribution to a process that decreases from one stage to another?<\/b><\/p>\n

                              \n
                            1. Waterfall chart<\/span><\/li>\n
                            2. Funnel chart<\/span><\/li>\n
                            3. Card<\/span><\/li>\n
                            4. Map<\/span><\/li>\n<\/ol>\n

                              Correct Answer: 2<\/b><\/p>\n

                              Explanation<\/b><\/p>\n

                              A Funnel chart is designed to display values across sequential stages of a process, often showing a reduction in volume from one stage to the next. It is commonly used for sales pipelines, conversion processes, application stages, and other workflows where the number of items changes between steps. A Waterfall chart shows positive and negative contributions to a total, while a Card displays a single value and a Map represents geographic information. Therefore, Funnel chart is the appropriate visual for sequential stage analysis.<\/span><\/p>\n

                              Question 335<\/b><\/h3>\n

                              Which DAX function can return the previous quarter relative to the current date context?<\/b><\/p>\n

                                \n
                              1. PREVIOUSQUARTER<\/span><\/li>\n
                              2. PREVIOUSMONTH<\/span><\/li>\n
                              3. QUARTER<\/span><\/li>\n
                              4. DATEADD<\/span><\/li>\n<\/ol>\n

                                Correct Answer: 1<\/b><\/p>\n

                                Explanation<\/b><\/p>\n

                                PREVIOUSQUARTER returns a table containing dates from the quarter immediately preceding the current date context. It is useful for quarter-over-quarter comparisons of sales, profit, expenses, or other measures. For example, a measure can use PREVIOUSQUARTER inside CALCULATE to determine the value for the preceding quarter. PREVIOUSMONTH operates at the month level, QUARTER extracts a quarter number, and DATEADD can shift dates by a specified interval. Therefore, PREVIOUSQUARTER is the appropriate function for retrieving the previous quarter’s date context.<\/span><\/p>\n

                                Question 336<\/b><\/h3>\n

                                Which Power Query feature can combine two tables by matching values in one or more common columns?<\/b><\/p>\n

                                  \n
                                1. Append Queries<\/span><\/li>\n
                                2. Merge Queries<\/span><\/li>\n
                                3. Group By<\/span><\/li>\n
                                4. Fill Down<\/span><\/li>\n<\/ol>\n

                                  Correct Answer: 2<\/b><\/p>\n

                                  Explanation<\/b><\/p>\n

                                  Merge Queries combines tables by matching values in one or more columns. It is similar to a database join and can be used to bring related information from one query into another. For example, a Sales query can be merged with a Product query using ProductID to retrieve product attributes. Append Queries adds rows from one query beneath another, while Group By creates summaries and Fill Down populates blank cells using preceding values. Therefore, Merge Queries is the correct Power Query operation for matching related records.<\/span><\/p>\n

                                  Question 337<\/b><\/h3>\n

                                  Which DAX function can calculate the total for the current month-to-date period?<\/b><\/p>\n

                                    \n
                                  1. TOTALQTD<\/span><\/li>\n
                                  2. TOTALMTD<\/span><\/li>\n
                                  3. TOTALYTD<\/span><\/li>\n
                                  4. MONTH<\/span><\/li>\n<\/ol>\n

                                    Correct Answer: 2<\/b><\/p>\n

                                    Explanation<\/b><\/p>\n

                                    TOTALMTD calculates the month-to-date value of an expression according to the current date context. It accumulates values from the beginning of the current month through the selected date. This is useful for monitoring sales, revenue, expenses, or other metrics as a month progresses. TOTALQTD performs quarter-to-date calculations, TOTALYTD calculates year-to-date results, and MONTH returns the month number from a date. Therefore, TOTALMTD is the appropriate DAX function when a calculation needs to represent the current month’s accumulated value.<\/span><\/p>\n

                                    Question 338<\/b><\/h3>\n

                                    Which Power BI feature can display the same report with a different arrangement of visuals specifically for smartphones?<\/b><\/p>\n

                                      \n
                                    1. Mobile layout<\/span><\/li>\n
                                    2. Bookmarks<\/span><\/li>\n
                                    3. Page navigation<\/span><\/li>\n
                                    4. Selection pane<\/span><\/li>\n<\/ol>\n

                                      Correct Answer: 1<\/b><\/p>\n

                                      Explanation<\/b><\/p>\n

                                      Mobile layout allows report authors to create a separate arrangement of supported visuals optimized for smartphone screens. The desktop report can maintain its original design while the mobile layout positions visuals in a more suitable order and size for smaller displays. This improves usability when users access the report through the Power BI mobile experience. Bookmarks save report states, Page navigation controls movement between pages, and Selection Pane manages visual visibility and layering. Therefore, Mobile layout is the appropriate feature for smartphone-specific report design.<\/span><\/p>\n

                                      Question 339<\/b><\/h3>\n

                                      Which DAX function can return the first value for which a specified expression is not blank?<\/b><\/p>\n

                                        \n
                                      1. FIRSTDATE<\/span><\/li>\n
                                      2. FIRSTNONBLANK<\/span><\/li>\n
                                      3. MIN<\/span><\/li>\n
                                      4. VALUES<\/span><\/li>\n<\/ol>\n

                                        Correct Answer: 2<\/b><\/p>\n

                                        Explanation<\/b><\/p>\n

                                        FIRSTNONBLANK returns the first value in a column for which a specified expression is not blank. It is useful when the earliest meaningful value needs to be identified while ignoring dates or records where the associated expression contains no result. FIRSTDATE returns the first date in a context regardless of whether another expression is blank. MIN returns the smallest value, while VALUES returns a table of values. Therefore, FIRSTNONBLANK is the appropriate function when the first nonblank result needs to be identified.<\/span><\/p>\n

                                        Question 340<\/b><\/h3>\n

                                        Which Power Query feature can identify relationships and dependencies between queries in a data preparation process?<\/b><\/p>\n

                                          \n
                                        1. Query Dependencies<\/span><\/li>\n
                                        2. Column Profiling<\/span><\/li>\n
                                        3. Data Source Settings<\/span><\/li>\n
                                        4. Applied Steps<\/span><\/li>\n<\/ol>\n

                                          Correct Answer: 1<\/b><\/p>\n

                                          Explanation<\/b><\/p>\n

                                          Query Dependencies provides a visual representation of how queries relate to one another within Power Query. It helps users understand which queries are sources for other queries and how data flows through the transformation process. This is particularly useful in complex projects containing staging queries, referenced queries, and multiple transformation layers. Column Profiling focuses on data quality, Data Source Settings manages source connections and permissions, and Applied Steps displays transformations within a specific query. Therefore, Query Dependencies is correct.<\/span><\/p>\n

                                           <\/p>\n","protected":false},"excerpt":{"rendered":"

                                          View Full Microsoft PL-300 Exam Dumps and Practice Test Dumps.   Question 321 Which DAX function can return the number of days between two dates? DATEDIFF DATE DAY DAYS Correct Answer: 1 Explanation DATEDIFF calculates the difference between two dates using a specified interval, such as day, month, quarter, or year. It is useful for […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[1648,1647],"tags":[],"_links":{"self":[{"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/posts\/14866"}],"collection":[{"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/comments?post=14866"}],"version-history":[{"count":1,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/posts\/14866\/revisions"}],"predecessor-version":[{"id":14925,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/posts\/14866\/revisions\/14925"}],"wp:attachment":[{"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/media?parent=14866"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/categories?post=14866"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/tags?post=14866"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}