Provisioning SQL Databases


QuickStart is proud to offer you assessment questions for Provisioning Microsoft SQL Databases (MS-20765). Whether you are still deciding which exam to sign up for, or simply want to review and practice the materials necessary to complete certification for this course, We have provided a practice assessment to better aid in guiding you to certification. 100% of the questions are a real questions from a recent version of the test you will have to take for Provisioning Microsoft SQL Databases (MS-20765).


Arrow
 

1

For all the future deployments of SQL server on Azure virtual machines, your company plans to use Microsoft Azure resource manager templates. You have to create the templates. Solution: You create a XAML template by using Visual studio that defines the deployment and configuration setting for SQL server environment.

Can you achieve your goal with the above solution?

A. Yes
Incorrect.
B. No
Correct!
2

For all the future deployments of SQL server on Azure virtual machines, your company plans to use Microsoft Azure resource manager templates. You have to create the templates. Solution: In an azure resource group, you created the desired SQL server configuration. The template of the resource group is then exported and save it to the templates library.

Can you achieve your goal with the above solution?

A. Yes
Incorrect.
B. No
Correct!
3

For all the future deployments of SQL server on Azure virtual machines, your company plans to use Microsoft Azure resource manager templates. You have to create the templates. Solution: You create a JSON template by using Visual studio that defines the deployment and configuration setting for SQL server environment. Can you achieve your goal with the above solution?

Can you achieve your goal with the above solution?

A. Yes
Incorrect.
B. No
Correct!
4

There is a single database file tempdb which is created by using Microsoft SQL server 2014 named SRV2014. The size of the file tempdb is eight Gigabytes (GB). An SQL Server 2016 instance named SQL Server 2016 is installed by using default settings. There are eight logical processor cores in the new instance. The database SRV2014 is plan to be migrated to SRV2016. The tempdb database needs to be configured on SRV2016. You need a solution that must minimize the number of future tempdb auto-grow the events.

What should you do?

5

In Microsoft Azure, several GS-series virtual machines (VM) have been deployed. You are planning to deploy Microsoft SQL server in a development environment. There is a dictated disk for backups for each VM. A database needs to be backup to the local disk on a VM. The backup must be replicated to another region.

What should be the correct option for storage?

6

You have a 2 Terabytes (TB) database virtual machine (VM) in Microsoft Azure. By using backups to URL, Microsoft SQL server backups are performed. While minimizing costs you need to provision the storage account for the backups.

What should be the correct option for storage?

7

In Microsoft azure several GS-series virtual machines (VM) have been deployed. You plan to deploy Microsoft SQL server. A 30-megabytes Database needs to be deployed that requires 100 IOPS to be guaranteed while minimizing costs.

What should be the correct option for storage?

8

In Microsoft azure several GS-series virtual machines (VM) have been deployed. You are planning to deploy Microsoft SQL server in a development environment. Provide storage to the environment that minimizes costs.

What should be the correct option for storage?

9

A database is planned to migrate to Microsoft azure SQL database. The storage of 500 gigabytes (GB) is required by the database. The database must support 50 concurrent logins. The cost associated with hosting the database must be minimized. You need to create the database. Which should be the pricing tier?

A. Standard S3 pricing tier
Incorrect.
B. Premium P2 tier
Incorrect.
C. Standard S2 pricing tier
Incorrect.
D. Premium P1 tier
Correct!
10

In a Microsoft SQL server environment, you are managing several databases. You need to confirm that the queries use statistical data and the values should not be initialized for the local variable. Solution: Enabling the option of QUERY__OPTIMIZER_HOTFIXES for databases.

Is this solution correct for your goal?

A. Yes
Incorrect.
B. No
Correct!
12

In a Microsoft SQL server environment, you are managing several databases. You need to confirm that the queries use statistical data and the values should not be initialized for the local variable. Solution: Enabling the option of LEGACY_CARDINALITY_ESTIMATION for databases.

Is this solution correct for your goal?

A. Yes
Incorrect.
B. No
Correct!
13

In a Microsoft SQL server environment, you are managing several databases. You need to confirm that the queries use statistical data and the values should not be initialized for the local variable. Solution: Enabling the option of PARAMETER_SNIFFING for databases.

Is this solution correct for your goal?

A. Yes
Correct!
B. No
Incorrect.
14

In a Microsoft Azure virtual machine, you are managing a Microsoft SQL server environment. Always Encrypted for the columns in a database must be enabled. The key store provider needs to be configured, what should you do?

14

20 Microsoft Azure SQL database instances are planned to deploy to an elastic pool in Azure to support a batch processing application. Every day at the same time, two of the database in the pool reach their peak workload threshold. This leads to inconsistent performance for batch completion. To make sure that all batches perform consistently.

What should you do?

15

For a company, you are managing on-premises and Microsoft Azure SQL database instances. Microsoft SQL server 2012 ODBS must be supported by your environment. Only specific column in the Database must be encrypted. What should you implement?

A. transport-level encryption
Incorrect.
B. cell-level encryption
Incorrect.
C. Transparent Data Encryption
Incorrect.
D. Always Encrypted
Correct!
E. Encrypting File System
Incorrect.
F. BitLocker
Incorrect.
G. dynamic data masking
Incorrect.
16

There are several Microsoft database instances in your company. For the client application that access the data, data encryption must be allowed to be implemented. Do not make encryption keys available to the database engine. To configure the database what should you implement?

A. transport-level encryption
Correct!
B. cell-level encryption
Incorrect.
C. Transparent Data Encryption
Incorrect.
D. Always Encrypted
Incorrect.
E. Encrypting File System
Incorrect.
F. BitLocker
Incorrect.
G. dynamic data masking
Incorrect.
17

To a virtual machine in Azure, you deployed Microsoft SQL server. You distribute across multiple Azure storage disks the database files and the file group. Using SQL server management studio, the database must be able to be managed as individual entities. All the data stored in the database must be encrypted. By using the same key as the live copy of the database backups must be encrypted. In order to secure the database what should be implemented?

A. transport-level encryption
Incorrect.
B. cell-level encryption
Incorrect.
C. Transparent Data Encryption
Correct!
D. Always Encrypted
Incorrect.
E. Encrypting File System
Incorrect.
F. BitLocker
Incorrect.
G. dynamic data masking
Incorrect.
18

To support a mixed OLTP and OLAP workload you are deploying a Microsoft SQL server database. There are four CPU's in the target virtual machine. Reports must not use all available system resources. What should you do?

19

There is an on-premises Microsoft server 2014 environment in a company. The company's main office is in Seattle and remote offices in Amsterdam and Tokyo. To support a new application you plan to deploy a Microsoft Azure SQL Database instance. 100 users from each office are expected. In the past, when the application hosted at Seattle was used users at remote sites reported an issue. For users running reports, you need to optimize the performance while minimizing costs. What should you do?

20

Data in a Microsoft SQL server instance is stored by your mission- critical application. There are several financial reports running by the application. SQL Server-authenticated login named Reporting_User is used by the reports. Windows authentication is used by the queries that write data to the database. It is reported by the users that queries take a long time to complete that is used to provide data for the financial reports. The majority of CPU and memory resources are consumed by the resources on the database server. As a result, read-write queries also take a long time to complete for the application. Performance of the application needs to be improved while still allowing the report queries to finish.

Solution: A snapshot of Database is created. Configure all report queries to use the snapshot. Will you be able to achieve your goal by the above solution?

A. Yes
Incorrect.
B. No
Correct!
21

Data in a Microsoft SQL server instance is stored by your mission- critical application. There are several financial reports running by the application. SQL Server-authenticated login named Reporting _User is used by the reports. Windows authentication is used by the queries that write data to the database. It is reported by the users that queries take a long time to complete that is used to provide data for the financial reports. The majority of CPU and memory resources are consumed by the resources on the database server As a result, read-write queries also take a long time to complete for the application. Performance of the application needs to be improved while still allowing the report queries to finish.

Solution: To limit the amount of memory, CPU, ISOP used for the pool of all queries, you configure the resource Governor that the Reporting User login can run concurrently. Will you be able to achieve your goal by the above solution?

A. Yes
Correct!
B. No
Incorrect.
22

Data in a Microsoft SQL server instance is stored by your mission- critical application. There are several financial reports running by the application. The reports use a SQL Server-authenticated login named Reporting User. Windows authentication is used by the queries that write data to the database. It is reported by the users that queries take a long time to complete that is used to provide data for the financial reports. The queries consume the majority of CPU and memory resources on the database server. As a result, read-write queries also take a long time to complete for the application. Performance of the application needs to be improved while still allowing the report queries to finish.

Solution: The Resource Governor is configured to set the MAXDOP parameter for all queries to 0 against the database.

Will you be able to achieve your goal by the above solution?

A. Yes
Incorrect.
B. No
Correct!

Back To Top
 
PDP Url

Practice Exam - Provisioning Microsoft SQL Databases


Self-Paced

Learning Style

Beginner

Difficulty

1 Hour

Course Duration

Course Info

Download PDF

Certificate

See Sample

Buy Individually
About Individual Course:
  • Individual course plan gives you access to this course
$0.00
$0.00
/ Each

Outline

More Information

More Information
Lab Access No
Learning Style Self-Paced Learning
Difficulty Beginner
Course Duration 1 Hour
Language English

Reviews

Write Your Own Review
Only registered users can write reviews. Please Sign in or create an account

Contact A Learning Consultant


click here