Salesforce Exam Marketing Cloud Developer Topic 2 Question 63 Discussion

Actual exam question for Salesforce's Marketing Cloud Developer exam

Question #: 63
Topic #: 2

[All Marketing Cloud Developer Questions]

A data extension contains two fields which are being populated by a query activity. A third field has recently been added to the data extension.

Which SELECT statement is optimal for returning all of the columns in the data extension?

ASELECT field*

BSELECT *, field1, field2, field3

CSELECT*

DSELECT 22SE, field2, field3

Show Suggested Answer

Suggested Answer: B

by Thaddeus at Mar 05, 2024, 04:16 AM

Limited Time Offer

25%

Off

Get Premium Marketing Cloud Developer Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Janna

7 days ago

C) SELECT* looks like the most straightforward option to me. Why bother with all the field names when you can just grab everything?

upvoted 0 times

...

Bev

12 days ago

I'm pretty sure the optimal solution is B) SELECT *, field1, field2, field3. The question clearly states that there are three fields, so we need to include all of them in the SELECT statement.

upvoted 0 times

Shelton

1 days ago

I think you're right, B) SELECT *, field1, field2, field3 should include all the fields.

upvoted 0 times

...

Lucina

28 days ago

But wouldn't selecting all fields with *, like in option B, be more efficient?

upvoted 0 times

...

Meaghan

1 months ago

I disagree, I believe the correct answer is D) SELECT 22SE, field2, field3.

upvoted 0 times

...

Lucina

1 months ago

I think the optimal SELECT statement is B) SELECT *, field1, field2, field3.

upvoted 0 times

...