Exam DP-203 topic 1 question 15 discussion

C is correct https://www.examtopics.com/discussions/microsoft/view/19469-exam-dp-200-topic-1-question-27-discussion/

C is correct, since "altering the schema or format of an external SQL table is not supported". https://learn.microsoft.com/en-us/azure/data-explorer/kusto/management/external-sql-tables

Got this question on my exam on january 17, C is correct

C is correct since you need to drop first and create again the external table

Answer is C. Drop the external table and recreate it. Because the column which needs to be added is the ItemID which seems like a primary key. So we have to drop the table and recreate it. Had it been any other column, we could have used ALTER syntax to add a column like shown below: ALTER EXTERNAL TABLE name action [, ... ] where action is one of: ADD [COLUMN] column_name type DROP [COLUMN] column ALTER [COLUMN] column TYPE type [USING expression] OWNER TO new_owner

C is Correct

I still can't understand why it's not D.

correct

C is correct. Even if you are confuse with other options. The clue here is keyword Location while creating external table, LOCATION = 'folder_or_filepath' : Specifies the folder or the file path and file name for the actual data.

Good thing the details are shown here: "The external table has three columns." And the solution yet reveals the column details. This doesn't make any sense to me. If C is the correct answer (only one that seems acceptable), then the question itself is flawed.

c is correct.

Answer is correct