What should you do?

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?A . Manually specify the column master key.B . Modify the connection string for applications.C ....

January 25, 2019 No Comments READ MORE +

Which recovery model should the database use?

You administer a Microsoft SQL Server 2014 instance that contains a financial database hosted on a storage area network (SAN). The financial database has the following characteristics: The database is continually modified by users during business hours from Monday through Friday between 09:00 hours and 17:00 hours. Five percent of...

January 25, 2019 No Comments READ MORE +

What should you do?

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...

January 23, 2019 No Comments READ MORE +

Does the solution meet the goal?

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...

January 22, 2019 No Comments READ MORE +

Which backup option should you use?

You administer a Microsoft SQL Server 2014 instance that contains a financial database hosted on a storage area network (SAN). The financial database has the following characteristics: The database is continually modified by users during business hours from Monday through Friday between 09:00 hours and 17:00 hours. Five percent of...

January 21, 2019 No Comments READ MORE +

You use Resource Manager to deploy a new Microsoft SQL Server instance in a Microsoft Azure virtual machine (VM) that uses Premium storage. The combined initial size of the SQL Server user database files is expected to be over 200 gigabytes (GB). You must maximize performance for the database files and the log file

HOTSPOT You use Resource Manager to deploy a new Microsoft SQL Server instance in a Microsoft Azure virtual machine (VM) that uses Premium storage. The combined initial size of the SQL Server user database files is expected to be over 200 gigabytes (GB). You must maximize performance for the database...

January 19, 2019 No Comments READ MORE +

What should you implement?

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...

January 17, 2019 No Comments READ MORE +

You need to resolve the identified issues

HOTSPOT You need to resolve the identified issues. Use the drop-down menus to select the answer choice that answers each question based on the information presented in the graphic. View AnswerAnswer: Explanation: From exhibit we see: Cost Threshold of Parallelism: 5 Optimize for Ad Hoc Workloads: false Max Degree of...

January 10, 2019 No Comments READ MORE +

Does the solution meet the goal?

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...

January 6, 2019 No Comments READ MORE +

What should you do?

You administer a Microsoft SQL Server 2014 failover cluster that contains two nodes named Node A and Node B. A single instance of SQL Server is installed on the cluster. An additional node named Node C has been added to the existing cluster. You need to ensure that the SQL...

January 5, 2019 No Comments READ MORE +