Microsoft 98-364

Not sure whether Dumpkiller is right for you? Download the free 98-364 demo and review a sample of our 130 Microsoft Database Fundamentals practice questions before you spend a cent.

Microsoft 98-364 Exam Overview:

Microsoft 98-364 Exam Syllabus Topics:

Your 98-364 Exam Questions, Answered

What is the 98-364 exam all about?

The Microsoft Database Fundamentals exam (code: 98-364) is the official Microsoft exam that leads to the MTA: Database Fundamentals certification. It sits at the Entry / Associate level of the Microsoft certification track. It is also connected with related credentials such as MTA: Windows Server Administration Fundamentals, MTA: Networking Fundamentals, MTA: Security Fundamentals. Passing it proves to employers that your skills have been validated by Microsoft itself, which is why the 98-364 credential keeps showing up in job postings.

How many questions are in the 98-364 exam, and how long does it take?

The Microsoft Database Fundamentals exam gives you 45 minutes to work through 40-60. Pacing matters more than most candidates expect, so before exam day, run at least one full timed session in the Dumpkiller test engine to learn how long you can afford per question. If an item stalls you, flag it and move on — coming back later beats burning five minutes on a single question.

What score do I need to pass the 98-364 exam, and how much does it cost?

The passing score for the Microsoft Database Fundamentals exam is 700 / 1000, and the official registration fee is $127 USD. Remember that a failed attempt means paying that fee in full again, so a timed self-assessment with Dumpkiller practice questions about a week before your exam date is a cheap way to confirm you are scoring comfortably above 700 / 1000.

Are there any prerequisites for the 98-364 exam?

According to Microsoft, the following applies: No mandatory prerequisites; minimal hands-on experience with databases recommended. Certification policies do change from time to time, so confirm the latest requirements on the official exam page at https://learn.microsoft.com/en-us/certifications/exams/98-364/ before you register.

How do I register for the 98-364 exam?

You can book your Microsoft Database Fundamentals exam through the official channels below:

• Microsoft Official Exam Page
• Certiport Registration

Depending on availability in your region, the exam is delivered as Proctored onsite or online via Certiport / Pearson VUE; retired June 30, 2022.

What official training does Microsoft recommend for the 98-364 exam?

Microsoft lists the following training options for Microsoft Database Fundamentals candidates:

• 40364A: Database Administration Fundamentals
• Microsoft Learn Self-paced Modules

Official courses build a solid foundation, and pairing them with the 130 practice questions from Dumpkiller shows you how ready you really are before you spend money on the exam itself.

Can I try the 98-364 practice questions before buying?

Yes. Dumpkiller offers a free 98-364 PDF demo so you can review the question style, difficulty, and explanations before committing to anything. After purchase, your Microsoft Database Fundamentals material includes 365 days of free updates, and if your product expires after that, you can extend the update service at a 50% discount from your member zone.

What happens if I do not pass the 98-364 exam, and how is my order delivered?

If you take the corresponding 98-364 exam within 60 days of your purchase and do not pass, you can apply for a full refund under our 100% Money Back Guarantee, subject to a few conditions: the failed exam must be the one matching your purchase; sitting the exam within 3 days of purchase does not qualify, since that leaves too little preparation time; downloading the material without actually taking the exam does not qualify; free materials and expired orders are excluded; and the candidate name must match the payer name. To apply, send a scanned copy of your enrollment slip together with your official Score Report (PDF) within 2 days after the exam, and claims are processed within 7 days. If you would rather not take a refund, you can exchange your purchase for two free products of equal value while keeping the update service on the product you originally bought. As for delivery, everything is an instant download: your products are sent to your email within one minute of payment — contact customer service if nothing arrives within 2 hours — and there is no limit on the number of computers you can install the software on.

What topics are covered in the 98-364 exam?

The official Microsoft Database Fundamentals syllabus is organized into 5 main domains. The first three are Understanding core database concepts (20-25), Administer a database (10-15), and Manipulate data (25-30). For the full domain-by-domain breakdown, see the complete Exam Topics outline above.

Microsoft Database Fundamentals Sample Questions:

Question #1

The component that holds information for a single entry in a table is called a:

A. Column
B. Row
C. Data type
D. View

Question #2

Which command should you use to add a column to an existing table?

A. UPDATE
B. CHANGE
C. MODIFY
D. ALTER
E. INSERT

Question #3

Which statement should you use to remove a foreign key?

A. ALTER TABLE
B. DELETE FOREIGN KEY
C. ALTER FOREIGN KEY
D. DELETE TABLE

Question #4

You have a table named Student that contains 100 rows. Some of the rows have a NULL
value in the FirstName column.
You execute the following statement:
DELETE FROM Student
What is the result?

A. All rows in the table will be deleted.
B. All rows and the table definition will be deleted.
C. You will receive an error message.
D. All rows containing a NULL value in the FirstName column will be deleted.

Question #5

You are writing a select statement to find every product whose name contains a specific character.
Which keyword should you use in your where clause?

A. LIKE
B. INCLUDES
C. BETWEEN
D. FIND

Solutions: