MENU
You use Azure SQL Database Intelligent Insights and Azure Application Insights for monitoring.
You need to write ad-hoc queries against the monitoring data.
Which query language should you use?
Suggested Answer: A
Get Premium AZ-400 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
Azure Monitor Logs is based on Azure Data Explorer, and log queries are written using the same Kusto query language (KQL). This is a rich language designed to be easy to read and author, and you
should be able to start using it with minimal guidance.
https://docs.microsoft.com/en-us/azure/azure-monitor/log-query/log-query-overview
16 comments · newest first
JU
Jules
12 months ago
KQL all the way! It’s designed for this kind of data.
WE
Werner
1 year ago
Wait, are we sure KQL is the only option?
EL
Eladia
1 year ago
KQL is the right choice, no doubt about it!
LA
Lavera
1 year ago
I thought PL/pgSQL was the way to go?
ER
Erick
1 year ago
Definitely Kusto Query Language (KQL) for Azure insights!
TR
Tracie
1 year ago
I keep mixing up Transact-SQL and KQL. I hope I remember the right one for this exam!
UL
Ulysses
1 year ago
I practiced a similar question, and I think KQL was mentioned as the go-to for Azure insights.
AL
Alpha
1 year ago
I'm not entirely sure, but I feel like PL/SQL is more for Oracle databases, so that might not be it.
GE
Georgene
1 year ago
I think it's Kusto Query Language, right? I remember it being used for Azure monitoring tools.
NU
Nu
1 year ago
I've worked with Cloud Pak for Integration before, and I'm confident the answer is B. CSV is the go-to format for exporting metering reports.
DA
Darrin
1 year ago
Hmm, not sure about this one. I need to think carefully about the options and make sure I understand what each one is asking. Might need to review my notes on employee engagement and management systems.
LI
Linette
1 year ago
Okay, let's see. Version management and requirements tracing seem like the two areas that would be least supported by just using text processing. I'll mark those.
BU
Buddy
1 year ago
I remember studying a question similar to this one; I thought the AIR-AP18151-K9C might be a possibility too.
TA
Tamesha
1 year ago
Okay, let me think this through. The options are DB security group, DB snapshot, DB options group, and DB parameter group. I'm guessing DB security group is the one that can't be subscribed to, since that's more of a configuration setting than an event.
MA
Maile
1 year ago
This seems like a tricky one. I'll need to carefully review the options and think through the potential issues with Pub/Sub and message processing.
GL
Glory
1 year ago
I'm leaning towards "active" and "primary" for the roles, but the terminology can be so tricky!