[Make Sure Real] Share free Microsoft 70-764 exam questions and latest Microsoft 70-764 dumps from Pass4itsure

To pass the Microsoft 70-764 exam, you may need the following suggestions: 70-764 dumps pdf! Microsoft 70-764 is a complex certification exam, but you will be able to succeed shortly after you get the answers to Microsoft 70-764 dumps pdf questions. Pass4itsure has updated Microsoft 70-764 dumps questions! Download the complete 70-764 dumps pdf (Q&As: 452).

[Latest PDF] Free Microsoft 70-764 dumps pdf download from Google Drive:  https://drive.google.com/file/d/1U8Z2BEJArmw0ZggjsvtF5llMmI2PA6Ip/view?usp=sharing

Practice with Authentic Microsoft 70-764 Questions Answers

Pass4itsure is the industry leader! The most complete exam questions and answers! The safest buying experience! The greatest free sharing of exam practice questions and answers!

why-choose-pass4itsure

Microsoft 70-764 practice testing questions from Youtube

https://youtu.be/1gKs3DdX3Hc

Share Microsoft MCSA 70-764 exam questions for free

QUESTION 1
You are troubleshooting an application that runs a query. The application frequently causes deadlocks. You need to
identify which transaction causes the deadlock. What should you do? More than one answer choice may achieve the
goal. Select the BEST answer.
A. Query the sys.dm_exec_requests dynamic management view.
B. Create a trace in SQL Server Profiler that contains the Deadlock graph event.
C. Query the sys.dm_exec_sessions dynamic management view.
D. Create an extended events session to capture deadlock information.
Correct Answer: D
Troubleshooting deadlocks
You have been receiving reports from users indicating that certain applications are returning deadlock errors. To
maximize the effectiveness of troubleshooting these problems, you decide to focus on the deadlocks that are hit most
frequently.
You create an Extended Events session that:
Configures deadlock event tracking for the session.
Specifies a target that aggregates based on an identifier for the deadlock.
You run the Extended Events session, and after additional deadlocks are reported you are able to obtain aggregated
deadlock information, along with the complete XML deadlock graph for each source. Using this information, you are able
to
pin point the most common deadlocks and start working on a solution.


QUESTION 2
You have a Microsoft SQL Server database named DB1. Nested and recursive triggers for DB1 are disabled. There is
an existing DDL trigger named TableAudit in the database. The trigger captures the name of each table as the table is
created.
You define a policy for the database by using SQL Server policy-based management. The policy requires that all table
names use the prefix tbl. You set the evaluation mode for the policy to On change: prevent.
You observe that developers are able new tables that do not include the required prefix in the table name.
You need to ensure the policy is enforced.
What should you do?
A. Enable recursive triggers
B. Change the policy evaluation mode to On Schedule
C. Disable the TableAudit trigger
D. Enable nested triggers
Correct Answer: D
If the nested triggers server configuration option is disabled, On change: prevent will not work correctly. Policy-Based
Management relies on DDL triggers to detect and roll back DDL operations that do not comply with policies that use this
evaluation mode. Removing the Policy-Based Management DDL triggers or disabling nest triggers, will cause this
evaluation mode to fail or perform unexpectedly.
References: https://docs.microsoft.com/en-us/sql/relational-databases/policy-based-management/administer-servers-byusing-policy-based-management

QUESTION 3
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains
a unique solution that might meet the stated goals. Some question sets might have more than one correct solution,
while
others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not
appear in the review screen.
Your company is developing a new business intelligence application that will access data in a Microsoft Azure SQL
Database instance. All objects in the instance have the same owner.
A new security principal named BI_User requires permission to run stored procedures in the database. The stored
procedures read from and write to tables in the database. None of the stored procedures perform IDENTIFY_INSERT
operations or dynamic SQL commands.
The scope of permissions and authentication of BI_User should be limited to the database. When granting permissions,
you should use the principle of least privilege.
You need to create the required security principals and grant the appropriate permissions.
Solution: You run the following Transact-SQL statement:

70-764 exam questions-q3

Does the solution meet the goal?
A. Yes
B. No
Correct Answer: B
A login would also be needed.
Note:
One method of creating multiple lines of defense around your database is to implement all data access using stored
procedures or user-defined functions. You revoke or deny all permissions to underlying objects, such as tables, and
grant
EXECUTE permissions on stored procedures. This effectively creates a security perimeter around your data and
database objects.
Best Practices
Simply writing stored procedures isn\\’t enough to adequately secure your application. You should also consider the
following potential security holes.
Grant EXECUTE permissions on the stored procedures for database roles you want to be able to access the data.
Revoke or deny all permissions to the underlying tables for all roles and users in the database, including the public role.
All users inherit permissions from public. Therefore denying permissions to public means that only owners and
sysadmin
members have access; all other users will be unable to inherit permissions from membership in other roles.
Do not add users or roles to the sysadmin or db_owner roles. System administrators and database owners can access
all database objects.
References: https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/sql/managing-permissions-with-storedprocedures-in-sql-server

QUESTION 4
General Overview
You are the Senior Database Administrator (DBA) for a manufacturing company named Fairstone Manufacturing.
Fairstone Manufacturing is based in the New York area. The company has two offices: a main office in the city and a
branch office just outside the city. The company has four factories where their products are manufactured. Two factories
are
in the New York area and the other two factories are in Washington.
Network Connectivity
The two offices are connected by a 10 Mbps dedicated WAN link.
SQL Server Environment
The main office has four SQL Server 2012 Standard Edition servers named MainDB1, MainDB2, MainDB3 and
MainDB4. The branch office has two SQL Server 2012 Standard Edition servers named BranchDB1 and BranchDB2.
The main
office has a Development department. All databases used by the Development department are hosted on MainDB3 and
MainDB4. MainDB1 and MainDB2 host the following databases:
Products
Manufacturing
Sales
HR
Customers
DailyReportsTemp
BranchDB1 and BranchDB2 host the same databases as MainDB1 and MainDB2. The DailyReportsTemp database is a
temporary database that is recreated every day and used for reporting purposes. One of the tables in the Customer
database lists all the customers. Another table linked to the customers table contains a list of classifications for the
customers. The classifications are Hot, Warm and Cold based on the number of orders placed by the customers in the
last
year. The customers are classified according to the following criteria:
Hot – Over 100 orders placed in a year.
Warm – Between 50 and 100 orders placed in a year.
Cold – Under 50 orders placed in a year.
Stored Procedures
Three tables in the Manufacturing database are modified by a stored procedure named ManProc1.
A segment of code from ManProc1 is as follows:

70-764 exam questions-q4

 The same three tables are also modified by a stored procedure named ManProc2. A segment of code from ManProc2 is
as follows:

70-764 exam questions-q4-2

A product list in the Products database is updated using information from tables in the Manufacturing database by a
stored procedure named ProductUpdateProc. Locks on tables in the Manufacturing database often cause
ProductUpdateProc to take a long time to complete.
A list of manufacturing processes required to create each product is stored in tables in the Manufacturing database and
updated by a stored procedure named ProcessUpdateProc. The ProcessUpdateProc stored procedure contains
several
UPDATE statements. The UPDATE statements are configured to be called in a specific order. The ProcessUpdateProc
stored procedure continues to run in the event of a failure of one of the UPDATE statements.
This can cause inaccurate results in the manufacturing process list.
Sales Director Statement
The Sales Director has made the following observations about the current database design:
The current customer classification system needs to be changed.
Currently the customers are classified by the number of orders placed in the last year.
This information is an unreliable guide as it does not take in to account the size of the orders.
I would suggest a trial run of a classification system based on the revenue generated by the orders placed in the last
year.
We may add more than the current three classification types in future.
We should have a method of recording changes to the classifications.
IT Manager Statement
The IT Manager has listed the following requirements for the SQL Server and database environment:
We need to provide a group of users from the IT and Manufacturing departments the minimum administrative rights to
view database information and server state for the Manufacturing database on MainDB1.
The Sales database takes too long to back up due to the large amount of historical sales order data in the database. We
need to reduce the backup time for this database.
The DailyReportsTemp database takes four hours to back up. We need to be able to recover the DailyReportsTemp
database in less than one hour if the database storage hardware fails.
We need to be able to immediately return the Manufacturing database to its previous state if the ProcessUpdateProc
stored procedure fails to update the process information correctly.
I also want the ProcessUpdateProc stored procedure to stop running in the event of a failure of one of the UPDATE
statements.
IT Administrators need to be able to monitor the disk space used on the SQL Servers by running real-time reports on
the disk usage.
The Developers would like to install second instances of SQL Server on MainDB3 and MainDB4.
They would like to assign each instance to specific processors on the SQL Servers.
You need to enable the Developers to assign SQL Server instances on MainDB3 and MainDB4 to specific processors
on the servers. What should you configure?
A. Windows System Resource Manager (WSRM)
B. Resource Governor
C. A Maintenance Plan
D. Processor Affinity
Correct Answer: D

QUESTION 5
You have a Microsoft SQL Server instance that has a database named DB1. The database is used for reporting
purposes. You plan to capture all queries for a specific table and save the data as a text file.
You need to ensure that queries are captured and that a failure to capture a query will shut down the SQL Server
instance.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
A. Enable SQL Server Audit.
B. Use Extended Events.
C. Use a logon trigger.
D. Create a SQL Server Profiler trace and disable c2 audit tracing.
E. Enable SQL Server Query Store.
Correct Answer: AD
The general process for creating and using an audit is as follows.
Create an audit and define the target.
Create either a server audit specification or database audit specification that maps to the audit. Enable the audit
specification.
Enable the audit.
Read the audit events by using the Windows Event Viewer, Log File Viewer, or the fn_get_audit_file function.
References: https://docs.microsoft.com/en-us/sql/relational-databases/security/auditing/sql-server-audit-databaseengine

QUESTION 6
You are the administrator for a SQL Server 2014 instance that stores the data for an online transaction processing sales system.
The company takes full backups every week; differential backups on the days with no full backups; and hourly
transaction backups.
These backups are stored on a backup server in the company\\’s data center. Every week, the company places the full
backup on a tape and sends it to a third-party backup storage system. The company is worried that a disaster might
occur
that could destroy their computer center and cause them to lose orders.
You need to determine the best method for providing the smallest amount of data loss and downtime without leasing or
purchasing additional physical locations.
What should you do? More than one answer choice may achieve the goal. Select the BEST answer.
A. Set up SQL Server Always On with a SQL Azure database as a replica.
B. Set up SQL Server Always On by using a SQL Server on a Windows Azure Virtual Machine.
C. Put the differential backup on tape and send it to the third-party backup storage system.
D. Use the Microsoft SQL Server Backup to Microsoft Windows Azure Tool to direct all backups to a different
geographical location.
Correct Answer: D
SQL Server 2012 was the first version to provide the ability to back up databases to the Cloud, and SQL Server 2014
improves on the process. Microsoft SQL Server Backup to Windows Azure Tool enables backup to Windows Azure Blob
Storage and encrypts and compresses SQL Server backups stored locally or in the cloud.

QUESTION 7
General Overview
You are the Senior Database Administrator (DBA) for a software development company named Leafield Solutions. The
company develops software applications custom designed to meet customer requirements.
Requirements Leafield Solutions has been asked by a customer to develop a web-based Enterprise Resource Planning
and Management application. The new application will eventually replace a desktop application that the customer is
currently using. The current application will remain in use while the users are trained to use the new webbased
application.
You need to design the SQL Server and database infrastructure for the web-based application.
Databases
You plan to implement databases named Customers, Sales, Products, Current_Inventory, and TempReporting.
The Sales database contains a table named OrderTotals and a table named SalesInfo.
A stored procedure named SPUpdateSalesInfo reads data in the OrderTotals table and modifies data in the SalesInfo
table.
The stored procedure then reads data in the OrderTotals table a second time and makes further changes to the
information in the SalesInfo table. The Current_Inventory database contains a large table named Inv_Current. The
Inv_Current
table has a clustered index for the primary key and a nonclustered index. The primary key column uses the identity
property. The data in the Inv_Current table is over 120GB in size. The tables in the Current_Inventory database are
accessed
by multiple queries in the Sales database. Another table in the Current_Inventory database contains a self-join with an
unlimited number of hierarchies. This table is modified by a stored procedure named SPUpdate2. An external
application
named ExternalApp1 will periodically query the Current_Inventory database to generate statistical information. The
TempReporting database contains a single table named GenInfo. A stored procedure named SPUPdateGenInfo
combines
data from multiple databases and generates millions of rows of data in the GenInfo table.
The GenInfo table is used for reports.
When the information in GenInfo is generated, a reporting process reads data from the Inv_Current table and queries
information in the GenInfo table based on that data. The GenInfo table is deleted after the reporting process completes.
The
Products database contains tables named ProductNames and ProductTypes.
Current System
The current desktop application uses data stored in a SQL Server 2005 database named DesABCopAppDB. This
database will remain online and data from the Current_Inventory database will be copied to it as soon as data is
changed in the
Current_Inventory database.
SQL Servers
A new SQL Server 2012 instance will be deployed to host the databases for the new system. The databases will be
hosted on a Storage Area Network (SAN) that provides highly available storage.
Design Requirements
Your SQL Server infrastructure and database design must meet the following requirements:
Confidential information in the Current_ Inventory database that is accessed by ExternalApp1 must be securely stored.
Direct access to database tables by developers or applications must be denied.
The account used to generate reports must have restrictions on the hours when it is allowed to make a connection.
Deadlocks must be analyzed with the use of Deadlock Graphs.
In the event of a SQL Server failure, the databases must remain available.
Software licensing and database storage costs must be minimized.
Development effort must be minimized. The Tempdb databases must be monitored for insufficient free space.
Failed authentication requests must be logged.
Every time a new row is added to the ProductTypes table in the Products database, a user defined function that
validates the row must be called before the row is added to the table.
When SPUpdateSalesInfo queries data in the OrderTotals table the first time, the same rows must be returned along
with any newly added rows when SPUpdateSalesInfo queries data in the OrderTotals table the second time.
You need to configure a synchronization solution to copy data from the Current_Inventory database the
DesABCopAppDB database.
What should you configure?
A. Transactional Replication.
B. Database Mirroring.
C. Snapshot Replication.
D. Incremental Backups
Correct Answer: A
 

QUESTION 8
Background
Corporate Information
Fabrikam, Inc. is a retailer that sells electronics products on the Internet. The company has a headquarters site and one
satellite sales office. You have been hired as the database administrator, and the company wants you to change the
architecture of the Fabrikam ecommerce site to optimize performance and reduce downtime while keeping capital
expenditures to a minimum. To help with the solution, Fabrikam has decided to use cloud resources as well as onpremise
servers.
Physical Locations
All of the corporate executives, product managers, and support staff are stationed at the headquarters office. Half of the
sales force works at this location. There is also a satellite sales office. The other half of the sales force works at the
satellite office in order to have sales people closer to clients in that area. Only sales people work at the satellite
location.
Problem Statement
To be successful, Fabrikam needs a website that is fast and has a high degree of system uptime. The current system
operates on a single server and the company is not happy with the single point of failure this presents. The current
nightly
backups have been failing due to insufficient space on the available drives and manual drive cleanup often needing to
happen to get past the errors. Additional space will not be made available for backups on the HQ or satellite servers.
During your investigation, you discover that the sales force reports are causing significant contention.
Configuration
Windows Logins
The network administrators have set up Windows groups to make it easier to manage security. Users may belong to
more than one group depending on their role. The groups have been set up as shown in the following table:

70-764 exam questions-q8

Database
Currently all information is stored in a single database called ProdDB, created with the following script:

70-764 exam questions-q8-2

The Product table is in the Production schema owned by the ProductionStaff Windows group. It is the main table in the
system so access to information in the Product table should be as fast as possible. The columns in the Product table are
defined as shown in the following table:

70-764 exam questions-q8-3

Database Issues
The current database does not perform well. Additionally, a recent disk problem caused the system to go down,
resulting in lost sales revenue. In reviewing the current system, you found that there are no automated maintenance
procedures.
The database is severely fragmented, and everyone has read and write access.
Requirements
Database
The database should be configured to maximize uptime and to ensure that very little data is lost in the event of a server
failure. To help with performance, the database needs to be modified so that it can support in-memory data, specifically
for the Product table, which the CIO has indicated should be a memoryoptimized table. The auto-update statistics option
is set off on this database. Only product managers are allowed to add products or to make changes to the name,
description, price, cost, and supplier. The changes are made in an internal database and pushed to the Product table in
ProdDB during system maintenance time. Product managers and others working at the headquarters location also
should
be able to generate reports that include supplier and cost information.
Customer data access
Customers access the company\\’s website to order products, so they must be able to read product information such
asname, description, and price from the Product table. When customers place orders, stored procedures calledby the
website
update product quantityon-hand values. This means the product table is constantly updated at randomtimes.
Customer support data access
Customer support representatives need to be able to view and not update or change product information. Management
does not want the customer support representatives to be able to see the product cost or any supplier information.
Sales force data access
Sales people at both the headquarters office and the satellite office must generate reports that read from the Product
and SalesOrderDetail tables. No updates or inserts are ever made by sales people. These reports are run at random
times
and there can be no reporting downtime to refresh the data set except during the monthly maintenance window. The
reports that run from the satellite office are process intensive queries with large data sets. Regardless of which office
runs a
sales force report, the SalesOrderDetail table should only return valid, committed order data; any orders not yet
committed should be ignored.
Historical Data
The system should keep historical information about customers who access the site so that sales people can see how
frequently customers log in and how long they stay on the site.
The information should be stored in a table called Customer Access. Supporting this requirement should have minimal
impact on production website performance.
Backups
The recovery strategy for Fabrikam needs to include the ability to do point in time restores and minimize the risk of data
loss by performing transaction log backups every 15 minutes.
Database Maintenance
The company has defined a maintenance window every month when the server can be unavailable. Any maintenance
functions that require exclusive access should be accomplished during that window.
Project milestones completed
Revoked all existing read and write access to the database, leaving the schema ownership in place.
Configured an Azure storage container secured with the storage account name MyStorageAccount with the primary
access key StorageAccountKey on the cloud file server.
SQL Server 2014 has been configured on the satellite server and is ready for use.
On each database server, the fast storage has been assigned to drive letter F:, and the slow storage has been assigned
to drive letter D:.
You need to write code that will allow the sales force to retrieve data for their reports with the least amount of effort.
Which code should you use?
 

70-764 exam questions-q8-4

A. Option A
B. Option B
C. Option C
D. Option D
Correct Answer: A
-Scenario:
-During your investigation, you discover that the sales force reports are causing significant contention.
– Sales force data access Sales people at both the headquarters office and the satellite office must generate reports that
read from the Product and SalesOrderDetail tables. No updates or inserts are ever made by sales people. These
reports are run at random times and there can be no reporting downtime to refresh the data set except during the
monthly maintenance window. The reports that run from the satellite office are process intensive queries with large data
sets. Regardless of which office runs a sales force report, the SalesOrderDetail table should only return valid, committed
order data; any orders not yet committed should be ignored.

QUESTION 9
You manage a database that uses the FULL recovery model and has a 60-minute recovery point objective (RPO). Full
database backups are performed at 23:00 Monday through Friday.
Each full database backup takes 6 hours to complete. Approximately 5% of the data changes each weekday.
Backups must be performed as often as possible to reduce the number of files needed either a full recovery to any given
time. You must minimize the duration of the backup tasks that are performed between 04:00 and 23:00.
You need to reconfigure backups.
Which time slot or schedule should you use for each backup type?
Hot Area:

70-764 exam questions-q9

Correct Answer:

70-764 exam questions-q9-2

QUESTION 10
You administer a Microsoft SQL Server 2016 instance that has multiple databases.
You have a two-node SQL Server failover cluster.
The cluster uses a storage area network (SAN). You discover I/O issues. The SAN is at capacity and additional disks
cannot be added.
You need to reduce the I/O workload on the SAN at a minimal cost.
What should you do?
A. Move user databases to a local disk.
B. Expand the tempdb data and log files.
C. Modify application code to use table variables.
D. Move the tempdb files to a local disk.
Correct Answer: D
You can configure TempDB on a local disk when you, for example, installing your SQL Server cluster. References:
https://www.mssqltips.com/sqlservertip/2817/sql-server-2012-cluster-with-tempdb-on-local-disk/


QUESTION 11
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains
a unique solution that might meet the stated goals. Some question sets might have more than one correct solution,
while others might not have a correct solution.
After you answer a question in this sections, you will NOT be able to return to it. As a result, these questions will not
appear in the review screen.
You have a server named Server1 that has Microsoft SQL Server installed.
Server1 has SQL Server Audit configured to send audit event records to a file.
You need to ensure that a database user named User1 can review the audit data.
Solution: You grant the VIEW SERVER STATE permission to User1.
Does this meet the goal?
A. Yes
B. No
Correct Answer: A
Each feature and command for SQL Server Audit has individual permission requirements.
Unless otherwise specified, viewing catalog views requires a principal to have one of the following:
The VIEW SERVER STATE permission.
The VIEW AUDIT STATE permission (gives only the principal access to the sys.server_audits catalog view).
Membership in the sysadmin fixed server role.
The CONTROL SERVER permission.
The ALTER ANY AUDIT permission.
A principal must have the VIEW SERVER STATE or ALTER ANY AUDIT permission to use the Dynamic Management
Views.
References: https://technet.microsoft.com/en-us/library/cc280665(v=sql.105).aspx

QUESTION 12
Overview General Overview ADatum Corporation has offices in Miami and Montreal.
The network contains a single Active Directory forest named adatum.com. The offices connect to each other by using a
WAN link that has 5-ms latency. A. Datum standardizes its database platform by using SQL Server 2014 Enterprise
edition.
Databases
Each office contains databases named Sales, Inventory, Customers, Products, Personnel, and Dev.
Servers and databases are managed by a team of database administrators. Currently, all of the database administrators
have the same level of permissions on all of the servers and all of the databases.
The Customers database contains two tables named Customers and Classifications.
The following graphic shows the relevant portions of the tables:

70-764 exam questions-q12

The Inventory database is updated frequently.
The database is often used for reporting.
A full backup of the database currently takes three hours to complete.
Stored Procedures
A stored procedure named USP_1 generates millions of rows of data for multiple reports. USP_1 combines data from
five different tables from the Sales and Customers databases in a table named Table1. After Table1 is created, the
reporting process reads data from Table1 sequentially several times. After the process is complete, Table1 is deleted. A
stored procedure named USP_2 is used to generate a product list. The product list contains the names of products
grouped by category. USP_2 takes several minutes to run due to locks on the tables the procedure accesses. The locks
are caused by USP_1 and USP_3. A stored procedure named USP_3 is used to update prices. USP_3 is composed of
several UPDATE statements called in sequence from within a transaction. Currently, if one of the UPDATE statements
fails, the stored procedure fails. A stored procedure named USP_4 calls stored procedures in the Sales, Customers,
and
Inventory databases.
The nested stored procedures read tables from the Sales, Customers, and Inventory databases. USP_4 uses an
EXECUTE AS clause.
All nested stored procedures handle errors by using structured exception handling. A stored procedure named USP_5
calls several stored procedures in the same database. Security checks are performed each time USP_5 calls a stored
procedure.
You suspect that the security checks are slowing down the performance of USP_5. All stored procedures accessed by
user applications call nested stored procedures.
The nested stored procedures are never called directly.
Design Requirements
Data Recovery
You must be able to recover data from the Inventory database if a storage failure occurs. You have a Recovery Time
Objective (RTO) of 5 minutes.
You must be able to recover data from the Dev database if data is lost accidentally. You have a Recovery Point
Objective (RPO) of one day.
Classification Changes
You plan to change the way customers are classified. The new classifications will have four levels based on the number
of orders. Classifications may be removed or added in the future. Management requests that historical data be
maintained for the previous classifications. Security A group of junior database administrators must be able to manage
security for the Sales database. The junior database administrators will not have any other administrative rights. A.
Datum
wants to track which users run each stored procedure.
Storage
ADatum has limited storage. Whenever possible, all storage space should be minimized for all databases and all
backups.
Error Handling
There is currently no error handling code in any stored procedure.
You plan to log errors in called stored procedures and nested stored procedures. Nested stored procedures are never
called directly.
You need to recommend a solution to minimize the amount of time it takes to execute USP_1. With what should you
recommend replacing Table1?
A. A view
B. A temporary table
C. A table variable
D. A function
Correct Answer: A
– A stored procedure named USP_1 generates millions of rows of data for multiple reports. USP_1 combines data from
five different tables from the Sales and Customers databases in a table named Table1.


QUESTION 13
You are planning the deployment of two new Always On Failover Cluster Instances (FCIs) of Microsoft SQL Server to a
single Windows Server Cluster with three nodes. The planned configuration for the cluster is shown in the Server Layout
exhibit. (Click the Exhibit button.)

70-764 exam questions-q13

The SAN team has configured storage for the cluster and sent the configuration to you in the email shown in the SAN
Team Email exhibit. (Click the Exhibit button.)

70-764 exam questions-q13-2

Correct Answer:

70-764 exam questions-q13-3

Box 1: Yes
tempdb on local storage. FCIs now support placement of tempdb on local non-shared storage, such as a local solidstate-drive, potentially offloading a significant amount of I/O from a shared SAN.
Prior to SQL Server 2012, FCIs required tempdb to be located on a symmetrical shared storage volume that failed over
with other system databases.
Box 2: No
The VNN is set on the group level, not on the instance level.
Database client applications can connect directly to a SQL Server instance network name, or they may connect to a
virtual network name (VNN) that is bound to an availability group listener. The VNN abstracts the WSFC cluster and
availability group topology, logically redirecting connection requests to the appropriate SQL Server instance and
database replica.
The logical topology of a representative AlwaysOn solution is illustrated in this diagram:

70-764 exam questions-q13-4

Box 3: No
You don\\’t configure the SAN from a SQL Server, instead you can use a Microsoft Server server.
References: http://download.microsoft.com/download/d/2/0/d20e1c5f-72ea-4505-9f26-fef9550efd44/microsoft%20sql%20server%20alwayson%20solutions%20guide%20for%20high%20availability%20and%20disaster%20recovery.docx

Latest Pass4itsure Microsoft dumps discount code

Pass4itsure discount code 2020

What are the advantages of Pass4itsure?

Pass4itsure advantages

Free Microsoft 70-764 dumps pdf download from Google Drive:  https://drive.google.com/file/d/1U8Z2BEJArmw0ZggjsvtF5llMmI2PA6Ip/view?usp=sharing

Other related Microsoft exam dumps:

Click on Microsoft MCSA dumps!

Conclusion:

Select Pass4itsure Microsoft 70-764 dumps pdf pass Microsoft 70-764 exam: share latest 70-764 exam questions, and answers! 70-764 pdf, 70-764 exam video! Pass4itsure Microsoft dumps discount code! The latest 70-764 exam questions can help you pass the exam! Get the complete Pass4itsure 70-764 dumps pdf. All questions are corrected to ensure authenticity and effectiveness!