Data Engineering on Microsoft Azure

389 real-world practice questions with community-voted answers and discussion.

Questions

389

Status

Live now

Vendor

Microsoft

Domains

—

$30one-time

Lifetime access · Updates included

Online practice

Interactive runner with community comments and Practice / Study modes.

PDF to my inbox

Full bank as a searchable PDF, delivered in minutes.

Both (recommended)

Online access plus the PDF for offline study. Same price.

Try the free preview

All 389 questions

Community-voted answers & discussion

PDF for offline study

Free updates for a year

What's inside

Real exam-style questions

Curated from thousands of reports, with correct answers verified by community vote.

Community discussion

Every question has reasoning from practitioners who sat the exam — read why the answer is the answer.

PDF to your inbox

Prefer paper or an iPad? Get a clean, searchable PDF of the full bank as soon as you purchase.

Sample question

One question, free, no sign-up. Click the correct choice.

Topic 1 · Question 1 · Free sample

You have a table in an Azure Synapse Analytics dedicated SQL pool. The table was created by using the following Transact-SQL statement. [IMG: /assets/media/exam-media/04259/0001600001.png] You need to alter the table to meet the following requirements: ✑ Ensure that users can identify the current manager of employees. ✑ Support creating an employee reporting hierarchy for your entire company. ✑ Provide fast lookup of the managers' attributes such as name and job title. Which column should you add to the table?

A[ManagerEmployeeID] [smallint] NULL

B[ManagerEmployeeKey] [smallint] NULL

C[ManagerEmployeeKey] [int] NULL

D[ManagerName] [varchar](200) NULL

Community voted C · 27 votesStart free preview →