The___________function can be used to append a string to ID fields(suchas campaign_id),preventing issues reading the accurate ID values within Excel.
Choose an answer
Tap an option to check your answer.
Correct answer: CONCAT.
Why this is the answer
The CONCAT function is correct because it allows you to combine two or more strings into a single string. In this scenario, appending a string (like a prefix or suffix) to an ID field before exporting to Excel can prevent Excel from misinterpreting long numerical IDs as scientific notation or losing precision, which is a common issue. SUM is incorrect because it is an aggregate function used for adding numerical values, not for manipulating strings or preventing data formatting issues in Excel.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed