<< Prev Question Next Question >>

Question 19/49

You have an Azure SQL database named DB3.
You need to provide a user named DevUser with the ability to view the properties of DB3 from Microsoft SQL Server Management Studio (SSMS) as shown in the exhibit. (Click the Exhibit tab.)

Which Transact-SQL command should you run?

LEAVE A REPLY

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

Question List (49q)
Question 1: You have an Azure SQL database named sqldb1. You need to min...
Question 2: You deploy a database to an Azure SQL Database managed insta...
Question 3: Note: This question is part of a series of questions that pr...
Question 4: You are designing a dimension table in an Azure Synapse Anal...
Question 5: You have an Azure subscription that is linked to a hybrid Az...
Question 6: You have an Azure virtual machine named VM1 on a virtual net...
Question 7: You have an Azure SQL Database managed instance named SQLMI1...
Question 8: You have an Azure SQL database named sqldb1. You need to min...
Question 9: You are designing a date dimension table in an Azure Synapse...
Question 10: You are designing a streaming data solution that will ingest...
Question 11: You have an Azure SQL database. You discover that the plan c...
Question 12: You plan to develop a dataset named Purchases by using Azure...
Question 13: You plan to move two 100-GB databases to Azure. You need to ...
Question 14: You have an Azure SQL database named DB1. The automatic tuni...
Question 15: Note: This question is part of a series of questions that pr...
Question 16: You are performing exploratory analysis of bus fare data in ...
Question 17: Note: This question is part of a series of questions that pr...
Question 18: You have a new Azure SQL database named DB1 on an Azure SQL ...
Question 19: You have an Azure SQL database named DB3. You need to provid...
Question 20: You have an Azure data factory that has two pipelines named ...
Question 21: Note: This question is part of a series of questions that pr...
Question 22: Note: This question is part of a series of questions that pr...
Question 23: You need to recommend an availability strategy for an Azure ...
Question 24: You have an on-premises app named App1 that stores data in a...
Question 25: You need to design a data retention solution for the Twitter...
Question 26: Note: This question is part of a series of questions that pr...
Question 27: You have SQL Server 2019 on an Azure virtual machine that ru...
Question 28: You have 40 Azure SQL databases, each for a different custom...
Question 29: Which counter should you monitor for real-time processing to...
Question 30: You are designing a star schema for a dataset that contains ...
Question 31: You have an Azure Synapse Analytics Apache Spark pool named ...
Question 32: You have SQL Server on an Azure virtual machine that contain...
Question 33: You have an Azure SQL database named db1. You need to retrie...
Question 34: You have an Azure data solution that contains an enterprise ...
Question 35: You have a version-8.0 Azure Database for MySQL database. Yo...
Question 36: Your company uses Azure Stream Analytics to monitor devices....
Question 37: A company plans to use Apache Spark analytics to analyze int...
Question 38: You have SQL Server on an Azure virtual machine. You review ...
Question 39: You are creating a new notebook in Azure Databricks that wil...
Question 40: Based on the PaaS prototype, which Azure SQL Database comput...
Question 41: You are developing an application that uses Azure Data Lake ...
Question 42: You have an Azure Data Factory pipeline that is triggered ho...
Question 43: You plan to move two 100-GB databases to Azure. You need to ...
Question 44: Note: This question is part of a series of questions that pr...
Question 45: From a website analytics system, you receive data extracts a...
Question 46: You are planning the migration of the SERVER1 databases. The...
Question 47: You need to apply 20 built-in Azure Policy definitions to al...
Question 48: You have an Always On availability group deployed to Azure v...
Question 49: You have an Azure virtual machine named VM1 on a virtual net...