Microsoft DP-900 Exam - Topic 9 Question 17 Discussion

Actual exam question for Microsoft's DP-900 exam

Question #: 17
Topic #: 9

[All DP-900 Questions]

Which statement is an example of Data Manipulation Language (DML).

AINSERT

BDISABLE

CALTER

DDROP

Show Suggested Answer

Suggested Answer: A

Data Manipulation Language (DML) statements:

DELETE

INSERT

UPDATE

https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-reference-tsql-statements

by Melissa at May 07, 2022, 01:37 PM

Limited Time Offer

25%

Off

Get Premium DP-900 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Yvonne

10 months ago

A is correct, the others are different types of commands.

upvoted 0 times

...

Leonora

10 months ago

Wait, is DROP not DML? That’s surprising!

upvoted 0 times

...

Felton

11 months ago

I thought ALTER was DML too, but I guess not.

upvoted 0 times

...

Samira

11 months ago

Totally agree, INSERT is the right choice!

upvoted 0 times

...

Louvenia

11 months ago

A is definitely DML, it's used to add data.

upvoted 0 times

...

Markus

11 months ago

I thought DISABLE was a command, but I can't recall it being part of DML. A seems like the safest bet.

upvoted 0 times

...

Aimee

11 months ago

I keep mixing up DML and DDL. I think DROP is more about structure, so I’ll go with A too.

upvoted 0 times

...

Bernardine

11 months ago

I remember practicing with similar questions, and I feel like ALTER might be related, but I'm not sure if it's DML.

upvoted 0 times

...

Trina

11 months ago

I think DML is all about manipulating data, so I'm leaning towards A, INSERT.

upvoted 0 times

...

Marge

11 months ago

I think I've got it. The throughput is 360 units per hour, so the cycle time is 1 / (360 / 60) minutes, which is 0.167 minutes. The key is converting the units correctly.

upvoted 0 times

...

Alaine

11 months ago

This looks like a tricky email analysis question. I'll need to carefully review the headers and information provided to determine the best first step.

upvoted 0 times

...

Rodolfo

11 months ago

The paperclip is definitely the icon I'd expect to see for attaching files. That's my best guess.

upvoted 0 times

...

Derick

11 months ago

Okay, I think I've got it. The key is to look for protocols that transmit credentials in plaintext, like Telnet. So I'm going with option C.

upvoted 0 times

...