// microsoft · administering-a-sql-database-infrastructure

70-

microsoft

// administering a sql database infrastructure

ADMINISTERING-A-SQL-DATABASE-INFRASTRUCTURE

Prepare for the SQL Database Infrastructure exam with domain-aligned study plans and scenario-based practice for IT professionals.

194

questions

in exam

120m

duration

Choose your mode

at a glance

What you get

PDF US$10.00Sub US$10/mopass 700

Free practice questions are available without payment; anyone can start practicing at no cost.

access options

PDF bank or platform subscription?

Two separate purchases: a one-time PDF for 70-764, or a monthly subscription for online practice and simulators across the platform. A subscription does not include the PDF download.

option / 01 · pdf file

Full question bank PDF

US$10.00· one-time

Full question bank as a print-ready PDF
Lifetime access to this exam only
Domain-tagged questions with explanations
Separate from online practice — buy once

option / 02 · subscription

All exams · practice & simulator

US$10.00· per month

Practice & exam simulator on every bank
All current and future exams included
Personal analytics and retention tools
Cancel anytime — no per-exam upsells

Subscribe for platform access

04 · coverage

Exam domains

Installation and Configuration25%

22 q

Maintenance20%

35 q

Security15%

23 q

Backup and Recovery20%

11 q

High Availability20%

13 q

Uncategorized46%

90 q

community questionsview all →

Questions from the community

Top-voted approved contributions for this exam, reviewed before landing in the bank.

// top community questionsview all →

0.0 · 0 reviews

What candidates say

no reviews yet

Administering a SQL Database Infrastructure

Prepare for the SQL Database Infrastructure exam with domain-aligned study plans and scenario-based practice for IT professionals.

// OFFICIAL EXAM LOGISTICS

source · microsoft

// PASSING SCORE

750 / 1000· scaled

minimum to pass

75%of scale

// QUESTIONS

40official

// DURATION

120min

// EXAM FEE

165usd

// ITEM TYPES

multiple choice

drag and drop

case study

// questions

257in bank

// pass rate

92%self-reported

// last update

7h agoago

// add cadence · 12w

// downloadable pdf bank

Get the whole bank as a PDF

Every question tagged by domain, with a detailed explanation. Preview the first pages free — buy once for lifetime access to the full PDF.

257 questions

// what's inside

257 exam-style questions with verified answers
Every question tagged by domain (5 domains covered)
A detailed explanation / rationale for every question

// sample · 1 of 194

See what's in the bank.

Shuffle

#q-142multiD1 · Hybridhard

↑ +47· 23 comments· seen 1,284×

A company connects its on-premises data center to AWS via a single 10 Gbps Direct Connect link and requires sub-second failover when a link goes down. BGP keepalive timers are at defaults. Which combination of changes will achieve sub-second failover without causing route flap?

Which combination of changes will achieve the goal? (Choose TWO.)

Enable BFD on the Direct Connect BGP session with a 300 ms interval and multiplier 3.

64%

Provision a second Direct Connect connection at a different DX location and rely on BGP route-withdrawal.

58%

Reduce BGP hold timer to 1 second and keepalive to 333 ms.

21%

Switch the VIF from private to public so traffic reroutes via the internet.

Community converges on A, B. Official key confirms.

4,218 votes · last validated recently

// explanation

BFD with a 300 ms interval × multiplier 3 = 900 ms detection, well under one second. Combined with a redundant Direct Connect at a different DX location, BGP withdrawal handles the cutover cleanly. Tightening BGP timers alone causes flap during normal jitter; switching VIF types is not a failover mechanism.

contributed by

@netdiver· revised by @cloud_chris

← previous

// coverage · 6 domains

What this bank tests.

microsoft exam blueprint

Installation and Configuration22 q

25%

Maintenance35 q

20%

Security23 q

15%

Backup and Recovery11 q

20%

High Availability13 q

20%

—

Uncategorized90 q

46%

// composition

By format & difficulty.

194 total

// by format

90%

10%

single · 175multi · 19

// by difficulty

easy

23· 22%

medium

70· 67%

hard

11· 11%

// contributors · 0 engineers

Built by people who took the exam.

Every question is contributed by someone who recently sat 70-764, then reviewed by an SME before landing in the bank. These are the most prolific contributors.

view leaderboard →

No contributors for this exam yet. Be the first to contribute a question.

// own this exam?Contribute a question, earn +10 points per approval, climb the leaderboard.

// community questions

Questions from the community

Top-voted approved contributions for this exam, reviewed before landing in the bank.

// top community questionsview all →

// compare

One bank, or the whole platform?

this bank

$10.00· one-time

platform · subscribed

$10.00· per month

This bank

All other banks · 23+ exams

Lifetime access

All future updates included

Personal analytics + retention

Cancel anytime

—

// 0 reviews

0.0/ 5

No reviews yet. Be the first to share your experience with this question bank.

// faq

Things buyers ask before they buy.

open help center →

Can I practice for free?

Free practice questions are available without payment; anyone can start practicing at no cost.

What do subscribers get?

Subscribers unlock the full practice question bank for each certification exam.

How much can I see without a subscription?

Approximately 1/2 of the question bank is accessible without a subscription.

What is the passing score?

The official passing mark for this exam is 700.

How long is the certification valid?

The certification is valid for 3 years. Maintain certification by retaking the exam or earning continuing education credits through Microsoft Learn.

What experience is recommended?

2-3 years of experience administering SQL Server databases in a Windows Server environment.

// related

ADMINISTERING-A-SQL-DATABASE-INFRASTRUCTURE

What you get

PDF bank or platform subscription?

Full question bank PDF

All exams · practice & simulator

Exam domains

Questions from the community

What candidates say

You may also like

Administering a SQL Database Infrastructure

Get the whole bank as a PDF

See what's in the bank.

What this bank tests.

By format & difficulty.

Built by people who took the exam.

Questions from the community

One bank, or the whole platform?

Things buyers ask before they buy.

You may also like