Easyhometraining shares the latest Microsoft MCSA 70-765 exam dumps for free exam practice tests and online downloads! “Provisioning SQL Databases” 70-765 exam. Ready to pass the 70-765 exam please click https://www.pass4itsure.com/70-765.html (full exam dump)
Share a free Microsoft MCSA 70-765 video tutorial
Microsoft MCSA 70-765 Exam pdf
[JuJy PDF] Free Microsoft 70-765 pdf dumps download from Google Drive: https://drive.google.com/open?id=1W_vfWWxXBnirCWsD_mnLIwuFNmbJC5kI
[Apr PDF] Free Microsoft 70-765 pdf dumps download from Google Drive: https://drive.google.com/open?id=1pSKeu1TrCiFDv_ZI8-d30EWjF9M7Ds0z
Exam 70-765: Provisioning SQL Databases – Microsoft: https://www.microsoft.com/en-us/learning/exam-70-765.aspx
Microsoft MCSA 70-765 Online Exam Practice Questions
QUESTION 1
You administer a Microsoft SQL Server 2014 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
The use of local disks for TempDB allows us to have more flexibility when configuring for optimal performance. It is a
common performance recommendation to create the TempDB database on the fastest storage available. With the
capability to utilize local disk for TempDB placement we can easily utilize disks that are larger, have a higher rotational
speed or use SSD disks.
References:https://www.mssqltips.com/sqlservertip/2817/sql-server-2012-cluster-with-tempdb-on-local-disk/
QUESTION 2
You develop a Microsoft SQL Server 2014 database that contains a heap named OrdersHistorical.
You write the following Transact-SQL query:
INSERT INTO OrdersHistorical
SELECT * FROM CompletedOrders
You need to optimize transaction logging and locking for the statement.
Which table hint should you use?
A. HOLDLOCK
B. ROWLOCK
C. XLOCK
D. UPDLOCK
E. TABLOCK
Correct Answer: E
When importing data into a heap by using the INSERT INTO SELECT FROM statement, you can enable optimized
logging and locking for the statement by specifying the TABLOCK hint for the target table.
References:https://docs.microsoft.com/en-us/sql/t-sql/queries/hints-transact-sql-table
QUESTION 3
Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may
be correct for more than one question in the series. Each question is independent of the other questions in this series.
Information and details provided in a question apply only to that question.
You have deployed several GS-series virtual machines (VMs) in Microsoft Azure. You plan to deploy Microsoft SQL
Server in a development environment.
You need to provide storage to the environment that minimizes costs.
Which storage option should you use?
A. Premium P10 disk storage
B. Premium P20 disk storage
C. Premium P30 disk storage
D. Standard locally redundant disk storage
E. Standard geo-redundant disk storage
F. Standard zone redundant blob storage
G. Standard locally redundant blob storage
H. Standard geo-redundant blob storage
Correct Answer: D
QUESTION 4
You plan to create an AlwaysOn availability group that will have two replicas in Microsoft Azure and two on premises
replicas.
You need to configure the network to support the availability group listener.
Which cmdlet should you run first?
A. New-AzureRmAvailabilitySet
B. New-AzureRmLoadBalancer
C. New-AzureRmSqlDatabaseSecondary
D. New-AzureRmSqlElasticPool
E. New-AzureRmVM
F. New-AzureRmSqlServer
G. New-AzureRmSqlDatabaseCopy
H. New-AzureRmSqlServerCommunicationLink
Correct Answer: B
An availability group listener is a virtual network name that clients connect to for database access. On Azure virtual
machines, a load balancer holds the IP address for the listener. The load balancer routes traffic to the instance of SQL
Server that is listening on the probe port. Usually, an availability group uses an internal load balancer.
References: https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windowsportal-sql-ps-alwayson-int-listener
QUESTION 5
You manage a Microsoft SQL Server environment with several databases.
You need to ensure that queries use statistical data and do not initialize values for local variables.
Solution: you set the value of the MAXDOP parameter to 2.
Does the solution meet the goal?
A. Yes
B. No
Correct Answer: B
When an instance of SQL Server runs on a computer that has more than one microprocessor or CPU, it detects the best
degree of parallelism, that is, the number of processors employed to run a single statement, for each parallel plan
execution. You can use the max degree of parallelism (MAXDOP) option to limit the number of processors to use in
parallel plan execution.
References: https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-max-degree-of-parallelism-server-configuration-option?view=sql-server-2017
QUESTION 6
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.
You use a Microsoft Azure SQL database as a data warehouse. The database is in the Standard service tier and has
400 elastic database throughput units (eDTUs).
You load data to the database by using Azure Data Factory.
You need to reduce the amount of time it takes to load the data.
Solution: You move the database to a Basic elastic pool that has 1.600 eDTUs.
Does this meet the goal?
A. Yes
B. No
Correct Answer: B
QUESTION 7
You have an on-premises Microsoft SQL server that has a database named DB1. DB1 contains several tables that are
stretched to Microsoft Azure.
From SQL Server Management Studio (SSMS), a junior database administrator accidentally deletes several rows from
the Azure SQL database and breaks the connection to Azure.
You need to resume Stretch Database operations.
Which two stored procedures should you use? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
A. sys.sp_rda_reconcile_batch
B. sys.sp_rda_reconcile_indexes
C. sys.sp_rda_reauthorize_db
D. sys.sp_rda_reconcile_columns
E. sys.sp_rda_set_rpo_duration
Correct Answer: CD
sys.sp_rda_reauthorize_db restores the authenticated connection between a local database enabled for Stretch and the
remote database.
If you have accidentally deleted columns from the remote table, run sp_rda_reconcile_columns to add columns to the
remote table that exist in the Stretch-enabled SQL Server table but not in the remote table.
QUESTION 8
You have an on-premises database.
You plan to migrate the database to Microsoft SQL Server on a Microsoft Azure virtual machine.
You move the database files to Azure.
You need to attach the database files to the SQL Server instance on the virtual machine.
The solution must ensure that you can run file snapshot backups.
How should you complete the statement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Correct Answer:
QUESTION 9
You have an on-premises database.
You plan to migrate the database to Microsoft SQL Server on a Microsoft Azure virtual machine.
You move the database files to Azure.
You need to attach the database files to the SQL Server instance on the virtual machine.
The solution must ensure that you can run file snapshot backups.
How should you complete the statement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Correct Answer:
References: https://docs.microsoft.com/en-us/sql/t-sql/statements/create-database-sqlserver-transact-sql
QUESTION 10
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains
a unique solution. Determine whether the solution meets stated goals.
You have a mission-critical application that stores data in a Microsoft SQL Server instance.
The application runs several financial reports. The reports use a SQL Server-authenticated login named
Reporting_User. All queries that write data to the database use Windows authentication.
Users report that the queries used to provide data for the financial reports take a long time to complete. The queries
consume the majority of CPU and memory resources on the database server. As a result, read-write queries for the
application also take a long time to complete.
You need to improve performance of the application while still allowing the report queries to finish.
Solution: You create a snapshot of the database. You configure all report queries to use the database snapshot.
Does the solution meet the goal?
A. Yes
B. No
Correct Answer: B
Use a Resource Governor instead. References:https://msdn.microsoft.com/en-us/library/bb933866.aspx
QUESTION 11
A company has an on-premises Microsoft SQL Server 2017 infrastructure. The storage area network (SAN) that
supports the SQL infrastructure has reached maximum capacity.
You need to recommend a solution to reduce on-premises storage use without changing the application.
What should you do?
A. Configure an Express Route connection to Microsoft Azure.
B. Configure a Microsoft Azure Key Vault.
C. Configure geo-replication on the SAN.
D. Configure SQL Server Stretch Database in Microsoft Azure.
Correct Answer: D
Stretch warm and cold transactional data dynamically from SQL Server to Microsoft Azure with SQL Server Stretch
Database. Unlike typical cold data storage, your data is always online and available to query. Benefit from the low cost
of Azure rather than scaling expensive, on-premises storage.
References: https://docs.microsoft.com/en-us/sql/sql-server/stretch-database/stretch-database?view=sql-server-2017
QUESTION 12
You are developing customized Microsoft Azure Resource Group templates to automate the process of deploying
Microsoft SQL Server in Azure to enforce consistency during future deployments.
You need to deploy the customized templates to the Azure environment and to external endpoints. Which resource
value should you populate?
A. properties
B. name
C. resources
D. dbType
E. apiVersion
Correct Answer: E
QUESTION 13
You administer a Microsoft SQL Server 2014 instance named SQL2012. You are in the process of migrating a database
from a SQL Server 2008 instance named SQL2008 to the SQL2012 instance.
You have upgraded a database from the SQL2008 instance by using the side-by-side migration technique.
You need to migrate the SQL Server logins from the SQL2008 instance to the SQL2012 instance.
What should you do?
A. Back up the master database on the SQL2008 instance. Restore the master database on the SQL2012 instance
B. Use the Transfer Logins task in a Microsoft SQL Server Integrated Services package
C. Use sp_grantlogin
D. Use xp_logininfo.
Correct Answer: C
sp_grantlogin creates a SQL Server login.
Share Pass4itsure discount codes for free
About Pass4itsure!
Pass4itsure offers the latest exam practice questions and answers free of charge! Update all exam questions throughout the year,
with a number of professional exam experts! To make sure it works! Maximum pass rate, best value for money! It helps you pass the exam easily on your first attempt.
Summarize:
How do I pass the Microsoft MCSA 70-765 exam? You need to be prepared for it! You need the latest and most effective learning materials and proper practices to pass the 70-765 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”. Pass4itsure offers you the latest exam materials! You can use the materials to prepare to help you achieve excellent results!
This maybe you’re interested