<< Prev Question Next Question >>

Question 6/60

HOTSPOT
You plan to deploy two new Microsoft Azure SQL Database instances. Once instance will support a data entry application. The other instance will support the company's business intelligence efforts. The databases will be accessed by mobile applications from public IP addresses.
You need to ensure that the database instances meet the following requirements:
* The database administration team must receive alerts for any suspicious activity in the data entry database, including potential SQL injection attacks.
* Executives around the world must have access to the business intelligence application.
* Sensitive data must never be transmitted. Sensitive data must not be stored in plain text in the database.
In the table below, identify the feature that you must implement for each database.
NOTE: Make only one selection in each column. Each correct selection is work one point.

LEAVE A REPLY

Your email address will not be published. Required fields are marked *

Question List (60q)
Question 1: HOTSPOT You need to maximize performance of writes to each d...
Question 2: DRAG DROP You have database that contains a 400-GB table tha...
Question 3: You plan to install a Microsoft SQL Server 2014 instance. Th...
Question 4: Note: This question is part of a series of questions that pr...
Question 5: Note: This question is part of a series of questions that pr...
Question 6: HOTSPOT You plan to deploy two new Microsoft Azure SQL Datab...
Question 7: You administer a Microsoft SQL Server 2014 instance that con...
Question 8: DRAG DROP You deploy a new Microsoft Azure SQL Database inst...
Question 9: You are the database administrator in your company. You plan...
Question 10: Note: This questions is part of a series of questions that u...
Question 11: You are designing a Windows Azure SQL Database for an order ...
Question 12: Note: This question is part of a series of questions that us...
Question 13: Note: This question is part of a series of questions that pr...
Question 14: Note: This question is part of a series of questions that us...
Question 15: You manage an on-premises, multi-tier application that has t...
Question 16: You administer a Microsoft SQL Server 2014 instance named SQ...
Question 17: You administer a Microsoft SQL Server 2014 database. You nee...
Question 18: You administer a Microsoft SQL Server 2014 environment. One ...
Question 19: You plan to deploy 20 Microsoft Azure SQL Database instances...
Question 20: You have a Microsoft SQL Server 2014 named SRV2014 that has ...
Question 21: Note: This question is part of a series of questions that pr...
Question 22: Note: This questions is part of a series of questions that u...
Question 23: You administer a Microsoft SQL Server 2014. A process that n...
Question 24: You manage a Microsoft SQL Server environment in a Microsoft...
Question 25: Note: This question is part of a series of questions that pr...
Question 26: HOTSPOT You have Microsoft SQL Server on a Microsoft Azure v...
Question 27: You administer a Microsoft SQL Server 2014 instance that has...
Question 28: Note: This question is part of a series of questions that pr...
Question 29: You use Microsoft SQL Server 2014 to develop a database appl...
Question 30: You are a database developer for an application hosted on a ...
Question 31: Note: This question is part of a series of questions that pr...
Question 32: You are a database administrator for a Microsoft SQL Server ...
Question 33: You manage an on-premises Microsoft SQL server that has a da...
Question 34: You administer a Microsoft SQL Server 2014 database instance...
1 commentQuestion 35: DRAG DROP Background You manage the Microsoft SQL Server env...
Question 36: Note: This question is part of a series of questions that pr...
Question 37: You administer two Microsoft SQL Server 2014 servers. Each s...
Question 38: You administer a Microsoft SQL Server 2014 database that con...
Question 39: You plan to migrate a database To Microsoft Azure SQL Databa...
Question 40: You administer a Microsoft SQL Server 2016 instance. You nee...
Question 41: You have a database named DB1 that contains a table named Ta...
Question 42: HOTSPOT You need to resolve the identified issues. Use the d...
Question 43: You administer a Microsoft SQL Server 2014 database named Co...
Question 44: DRAG DROP You have a Microsoft SQL Server instance that has ...
Question 45: Note: This question is part of a series of questions that pr...
1 commentQuestion 46: HOTSPOT You need to open the firewall ports for use with SQL...
Question 47: You administer a Windows Azure SQL Database database named H...
Question 48: You are a database developer of a Microsoft SQL Server 2014 ...
Question 49: You administer a Microsoft SQL Server 2014 instance that con...
Question 50: You are the administrator of a Microsoft SQL Server 2014 ser...
Question 51: HOTSPOT You need to configure the data entry and business in...
Question 52: DRAG DROP You have on-premises database server. The database...
Question 53: You are a database administrator for a Microsoft SQL Server ...
Question 54: You use a contained database named ContosoDb within a domain...
Question 55: Note: This question is part of a series of questions that pr...
Question 56: You create a new Microsoft Azure subscription. You need to c...
1 commentQuestion 57: You have a database named DB1 that uses simple recovery mode...
Question 58: You administer a Microsoft SQL Server 2014. A process that n...
Question 59: You administer a Windows Azure SQL Database database named I...
Question 60: You administer a Microsoft SQL Server 2014 server. The MSSQL...