×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
You are the database administrator in your company. You plan to create 10 identical environments that use SQL Server 2016 as a database engine. Each environment has the following custom requirements:
Three user databases must be preinstalled.
The tempdb database must contain eight data files that are 1024 MB each.
Trace flag 2371 must be turned at the instance level.
The solution must meet the following requirements:
The instance must be preconfigured.
No other database features are required in the future.
The solution must use the minimum administrative effort.
You need to prepare the environments. What should you do?
Three user databases must be preinstalled.
The tempdb database must contain eight data files that are 1024 MB each.
Trace flag 2371 must be turned at the instance level.
The solution must meet the following requirements:
The instance must be preconfigured.
No other database features are required in the future.
The solution must use the minimum administrative effort.
You need to prepare the environments. What should you do?
2.
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?
3.
You have an on-premises Microsoft SQL server that has a database named DB1. DB1 contains several tables that are stretched to Microsoft Azure. A network administrator upgrades the hardware firewalls on the network. You need to verify whether data migration still runs successfully. Which stored procedure should you run?
4.
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?
5.
You have a single-server on-premises Microsoft SQL Server deployment. You must migrate the environment to an Azure virtual machine (VM). You must minimize costs while maintaining the same level of performance as the on-premises SQL environment. You need to evaluate the number and types of read/write operations for the existing deployment. Which tool should you use?
6.
A company plans to run Microsoft SQL Server on Linux-based servers. You need to ensure that performance tuning settings are automatically configured during installation. Which Linux platform should you recommend?
7.
You have a single-server on-premises Microsoft SQL Server deployment. You must migrate the environment to an Azure virtual machine (VM). You must minimize costs while maintaining the same level of performance as the on-premises SQL environment. You need to evaluate the number and types of read/write operations for the existing deployment. Which tool should you use?
8.
You have three Microsoft SQL Server instances. Each instance is deployed to a separate physical server. You must install a new SQL Server instance for the marketing team. All instances must have the same configuration. You need to create an unattended answer file to deploy the marketing SQL instance. What should you do?
9.
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?
10.
You plan to deploy 20 Microsoft Azure SQL Database instances to an elastic pool in Azure to support a batch processing application. Two of the databases in the pool reach their peak workload threshold at the same time every day. This leads to inconsistent performance for batch completion. You need to ensure that all batches perform consistently. What should you do?