Which statement is an example of Data Definition Language (DDL)?
Which statement is an example of Data Definition Language (DDL)? A. SELECT B. JOIN C. MERGE D. CREATE Reference: https://www.geeksforgeeks.org/difference-between-ddl-and-dml-in-dbms/
Which command-line tool can you use to query Azure SQL databases?
Which command-line tool can you use to query Azure SQL databases? A. sqlcmd B. bcp C. azdata D. Azure CLI Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/az-cli-script-samples-content-guide?tabs=single-database
What should you use?
You are writing a set of SQL queries that administrators will use to troubleshoot an Azure SQL database. You need to embed documents and query results into a SQL notebook. What should you use? A. Microsoft SQL Server Management Studio (SSMS) B. Azure Data Studio C. Azure CLI D. Azure PowerShell Reference: https://www.mssqltips.com/sqlservertip/5997/create-sql-server-notebooks-in-azure-data-studio/
Which Azure service should you use?
Your company needs to implement a relational database in Azure. The solution must minimize ongoing maintenance. Which Azure service should you use? A. Azure HDInsight B. Azure SQL Database C. Azure Cosmos DB D. SQL Server on Azure virtual machines Reference: https://azure.microsoft.com/en-us/services/sql-database/#features
What is the result of the policy?
You have an Azure Active Directory (Azure AD) tenant and Windows 10 devices. You configure a conditional access policy as shown in the exhibit. (Click the Exhibit tab.) What is the result of the policy? A. All users will always be prompted for multi-factor authentication (MFA). B. Users will be prompted for multi-factor authentication (MFA) […]
What should you include in the recommendation?
You have an Azure Active Directory (Azure AD) tenant. You plan to deploy Azure Cosmos DB databases that will use the SQL API. You need to recommend a solution to provide specific Azure AD user accounts with read access to the Cosmos DB databases. What should you include in the recommendation? A. shared access signatures […]
To which three scopes can you assign Azure Policy definitions?
You are designing a large Azure environment that will contain many subscriptions. You plan to use Azure Policy as part of a governance solution. To which three scopes can you assign Azure Policy definitions? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point. A. management groups B. subscriptions C. […]
Which type of identity should you include in the recommendation?
You plan to deploy an application named App1 that will run on five Azure virtual machines. Additional virtual machines will be deployed later to run App1. You need to recommend a solution to meet the following requirements for the virtual machines that will run App1: • Ensure that the virtual machines can authenticate to Azure […]
What should you include in the identity management strategy to support the planned changes?
Case Study This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions […]
You need to ensure that when a department reaches its spending limit, the compute resources of the department
You have an Azure subscription that is linked to an Azure Active Directory (Azure AD) tenant. The subscription contains 10 resource groups, one for each department at your company. Each department has a specific spending limit for its Azure resources. You need to ensure that when a department reaches its spending limit, the compute resources […]