Examscode shares online exam exercise questions all year round! Microsoft MCSA 70-765 exam “Provisioning SQL Databases”
https://www.leads4pass.com/70-765.html (232 Q&As).Continue to study and we provide an updated cisco 70-765 exam practice questions and answers. You can practice the test online!
Watch the Microsoft MCSA 70-765 video tutorial online
Table of Contents:
- Latest Microsoft MCSA 70-765 pdf
- Test your Microsoft MCSA 70-765 exam level
- Related 70-765 Popular Exam resources
- Get Lead4Pass Coupons (12% OFF)
- What are the advantages of Lead4pass?
Latest Microsoft MCSA 70-765 pdf
[PDF] Free Microsoft MCSA 70-765 pdf dumps download from Google Drive: https://drive.google.com/open?id=1T53F4Z36tsS41UDYoNog_fVOP3ueIPk6
Exam 70-765: Provisioning SQL Databases – Microsoft：https://www.microsoft.com/en-us/learning/exam-70-765.aspx
Skills measured
This exam measures your ability to accomplish the technical tasks listed below.
- Implement SQL in Azure (40–45%)
- Manage databases and instances (30-35%)
- Manage Storage (30–35%)
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.
Microsoft MCSA 70-765 Exam Practice Questions
QUESTION 1
You have Microsoft SQL Server on a Microsoft azure virtual machine that has 12 databases.
All database files are in the same Azure Blob storage account.
You need to receive an email notification if I/O operations to the database files exceed 800 MB/s for more than five
minutes.
Solution: You run the Add-AzureRmMetricAlertRule cmdlet and specify the etricName `Network Out\\’ parameter.
Does this meet the goal?
A. Yes
B. No
Correct Answer: B
QUESTION 2
You plan to migrate a Microsoft sql server instance between physical servers.
You must migrate the metadata associated with the database instance.
You need to ensure that the new instance retains the existing jobs and alerts.
Solutions: You restore the model database.
Does the solution meet the goal?
A. Yes
B. No
Correct Answer: B
The model database does not handle alerts and jobs. It is used as the template for all databases created on an instance
of SQL Server.
The msdb database is used by SQL Server Agent for scheduling alerts and jobs and by other features such as SQL
Server Management Studio, Service Broker and Database Mail.
References:
https://docs.microsoft.com/en-us/sql/relational-databases/databases/msdb-database?view=sql-server-2017
QUESTION 3
You plan to migrate a Microsoft SQL server instance between physical servers.
You must migrate the metadata associated with the database instance.
You need to ensure that the new instance retains the existing jobs and alerts.
Solutions: You restore the service master key.
Does the solution meet the goal?
A. Yes
B. No
Correct Answer: B
The Service Master Key is the root of the SQL Server encryption hierarchy. It does not handle alerts and jobs.
The msdb database is used by SQL Server Agent for scheduling alerts and jobs and by other features such as SQL
Server Management Studio, Service Broker and Database Mail.
References:
https://docs.microsoft.com/en-us/sql/relational-databases/databases/msdb-database?view=sql-server-2017
QUESTION 4
You manage a Microsoft SQL Server instance named SQL1 that has 32 gigabytes (GB) of total memory. The instance
supports an app named App1 that only uses a single thread. App1 frequently queries the database using the same
index.
The operating system and App1 combined require 8 GB of memory to function.
You need to ensure that the SQL Server does not limit the performance of App1.
What configuration option should you set?
A. min memory per query to 4 GB
B. index create memory to 16 GB
C. max worker threads to 1
D. max server memory to 16 GB
Correct Answer: B
The index creates memory option controls the maximum amount of memory initially allocated for sort operations when
creating indexes. The default value for this option is 0 (self-configuring). If more memory is later needed for index
creation and the memory is available, the server will use it; thereby, exceeding the setting of this option. If additional
memory is not available, the index creation will continue using the memory already allocated.
References: https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-indexcreate-memory-server-configuration-option
QUESTION 5
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 need to run a Transact-SQL script against a Microsoft Azure SQL database daily at 01:00.
Solution: You install the Elastic Database jobs PowerShell package, and then you create an Elastic Database job.
Does this meet the goal?
A. Yes
B. No
Correct Answer: B
QUESTION 6
You administer a Windows 2008 server hosting an instance of Microsoft SQL Server 2014 Standard Edition.
The server hosts a database named Orders.
Users report that a query that filters on OrderDate is taking an exceptionally long time. You discover that an index
named IX_OrderDate on the CustomerOrder table is heavily fragmenteD.
You need to improve the performance of the IX_OrderDate index. The index should remain online during the operation.
Which Transact-SQL command should you use?
A. ALTER INDEX IX_OrderDateON CustomerOrder DISABLE
B. ALTER INDEX IX_OrderDateON CustomerOrder ENABLE
C. ALTER INDEX IX_OrderDateON CustomerOrder REORGANIZE
D. ALTER INDEX IX OrderDateON CustomerOrder REBUILD
Correct Answer: C
Reorganize: This option is more lightweight compared to rebuild. It runs through the leaf level of the index, and as it
goes it fixes physical ordering of pages and also compacts pages to apply any previously set fillfactor settings. This
operation is always online, and if you cancel it then it\\’s able to just stop where it is (it doesn\\’t have a giant operation to
rollback).
References:https://www.brentozar.com/archive/2013/09/index-maintenance-sql-server-rebuild-reorganize/
QUESTION 7
You use Microsoft Azure Resource Manager to deploy two new Microsoft SQL Server instances in an Azure virtual
machine (VM). VM has 28 gigabytes (GB) of memory. The instances are named Instance1 and Instance2, respectively.
The various databases on the instances have the following characteristics:
You run the following Transact-SQL statements:
You need to configure each SQL Server instance to correctly allocate memory. What should you do?
A. On Instance1, run the following Transact-SQL code: On Instance2, run the following Transact-SQL code:
B. A. On Instance1, run the following Transact-SQL code: On Instance2, run the following Transact-SQL code:
C. On Instance1, run the following Transact-SQL code: On Instance2, run the following Transact-SQL code:
D. On Instance1, run the following Transact-SQL code: On Instance2, run the following Transact-SQL code:
Correct Answer: D
QUESTION 8
You have a SQL Server 2016 database named DB1.
You plan to import a large number of records from a SQL Azure database to DB1.
You need to recommend a solution to minimize the amount of space used in the transaction log during the import
operation.
What should you include in the recommendation?
A. The bulk-logged recovery model
B. The full recovery model
C. A new partitioned table
D. A new log file
E. A new file group
Correct Answer: A
Compared to the full recovery model, which fully logs all transactions, the bulk-logged recovery model minimally logs
bulk operations, although fully logging other transactions. The bulk-logged recovery model protects against media
failure
and, for bulk operations, provides the best performance and least log space usage.
Note: The bulk-logged recovery model is a special-purpose recovery model that should be used only intermittently to
improve the performance of certain large-scale bulk operations, such as bulk imports of large amounts of data.
References: https://technet.microsoft.com/en-us/library/ms190692(v=sql.105).aspx
QUESTION 9
You are deploying a Microsoft SQL Server database that will support a mixed OLTP and OLAP workload. The target
virtual machine has four CPUs.
You need to ensure that reports do not use all available system resources.
What should you do?
A. Enable Auto Close.
B. Increase the value for the Minimum System Memory setting.
C. Set MAXDOP to half the number of CPUs available.
D. Increase the value for the Minimum Memory per query setting.
Correct Answer: C
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 option to limit the number of processors to use in parallel plan
execution.
QUESTION 10
You have a Microsoft Azure SQL database in the US West region.
You need to create a replica in the US East region.
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: G
The New-AzureRmSqlDatabaseCopy command creates a copy of a SQL Database that uses the snapshot at the
current time.
References: https://docs.microsoft.com/en-us/powershell/module/azurerm.sql/new-azurermsqldatabasecopy?view=azurermps-5.1.1
QUESTION 11
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 a GS-series virtual machine (VM) in Microsoft Azure. You plan to deploy Microsoft SQL Server.
You need to deploy a 30 megabyte (MB) database that requires 100 IOPS to be guaranteed while minimizing 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: A
Premium Storage Disks Limits
When you provision a disk against a Premium Storage account, how much input/output operations per second (IOPS)
and throughput (bandwidth) it can get depends on the size of the disk. Currently, there are three types of Premium
Storage
disks: P10, P20, and P30.
Each one has specific limits for IOPS and throughput as specified in the following table:
References:https://docs.microsoft.com/en-us/azure/storage/storage-premium-storage
QUESTION 12
You use a Microsoft SQL Server 2014 database that contains two tables named SalesOrderHeader and
SalesOrderDetail. The indexes on the tables are as shown in the exhibit.
(Click the Exhibit button.)
You write the following Transact-SQL query:
You discover that the performance of the query is slow. Analysis of the query plan shows table scans where the
estimated rows do not match the actual rows for SalesOrderHeader by using an unexpected index on
SalesOrderDetail.
You need to improve the performance of the query.
What should you do?
A. Use a FORCESCAN hint in the query.
B. Add a clustered index on SalesOrderId in SalesOrderHeader.
C. Use a FORCESEEK hint in the query.
D. Update statistics on SalesOrderId on both tables.
Correct Answer: D
New statistics would be useful.
The UPDATE STATISTICS command updates query optimization statistics on a table or indexed view. By default, the
query optimizer already updates statistics as necessary to improve the query plan; in some cases you can improve
query
performance by using UPDATE STATISTICS or the stored procedure sp_updatestats to update statistics more
frequently than the default updates.
References:
http://msdn.microsoft.com/en-us/library/ms187348.aspx
QUESTION 13
You plan to migrate a database To Microsoft Azure SQL Database. The database requires 500 gigabytes (GB) of
storage.
The database must support 50 concurrent logins. You must minimize the cost associated with hosting the database.
You need to create the database.
Which pricing tier should you use?
A. Standard S3 pricing tier
B. Premium P2tier
C. Standard S2 pricing tier
D. Premium P1 tier
Correct Answer: D
For a database size of 500 GB the Premium tier is required. Both P1 and P2 are adequate. P1 is preferred as it is
cheaper. Note:
Related 70-765 Popular Exam resources
| title | youtube | Microsoft | lead4pass | Lead4Pass Total Questions | |
|---|---|---|---|---|---|
| Microsoft MCSA | lead4pass 70-765 dumps pdf | lead4pass 70-765 youtube | Exam 70-765: Provisioning SQL Databases – Microsoft | https://www.leads4pass.com/70-765.html | 232 Q&A |
Get Lead4Pass Coupons(12% OFF)
What are the advantages of Lead4pass?
We have a number of Cisco, Microsoft, IBM, CompTIA and other exam experts. We update exam data throughout the year.
Top exam pass rate! We have a large user base. We are an industry leader! Choose Lead4Pass to pass the exam with ease!
Summarize:
The free Microsoft MCSA 70-765 exam dumps can help you improve your skills and exam experience! To pass the cisco 70-765 exam at once: https://www.leads4pass.com/70-765.html We make Microsoft 70-765 videos and 70-765 pdf for you to learn! I hope you can pass the exam easily.
