Câu 12: QSDA2024: Qlik Sense Data Architect Certification Exam - 2024

Refer to the exhibit. A large transport company (Company A) acquires a smaller rival (Company B). Company A has been using Qlik Sense for 6 years to track revenue per ship journey. Ship journeys with no revenue (such as journeys to shipyards for repair) always show revenue of $0. Company A wants to combine its data set with the data set of the acquired Company B. Company B's ship journey data shows $0 revenue in one of the following ways:• A NULL value• A value with one or more blank spaces (ASCII char code 32)The data architect wants to conform the Company B data to the Company A standard, specifically regarding the use of an explicit $0 for journeys without revenue. Which script line should the data architect use?

1. A. money ( replace(Revenue, chr(32), 0) ) AS [Revenue Conformed]
2. B. if (len (trim(Revenue) ) — đáp án hiện tại
3. C. money ( replace(Revenue, Null(), 0) ) AS [Revenue Conformed]
4. D. replace(Revenue, chr(32), money(0) ) AS [Revenue Conformed]