Valid DP-200 Dumps shared by ExamDiscuss.com for Helping Passing DP-200 Exam! ExamDiscuss.com now offer the newest DP-200 exam dumps, the ExamDiscuss.com DP-200 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com DP-200 dumps with Test Engine here:
Access DP-200 Dumps Premium Version
(242 Q&As Dumps, 35%OFF Special Discount Code: freecram)
<< Prev Question Next Question >>
Question 31/84
A company runs Microsoft SQL Server in an on-premises virtual machine (VM).
You must migrate the database to Azure SQL Database. You synchronize users from Active Directory to Azure Active Directory (Azure AD).
You need to configure Azure SQL Database to use an Azure AD user as administrator. What should you configure?
You must migrate the database to Azure SQL Database. You synchronize users from Active Directory to Azure Active Directory (Azure AD).
You need to configure Azure SQL Database to use an Azure AD user as administrator. What should you configure?
Correct Answer: C
There are two administrative accounts (Server admin and Active Directory admin) that act as administrators.
One Azure Active Directory account, either an individual or security group account, can also be configured as an administrator. It is optional to configure an Azure AD administrator, but an Azure AD administrator must be configured if you want to use Azure AD accounts to connect to SQL Database.
References:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-manage-logins
One Azure Active Directory account, either an individual or security group account, can also be configured as an administrator. It is optional to configure an Azure AD administrator, but an Azure AD administrator must be configured if you want to use Azure AD accounts to connect to SQL Database.
References:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-manage-logins
- Question List (84q)
- Question 1: You plan to use Microsoft Azure SQL Database instances with ...
- Question 2: You are creating a new notebook in Azure Databricks that wil...
- Question 3: You have an Azure virtual machine that has Microsoft SQL Ser...
- Question 4: A company manages several on-premises Microsoft SQL Server d...
- Question 5: Use the following login credentials as needed: Azure Usernam...
- Question 6: Note: This question is part of a series of questions that pr...
- Question 7: Note: This question is part of series of questions that pres...
- Question 8: You need to ensure polling data security requirements are me...
- Question 9: You plan to monitor the performance of Azure Blob storage by...
- Question 10: You need to implement event processing by using Stream Analy...
- Question 11: Use the following login credentials as needed: Azure Usernam...
- Question 12: Use the following login credentials as needed: Azure Usernam...
- Question 13: You create an Azure Databricks cluster and specify an additi...
- Question 14: You are creating a managed data warehouse solution on Micros...
- Question 15: You have an Azure SQL database that has masked columns. You ...
- Question 16: Note: This question is part of a series of questions that pr...
- Question 17: Note: This question is part of a series of questions that pr...
- Question 18: You have two Azure Storage accounts named Storage1 and Stora...
- Question 19: You need to ensure that phone-based polling data can be anal...
- Question 20: You are developing a data engineering solution for a company...
- Question 21: The data engineering team manages Azure HDInsight clusters. ...
- Question 22: Note: This question is part of series of questions that pres...
- Question 23: Note: This question is part of series of questions that pres...
- Question 24: You have an enterprise data warehouse in Azure Synapse Analy...
- Question 25: Note: This question is part of a series of questions that pr...
- Question 26: How should you monitor SALESDB to meet the technical require...
- Question 27: You need to implement event processing by using Stream Analy...
- Question 28: You manage security for a database that supports a line of b...
- Question 29: You are a data architect. The data engineering team needs to...
- Question 30: You develop data engineering solutions for a company. A proj...
- Question 31: A company runs Microsoft SQL Server in an on-premises virtua...
- Question 32: Note: This question is part of a series of questions that pr...
- Question 33: Note: This question is part of a series of questions that pr...
- Question 34: Use the following login credentials as needed: Azure Usernam...
- Question 35: You have the following Azure Stream Analytics query. (Exhibi...
- Question 36: You have an Azure subscription that contains a logical Micro...
- Question 37: Use the following login credentials as needed: Azure Usernam...
- Question 38: A company plans to use Platform-as-a-Service (PaaS) to creat...
- Question 39: You have a SQL pool in Azure Synapse. You discover that some...
- Question 40: Use the following login credentials as needed: Azure Usernam...
- Question 41: Your company manages on-premises Microsoft SQL Server pipeli...
- Question 42: You are implementing an Azure Blob storage account for an ap...
- Question 43: Note: This question is part of a series of questions that pr...
- Question 44: You are building an Azure Stream Analytics query that will r...
- Question 45: A company is planning to use Microsoft Azure Cosmos DB as th...
- Question 46: You have an Azure Synapse Analytics SQL pool named Pool1 on ...
- Question 47: You have an Azure SQL database named DB1 in the Each US 2 re...
- Question 48: You are monitoring the Data Factory pipeline that runs from ...
- Question 49: Use the following login credentials as needed: Azure Usernam...
- Question 50: You have an Azure SQL database that contains a table named C...
- Question 51: You are developing the data platform for a global retail com...
- Question 52: You have an enterprise-wide Azure Data Lake Storage Gen2 acc...
- Question 53: You have the following Azure Stream Analytics query. (Exhibi...
- Question 54: Use the following login credentials as needed: Azure Usernam...
- Question 55: You develop data engineering solutions for a company. The co...
- Question 56: Use the following login credentials as needed: Azure Usernam...
- Question 57: You are building the data store solution for Mechanical Work...
- Question 58: You are developing a solution that will stream to Azure Stre...
- Question 59: Your company manages a payroll application for its customers...
- Question 60: You plan to create a dimension table in Azure Data Warehouse...
- Question 61: You have an Azure Synapse Analytics dedicated SQL pool that ...
- Question 62: You develop data engineering solutions for a company. A proj...
- Question 63: Note: This question is part of series of questions that pres...
- Question 64: Note: This question is part of a series of questions that pr...
- Question 65: Which masking functions should you implement for each column...
- Question 66: Use the following login credentials as needed: Azure Usernam...
- Question 67: Use the following login credentials as needed: Azure Usernam...
- Question 68: Use the following login credentials as needed: Azure Usernam...
- Question 69: You are implementing automatic tuning mode for Azure SQL dat...
- Question 70: You need to process and query ingested Tier 9 data. Which tw...
- Question 71: What should you implement to optimize SQL Database for Race ...
- Question 72: You have an Azure subscription that contains the following r...
- Question 73: Note: This question is part of a series of questions that pr...
- Question 74: You implement an event processing solution using Microsoft A...
- Question 75: You are a data engineer. You are designing a Hadoop Distribu...
- Question 76: Use the following login credentials as needed: Azure Usernam...
- Question 77: Note: This question is part of a series of questions that pr...
- Question 78: You implement an Azure SQL Data Warehouse instance. You plan...
- Question 79: You are building an Azure Stream Analytics job that queries ...
- Question 80: Note: This question is part of a series of questions that pr...
- Question 81: You develop data engineering solutions for a company. An app...
- Question 82: You have an ASP.NET web app that uses an Azure SQL database....
- Question 83: You have an enterprise data warehouse in Azure Synapse Analy...
- Question 84: You have an Azure SQL server named Server1 that hosts two de...
