Marketing-Cloud-Developer Exam Dumps | A data extension contains two fields which are being populated by a query activity. A third field has

Next Question >>

Question 1/50

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?

A. SELECT *, field1, field2, field3

B. SELECT*

C. SELECT field*

D. SELECT 22SE, field2, field3

Recent Comments (The most recent comments are at the top.)

Gigi - Sep 28, 2023

Answer is D, which the correct form is SELECT field1, field2, field3, because when using Select * it can cause slowness in the system when there is large amount of data and resulting in a Query Time Out.

Answer's link here: https://trailhead.salesforce.com/fr/content/learn/modules/marketing-cloud-data-management/query-data-with-sql

Marketing - Oct 26, 2021

Why is this answer D and not B?

Question 1/50

Recent Comments (The most recent comments are at the top.)

LEAVE A REPLY

Download PDF File