Exam UiARD All QuestionsBrowse all questions from this exam
Go to Exam
Question 137

HOTSPOT -

A developer has a datatable, dt_Companies, containing data for numerous companies. In the datatable, RevenueSize is a numeric column representing the current revenue in USD and YearFounded is a numeric column representing the year the company was founded. The developer does not want companies with both of the following conditions to appear in dt_FilterCompanies:

Companies that were founded before the year 2010

Companies having revenues of 500,000 USD or less

Instructions: Using the drop-down lists for Column, Operation, and Value, configure the Filter Wizard of the Filter Data Table activity to place the filtered results in dt_FilterCompanies.

    Correct Answer:

    To filter out companies that were founded before the year 2010 and have revenues of 500,000 USD or less, you need to configure the Filter Data Table activity to remove rows matching the specific conditions. The correct configuration for the Filter Wizard is as follows: Select 'Remove' for matching rows, set 'YearFounded' as the column with the '<' operation and '2010' as the value, then set 'RevenueSize' as the column with the '<=' operation and '500000' as the value. This ensures that companies meeting both conditions are excluded from dt_FilterCompanies.

Discussion
Engineer24

The correct answer is: "YearFounded" < 2010 And "RevenueSize" <= 500000 Tested in Studio