A company has an on-premises Microsoft SQL Server 2014 environment. The company has a main office in Seattle, and remote offices in Amsterdam and Tokyo. You plan to deploy a Microsoft Azure SQL Database instance to support a new application. You expect to have 100 users from each office. In the past, users at remote sites reported issues when they used applications hosted at the Seattle office. You need to optimize performance for users running reports while minimizing costs. What should you do?

Correct Answer: Implement a standard database with readable secondaries in Asia and Europe, and then migrate the application.

You plan to deploy an AlwaysOn failover cluster in Microsoft Azure. The cluster has a Service Level Agreement (SLA) that requires an uptime of at least 99.95 percent. You need to ensure that the cluster meets the SLA. Which cmdlet should you run before you deploy the virtual machine?

Correct Answer: New-AzureRmSqlDatabaseSecondary

You plan to migrate on-premises Microsoft SQL Server databases to SQL Server on a Microsoft Azure virtual machine. A full back up of the databases is 3 TB. The corporate network has a 1.5 MB/sec Internet connection. You need to move the backups to Azure to ensure that you can restore the databases to the Azure virtual machine as quickly as possible. What should you do?

Correct Answer: Use SQL Server Backup to URL. parameter.

You have a Microsoft SQL Server 2014 named SRV2014 that has a single tempdb database file. The tempdb database file is eight gigabytes (GB) in size. You install a SQL Server 2016 instance named SQL Server 2016 by using default settings. The new instance has eight logical processor cores. You plan to migrate the databases from SRV2014 to SRV2016. You need to configure the tempdb database on SRV2016. The solution must minimize the number of future tempdb autogrowth events. What should you do?

Correct Answer: Increase the size of the tempdb data files to 1 GB.

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. Each VM has a dedicated disk for backups. You need to backup a database to the local disk on a VM. The backup must be replicated to another region. Which storage option should you use?

Correct Answer: Premium P10 disk storage

You manage a Microsoft SQL Server environment in a Microsoft Azure virtual machine. You must enable Always Encrypted for columns in a database. You need to configure the key store provider. What should you do?

Correct Answer: Use the Windows certificate store.

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?

Correct Answer: Premium P30 disk storage

Note: This questions 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 manage on-premises and Microsoft Azure SQL Database instances for a company. Your environment must support the Microsoft SQL Server 2012 ODBS driver. You need to encrypt only specific columns in the database. What should you implement?

Correct Answer: Transparent Data Encryption

Note: This questions 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. Your company has several Microsoft Azure SQL Database instances. Data encryption should be allowed to be implemented by the client applications that access the data. Encryption keys should not be made available to the database engine. You need to configure the database. What should you implement?

Correct Answer: Always Encrypted

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?

Correct Answer: Standard S3 pricing tier

You administer a Microsoft SQL Server 2012 database. Users report that an application that accesses the database displays an error, but the error does not provide meaningful information. No entries are found in the SQL Server log or Windows event logs related to the error. You need to identify the root cause of the issue by retrieving the error message. What should you do?

Correct Answer: Create an Extended Events session by using the sqlserver.error_reported event.

A company plans to use a Microsoft Azure SQL Database instance to manage sensitive data. The solution must allow data to be decrypted while in use but encrypted while at rest. You need to ensure that the columns are protected. What should you use?

Correct Answer: persistent data masking

You administer a Microsoft SQL Server 2012 server. One of the databases on the server supports a highly active OLTP application. Users report abnormally long wait times when they submit data into the application. You need to identify which queries are taking longer than 1 second to run over an extended period of time. What should you do?

Correct Answer: use SQL Profiler to trace all queries that are processing on the server. Filter queries that have a Duration value of more than 1,000.

You administer a Microsoft SQL Server 2012 database. You need to ensure that the size of the transaction log file does not exceed 2 GB. What should you do?

Correct Answer: use the ALTER DATABASE...SET LOGFILE command along with the maxsize parameter.

A company hosts a default installation of Microsoft SQL Server 2017 on a Linux-based server. You observe that the performance of the server has degraded. Process for allocating tables show high latency. You need to recommend a solution to improve performance when allocating tables. What should you recommend?

Correct Answer: Increase the Virtual Address Space limit

You administer a Microsoft SQL Server 2012 server. The MSSQLSERVER service uses a domain account named CONTOSO\SQLService. You plan to configure Instant File Initialization. You need to ensure that Data File Autogrow operations use Instant File Initialization. What should you do? Choose all that apply.

Correct Answer: Add the CONTOSO\SQLService account to the Perform Volume Maintenance Tasks local security policy.

You administer a Microsoft SQL Server 2012 database. The database contains a Product table created by using the following definition: You need to ensure that the minimum amount of disk space is used to store the data in the Product table. What should you do?

Correct Answer: Convert all indexes to Column Store indexes.

You administer a Microsoft SQL Server 2012 instance named SQL2012 that hosts an OLTP database of 1 terabyte in size. The database is modified by users only from Monday through Friday from 09:00 hours to 17:00 hours. Users modify more than 30 percent of the data in the database during the week. Backups are performed as shown in the following schedule: The Finance department plans to execute a batch process every Saturday at 09:00 hours. This batch process will take a maximum of 8 hours to complete. The batch process will update three tables that are 10 GB in size. The batch process will update these tables multiple times. When the batch process completes, the Finance department runs a report to find out whether the batch process has completed correctly. You need to ensure that if the Finance department disapproves the batch process, the batch operation can be rolled back in the minimum amount of time. What should you do on Saturday?

Correct Answer: Perform a differential backup at 08:59 hours.

You plan to create an AlwaysOn availability group that will have two replicas in Microsoft Azure and two on-premises replicas. You need to ensure that a replica in Azure is always available. Which cmdlet should you run before you deploy the virtual machines?

Correct Answer: New-AzureRmSqlDatabaseSecondary

You are planning a Microsoft SQL Server deployment. You do not have a Storage Area Network (SAN) or Network Attached Storage (NAS) infrastructure. You have a physical host that has 128 gigabytes (GB) RAM, two ""core processors, and two 1 GB network interface cards (NICs). The host supports RAID through a write-caching RAID controller. The RAID controller is not specifically designed for DBMS systems. The host can support up to eight physically attached disks. The system does not include a battery backup power supply. You must implement SQL Server best practices when installing and configuring the server to host SQL Server. You need to configure the system to support a SQL Server installation by using best practices. What should you do?

Correct Answer: Increase the RAM in the server.

You have an on-premises Microsoft SQL Server instance. You create a database named DB1. You need to configure DB1 to support In-Memory OLTP. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Correct Answer: Enable In-Memory OLTP for the instance.

You administer a Microsoft SQL Server database named Sales. The database is 3 terabytes in size. The Sales database is configured as shown in the following table. You discover that all files except Sales_2.ndf are corrupt. You need to recover the corrupted data in the minimum amount of time. What should you do?

Correct Answer: Perform a filegroup restore.

You have a database named DB1 and an application named App1. App1 queries DB1. You discover that a non-clustered index in DB1 is corrupt. You need to repair the index. App1 must be able to query DB1 while the index is being repaired. What should you do?

Correct Answer: Drop and recreate the index.

You have Microsoft SQL Server on a Microsoft Azure virtual machine. You discover that queries take longer than expected to execute. You also find that the top wait type for the SQL Server instance is ASYNC_NETWORK_IO. You need to resolve the performance issue. What should you do?

Correct Answer: Increase the number of processor cores for the virtual machine

Welcome to awslagi.com – Sharing AWS, Google Cloud, Microsoft Azure IT Exams. It's free for all!

Provisioning SQL Databases

Provision SQL databases for reliable enterprise deployment.

4.8★★★★★(396 ratings)

19,490 studentsIntermediate

Learn to deploy and provision SQL databases with the right configuration, performance, and lifecycle controls. The exam focuses on making databases ready for business applications in a structured and repeatable way. This certification is useful for database professionals involved in deployment and platform preparation. It helps ensure consistent, predictable database setup across environments.

What you'll learn

Provision SQL databases- Configure deployment settings- Prepare database environments- Support application readiness- Standardize database delivery

70-765

Lectures1

Quizzes0

Duration30 week

Students19,490

$20.00

📢 Unlock Full Access to Success!

"The content displayed here is a promotional preview and contains only 50% of the actual exam database. To access the complete set of updated questions, please upgrade to the Full Version."

👉 Click the button and follow the instructions to secure your full access immediately!