Which tool or technique uses dynamic parameters to reduce a data set to viewing only similar items in a row or column?

Which tool or technique uses dynamic parameters to reduce a data set to viewing only similar items in a row or column?

• A. Sort
• B. Filter
• C. Transform
• D. Select

Answer: (B)

Filtering narrows a data set to only the items that meet a given condition. When you use dynamic parameters with a filter, the condition can change based on user input or other data, so you only see rows (or columns) that share a specific property. For example, you might filter a table of products to show only those in a chosen category or with a price below a threshold. Sorting would just reorder everything, transforming would change the values, and selecting would pick which fields to view without reducing to similar items. So the technique that uses dynamic parameters to view only similar items is filtering.

Filtering narrows a data set to only the items that meet a given condition. When you use dynamic parameters with a filter, the condition can change based on user input or other data, so you only see rows (or columns) that share a specific property. For example, you might filter a table of products to show only those in a chosen category or with a price below a threshold. Sorting would just reorder everything, transforming would change the values, and selecting would pick which fields to view without reducing to similar items. So the technique that uses dynamic parameters to view only similar items is filtering.