Exam UiARD All QuestionsBrowse all questions from this exam
Question 195

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 needs the filtered datatable to remove two types of companies:

• Companies with revenues of 500,000 USD or more

• Companies that were founded before the year 2010

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:

Discussion
sur_bhi123456789

Revenue size should be greater than equal to sign

fedfdfd

Will the values be: "2010" or just 2010?

Herman62639

It will be 2010 because the column is of numeric value. "2010" (With quotes) refers to a string value an is not correct for this scenario.