Develop data processing →hardMultiple ChoiceObjective-mapped

DP-203 Develop data processing Practice Question

Exhibit

Refer to the exhibit.

-- KQL query in Azure Data Explorer
let startTime = datetime(2024-01-01);
let endTime = datetime(2024-01-02);
T
| where Timestamp between (startTime .. endTime)
| summarize count() by bin(Timestamp, 1h)
| render timechart

Refer to the exhibit. You are running the KQL query in Azure Data Explorer. The query returns no results, but you know there is data in the table T. What is the most likely issue?

⚠ Common exam trap

Microsoft often tests the exact syntax of KQL operators like `between`, where candidates overlook the requirement for no spaces around the two dots, assuming whitespace is allowed as in other languages.

Answer choices

Why each option matters

Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.

Correct answer & explanation

✓

The between operator syntax is incorrect; should be 'between (startTime..endTime)' without spaces around the dots

The KQL `between` operator requires the range syntax `between(datetime1..datetime2)` with no spaces around the two dots. The query uses `between (startTime .. endTime)` with spaces, which is invalid syntax and causes the query to return no results even though data exists in table T.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

✗
The bin function is used incorrectly; should be bin(Timestamp, 1h) but placed in the wrong clause
Why it's wrong here
bin is correctly used in summarize.
✓
The between operator syntax is incorrect; should be 'between (startTime..endTime)' without spaces around the dots
Why this is correct
Spaces around the '..' can cause the range to be misparsed.
✗
The datetime format is incorrect; use ISO 8601
Why it's wrong here
The datetime literals are correct.
✗
The table T does not exist in the database
Why it's wrong here
If table didn't exist, there would be an error, not empty results.

Go deeper

DP-203 Develop data processing Practice Question

Exhibit

Why each option matters

Option-by-option breakdown

Related to this question