PDF Version DemoGood service starts with fast delivery: ActualPDF emails the complete Microsoft Administering a SQL Database Infrastructure package, 452 070-764 practice questions included, about a minute after payment, with support online 7/24 if you need it.
Microsoft 070-764 Exam Overview:
| Certification Vendor: | Microsoft |
|---|---|
| Exam Name: | Administering a SQL Database Infrastructure |
| Exam Number: | 70-764 |
| Exam Format: | Multiple choice, Case studies, Short answer, Best answer selection |
| Certificate Validity Period: | Retired (certification no longer offered) |
| Related Certifications: | MCSE: Data Management and Analytics (retired) MCSA: SQL 2016 Database Administration |
| Available Languages: | German, French, Simplified Chinese, Spanish, Korean, Japanese, English |
| Exam Duration: | 120-150 |
| Passing Score: | 700 (on a 1000 scale) |
| Exam Price: | $165 USD (varies by country) |
| Real Exam Qty: | 40-60 (varies) |
| Recommended Training: | Microsoft Learn SQL Server Training SQL Server Administration Documentation |
| Exam Registration: | Microsoft Certification Portal Pearson VUE Exam Registration |
| Sample Questions: | DOWNLOAD DEMO |
| Exam Way: | Online proctored or test center (Pearson VUE) |
| Pre Condition: | No formal prerequisite required, but experience with SQL Server administration is recommended. Typically part of the MCSA SQL 2016 certification path. |
| Official Syllabus URL: | https://learn.microsoft.com/en-us/credentials/certifications/exams/70-764/ |
Microsoft 070-764 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Maintain and optimize databases | - Index management
|
| Manage high availability and disaster recovery | - Backup and restore planning
|
| Monitor and troubleshoot SQL Server | - Troubleshooting performance issues
|
| Manage SQL Server infrastructure | - Install and configure SQL Server
|
| Plan and implement data storage | - Manage databases and files
|
Microsoft 070-764 Exam: What Candidates Want to Know
Microsoft Administering a SQL Database Infrastructure is an official Microsoft certification exam, registered under the code 070-764. Passing it awards the MCSA: SQL 2016 Database Administration (Retired) certification, a credential at the Associate level. It also connects to MCSA: SQL 2016 Database Administration, MCSE: Data Management and Analytics (retired). The exam is demanding by design, and that difficulty is precisely what makes the credential meaningful for career development.
The Microsoft Administering a SQL Database Infrastructure exam presents 40-60 (varies) questions within 120-150. That is a brisk pace, and the candidates who handle it best are the ones who rehearsed it. Use the ActualPDF engine for full timed simulations, practice flagging and returning, and arrive on exam day with a pacing strategy already proven.
Passing Microsoft Administering a SQL Database Infrastructure takes 700 (on a 1000 scale), and official registration costs $165 USD (varies by country). Retakes bill the full $165 USD (varies by country) again, so preparation is the least expensive insurance available. Let your ActualPDF practice scores guide the timing: book when you clear the requirement consistently, not occasionally.
No formal prerequisite required, but experience with SQL Server administration is recommended. Typically part of the MCSA SQL 2016 certification path.
Policies get revised, so confirm the current requirements before you register on the official exam page.
Microsoft Administering a SQL Database Infrastructure registration is handled through the official channels below.
For scheduling purposes: the exam is delivered Online proctored or test center (Pearson VUE).
Yes, Microsoft recommends the following training for Microsoft Administering a SQL Database Infrastructure candidates.
Complement any training with the 452 practice questions in the ActualPDF 070-764 package, because repeated application is what turns course knowledge into a passing score.
Yes. ActualPDF offers a free demo of the Microsoft Administering a SQL Database Infrastructure questions, so you can verify the quality personally before purchasing. Your purchase then includes a one-year service warranty: updates are free for 365 days, and after expiry you can extend the update service at a 50% discount.
Your money is protected by a 100% money-back guarantee with defined conditions. Take the Microsoft Administering a SQL Database Infrastructure exam within 60 days of purchase; if you fail, you may claim a full refund, provided the exam matches your product. Attempts within 3 days of purchase are ineligible, as are downloaded-but-unused products, free materials, and expired orders; the candidate name must match the payer name. Submit a scanned enrollment slip and the official Score Report PDF within 2 days of the exam, and claims are processed within 7 days. You may instead wait for the update version or change to other exam material: exchange for two other exam products of equal value, free, with your original purchase keeping its update service.
Delivery is instant: files unlock for download at payment and are emailed within one minute. If nothing arrives within 2 hours, check spam and contact customer service, online 7/24 even on official holidays. Installation is unlimited across your computers.
Microsoft Administering a SQL Database Infrastructure is organized into 5 official domains. The most heavily weighted are Manage high availability and disaster recovery, Maintain and optimize databases, and Plan and implement data storage. The full breakdown appears above on this page; study the weightings and your preparation priorities set themselves.
Microsoft Administering a SQL Database Infrastructure Sample Questions:
You have the following Microsoft SQL Server instances. The instances are members of a cluster:
Server1 has 42 gigabytes (GB) of memory and server 2 has 4g of memory. The operating system and other processes on each.......... server required 4 GB memory.
Instance does not failover successfully to Server1.
You need to resolve the issue.
What should you do?
- A. Minimum server memory server memory option for Instances 1 to 16384
- B. Set the value of the Maximum server memory option for Instance2 to 32760.
- C. Set the value of the Minimum server memory option for instance 2 to 0.
- D. Set the value of the Maximum server memory option for Instance to 24576.
You are creating a database that will store usernames and credit card numbers for an application. You need to recommend a solution to store and reuse the credit card numbers in the database.
What should you recommend? More than one answer choice may achieve the goal. Select the BEST answer.
- A. Transparent Data Encryption (TDE)
- B. Data hashing
- C. Data encryption
- D. Encrypting File System (EFS)
Explanation: Only visible for ActualPDF members. You can sign-up / login (it's free).
You deploy a SQL Server instance named SQLProd that uses SQL Server 2014.
You need to recommend a solution to monitor the transactions that are running currently against SQLProd.
The solution must minimize the amount of custom code required.
What should you recommend?
- A. A trigger
- B. A dynamic management view
- C. User-defined views
- D. Statistics
Explanation: Only visible for ActualPDF members. You can sign-up / login (it's free).
Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.
You are a database administrator for a company that has an on-premises Microsoft SQL Server environment and Microsoft Azure SQL Database instances. The environment hosts several customer databases, and each customer uses a dedicated instance. The environments that you manage are shown in the following table.
You need to implement a process for importing data into WingDB.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Explanation
Step 1: Perform a full backup of the database and enable the bulk-logged recovery model.
Not: Simple recovery model.
With the Simple recovery model we cannot minimize data loss.
Step 2: Import the data
Step 3: Backup the tail of the transaction log.
For databases that use full and bulk-logged recovery, database backups are necessary but not sufficient.
Transaction log backups are also required.
Note: Three recovery models exist: simple, full, and bulk-logged. Typically, a database uses the full recovery model or simple recovery model. A database can be switched to another recovery model at any time.
References:
https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/recovery-models-sql-server
You are designing a Windows Azure SQL Database for an order fulfillment system. You create a table named Sales.Orders with the following script.
Each order is tracked by using one of the following statuses:
* Fulfilled
* Shipped
* Ordered
* Received
You need to design the database to ensure that that you can retrieve the following information:
* The current status of an order
* The previous status of an order.
* The date when the status changed.
* The solution must minimize storage.
More than one answer choice may achieve the goal. Select the BEST answer.
- A. Create a new table named Sales.OrderStatus that contains three columns named OrderID, StatusDate, and Status. Insert new rows into the table as the order status changes.
- B. To the Sales.Orders table, add three columns named Status, PreviousStatus and ChangeDate. Update rows as the order status changes.
- C. Implement change data capture on the Sales.Orders table.
- D. To the Sales.Orders table, add three columns named FulfilledDate, ShippedDate, and ReceivedDate.
Update the value of each column from null to the appropriate date as the order status changes.
