70-764 Questions and Answers

  Printable PDF

Administering a SQL Database Infrastructure: 70-764

Rating: 5.0

Vendor: Microsoft

Certifications: MCSA

Exam Name: Administering a SQL Database Infrastructure

Exam Code: 70-764

Total Questions: 452 Q&As

Last Updated: Feb 03, 2022

Exam retired

PDF Only: $45.99 VCE Only: $49.99 VCE + PDF: $59.99

Microsoft 70-764 PDF&VCE Dumps Download

  • 99.5% Pass Rate
  • 365 Days Free Update
  • Verified By Professional IT Experts
  • 24/7 Live Support
  • 378,380+ Satisfied Customers
  • 3 Days Preparation Before Test
  • 18 Years Experience
  • 6000+ IT Exam Dumps
  • 100% Safe Shopping Experience

Microsoft 70-764 Last Month Results

Successful Stories of Microsoft 70-764 Exam
High Score Rate in Actual Microsoft Exams
Same Questions from the Latest Real Exam

70-764 Online Practice Questions and Answers

Questions 1

You work as a Database Administrator (DBA) at ABC.com.

You are in the process of deploying new servers running SQL Server 2012.

You need to deploy a SQL Server 2012 server to host databases used to host databases used by Research and Development department.

The databases used by the Research and Development department will store sensitive data.

A company security policy states that if Research and Development department database files are moved to another server, the files must be encrypted.

Which of the following solutions would meet the encryption requirement?

A. Encrypting File System (EFS).

B. Transparent Data Encryption (TDE).

C. Windows Bitlocker Drive Encryption.

D. Secure Sockets Layer (SSL)

Show Answer
Questions 2

You have a server named Server1 that has 16 processors.

You plan to deploy multiple instances of SQL Server 2014 to Server1.

You need to recommend a method to allocate processors to each instance.

What should you include in the recommendation? More than one answer choice may achieve the goal. Select the BEST answer.

A. Processor affinity

B. Windows System Resource Manager (WSRM)

C. Max Degree of Parallelism

D. Resource Governor

Show Answer
Questions 3

You administer a single server that contains a Microsoft SQL Server 2016 default instance on which several production databases have been deployed.

You plan to install a new ticketing application that requires the deployment of a database on the server.

The SQL login for this application requires sysadmin permissions. You need to ensure that the login for the ticketing application cannot access other production databases.

What should you do?

A. Use the SQL Server default instance and enable Contained Databases.

B. Use the SQL Server default instance and configure a user-defined server role. Add the login for the ticketing application to this role.

C. Install a new named SQL Server instance on the server.

D. Install a new default SQL Server instance on the server.

Show Answer More Questions

Success Stories


  • Australia
  • Sep 27, 2022
  • Rating: 4.2 / 5.0

Not take the exam yet. But I feel more and more confident with my exam by using this dump. Now I am writing my exam on coming Saturday. I believe I will pass.


  • India
  • Sep 22, 2022
  • Rating: 4.2 / 5.0

I pass the exam. All questions 100% valid but I think for some answer in the exam are changed. You need to be aware of that. Many thanks.


  • Egypt
  • Sep 21, 2022
  • Rating: 5.0 / 5.0

Just completed my exam. Except for one simple, this is a dump of the exam. Good Luck!

Download Free Microsoft 70-764 Demo

Experience Certbus exam material in PDF version.
Simply submit your e-mail address below to get started with our PDF real exam demo of your Microsoft 70-764 exam.

Instant download
Latest update demo according to real exam

*Email Address

* Our demo shows only a few questions from your selected exam for evaluating purposes