This exam may be available in your country for online proctored delivery. Learn more.
Convince your bossConnect with us on @MSLearning
* Pricing does not reflect any promotional offers or reduced pricing for Microsoft Imagine Academy program members, Microsoft Certified Trainers, and Microsoft Partner Network program members. Pricing is subject to change without notice. Pricing does not include applicable taxes. Please confirm exact pricing with the exam provider before registering to take an exam.
This exam measures your ability to accomplish the technical tasks listed below. The percentages indicate the relative weight of each major topic area on the exam. The higher the percentage, the more questions you are likely to see on that content area on the exam. View video tutorials about the variety of question types on Microsoft exams.
Please note that the questions may test on, but will not be limited to, the topics described in the bulleted text.
Do you have feedback about the relevance of the skills measured on this exam? Please send Microsoft your comments. All feedback will be reviewed and incorporated as appropriate while still maintaining the validity and reliability of the certification process. Note that Microsoft will not respond directly to your feedback. We appreciate your input in ensuring the quality of the Microsoft Certification program.
If you have concerns about specific questions on this exam, please submit an exam challenge.
If you have other questions or feedback about Microsoft Certification exams or about the certification program, registration, or promotions, please contact your Regional Service Center.
Implement SQL in Azure (30–35%)
Deploy a Microsoft Azure SQL Database
Choose a service tier, create servers and databases, create a sysadmin account, configure elastic pools
Plan for SQL Server installation
Plan for an IaaS or on-premises deployment, select the appropriate size for a virtual machine, plan storage pools based on performance requirements, evaluate best practices for installation, design a storage layout for a SQL Server virtual machine
Deploy SQL Server instances
Deploy a SQL Server instance in IaaS and on-premises, manually install SQL Server on an Azure Virtual Machine, provision an Azure Virtual Machine to host a SQL Server instance, automate the deployment of SQL Server databases, deploy SQL Server by using templates
Manage databases and instances (35–40%)
Configure secure access to Microsoft Azure SQL Databases
Configure firewall rules, configure Always Encrypted for Azure SQL Database, configure cell-level encryption, configure dynamic data masking, configure transparent data encryption (TDE)
Configure SQL Server performance settings
Configure database performance settings, configure max server memory, configure the database scope, configure operators and alerts
Manage SQL Server instances
Create databases, manage files and file groups, manage system database files, configure tempdb
Deploy and migrate applications (30–35%)
Deploy applications to Microsoft Azure SQL Database
Manage deployments that support multiple tenants, migrate on-premises SQL Server to Azure SQL Database, migrate data to Azure SQL Database
Deploy applications to SQL Server on Azure Virtual Machines
Migrate an on-premises SQL Server database to an Azure Virtual Machine, generate benchmark data for performance needs, perform performance tuning on Azure IaaS, support availability sets in Azure
Migrate client applications
Configure application connection strings, manage traffic between on-premises applications and Azure services, develop application retry connection logic, identify application patterns that must be migrated with SQL Server data, evaluate network performance between applications and databases
Take a Microsoft Official Practice Test for exam 765
From the community
Who should take this exam?
This exam is intended for architects, senior developers, infrastructure specialists, and development leads. Candidates have a working knowledge of the various cloud service models and service model architectures, data storage options, and data synchronization techniques. Candidates also have a working knowledge of deployment models, upgrading and migrating databases, and applications and services, in addition to integrating Azure applications with external resources.
More information about exams
Preparing for an exam
We recommend that you review this exam preparation guide in its entirety and familiarize yourself with the resources on this website before you schedule your exam. See the Microsoft Certification exam overview for information about registration, videos of typical exam question formats, and other preparation resources. For information on exam policies and scoring, see the Microsoft Certification exam policies and FAQs.
This preparation guide is subject to change at any time without prior notice and at the sole discretion of Microsoft. Microsoft exams might include adaptive testing technology and simulation items. Microsoft does not identify the format in which exams are presented. Please use this preparation guide to prepare for the exam, regardless of its format. To help you prepare for this exam, Microsoft recommends that you have hands-on experience with the product and that you use the specified training resources. These training resources do not necessarily cover all of the topics listed in the "Skills measured" section.
NO.1 You administer a Microsoft SQL Server 2014 database named Contoso on a server named
You need to collect data for a long period of time to troubleshoot wait statistics when querying
Contoso. You also need to ensure minimum impact to the server.
What should you create?
A. A SQL Profiler Trace
B. A Resource Pool
C. An Alert
D. A Policy
E. A Server Audit Specification
F. A Database Audit Specification
G. A Data Collector Set
H. An Extended Event session
SQL Server Extended Events has a highly scalable and highly configurable architecture that allows
users to collect as much or as little information as is necessary to troubleshoot or identify a
Extended Events is a light weight performance monitoring system that uses very few performance
A SQL Server Extended Events session is created in the SQL Server process hosting the
Extended Events engine.
NO.2 You administer a Microsoft SQL Server 2014 database.
You have a SQL Server Agent job instance that runs using the service account. You have a job step
within the job that requires elevated privileges.
You need to ensure that the job step can run using a different user account.
What should you use?
A. an operator
B. an alert
C. a schedule
D. a proxy
070-765 絶対 070-765 会場
A SQL Server Agent proxy defines the security context for a job step. A proxy provides
SQL Server Agent with access to the security credentials for a Microsoft Windows user.
Each proxy can be associated with one or more subsystems. A job step that uses the proxy can access
the specified subsystems by using the security context of the Windows user.
Before SQL Server Agent runs a job step that uses a proxy, SQL Server Agent impersonates the
credentials defined in the proxy, and then runs the job step by using that security context.
NO.3 You administer a Microsoft SQL Server 2014 instance.
You need to configure a new database to support FILETABLES.
What should you do? Choose all that apply.
A. Set the FILESTREAM directory name on the Database.
B. Enable Contained Databases on the Server Instance.
C. Enable FILESTREAM on the Server Instance.
D. Configure the Database for Partial Containment.
E. Create a non-empty FILESTREAM file group.
F. Disable FILESTREAM on the Database.
B: FileTables extend the capabilities of the FILESTREAM feature of SQL Server. Therefore you have to
enable FILESTREAM for file I/O access at the Windows level and on the instance of SQL Server before
you can create and use FileTables.
D: Before you can create FileTables in a database, the database must have a
F: Specifying a Directory for FileTables at the Database Level
When you enable non-transactional access to files at the database level, you can optionally provide a
directory name at the same time by using the DIRECTORY_NAME option. If you do not provide a
directory name when you enable non-transactional access, then you have to provide it later before
you can create FileTables in the database.
NO.4 You administer a Microsoft SQL Server 2014 database named Contoso on a server named
You need to be notified immediately when fatal errors occur on Server01.
What should you create?
A. A Server Audit Specification
B. A Database Audit Specification
C. An Alert
D. A Resource Pool
E. An Extended Event session
F. A SQL Profiler Trace
G. A Policy
SQL Server has alerts that get more important based on the severity of the alert.
Anything of severity 16 or below tends to refer to the database and deals with issues that are tied to
syntax errors, violations of foreign keys, etc.
While those errors are typically important, they don't refer to anything with regards to overall health
of the SQL Server. Alerts 17 through 25 do.
Those are the ones your health checks are probably firing on.
我々社のMicrosoft 070-765 模擬問題集認定試験問題集の合格率は高いのでほとんどの受験生は070-765 模擬問題集認定試験に合格するのを保証します。もしあなたはMicrosoft 070-765 模擬問題集試験問題集に十分な注意を払って、070-765 模擬問題集試験の解答を覚えていれば、070-765 模擬問題集認定試験の成功は明らかになりました。Microsoft 070-765 模擬問題集模擬問題集で実際の質問と正確の解答に疑問があれば、無料の練習問題集サンプルをダウンロードし、チェックしてください。
試験科目：「Provisioning SQL Databases」
問題と解答：全105問 070-765 資格認定