DP-900 pt 4

Relational data uses ​ (a)   to enforce relationship of different tables

• keys
• collections
• rows
• partitions

Which statement should you use in a SQL query to change the inventory quantity of Product1 to 270?

• INSERT

• UPDATE

• MERGE

• CREATE

Your company needs to implement a relational database in Azure. The solution must minimize ongoing maintenance. Which Azure service should you use?

• Azure HDInsight

• Azure SQL Database

• Azure Cosmos DB

• SQL Server on Azure Virtual Machines

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?

• . Microsoft SQL Server Management Studio (SSMS)

• Azure Data Studio

• . Azure CLI

• Azure PowerShell

Match the terms to the appropriate descriptions.

a

b

c

table

index

view

You have an e-commerce application that reads and writes data to an Azure SQL database. Which type of processing does the application use?

• stream processing

• . batch processing

• Online Analytical Processing (OLAP)

• Online Transaction Processing (OLTP)

When can you use an Azure Resource Manager template?

• to automate the creation of an interdependent group of Azure resources in a repeatable way

• . to apply Azure policies for multi-tenant deployments

• to provision Azure subscriptions

• to control which services and feature administrators and developers can deploy from the Azure portal

You have an Azure SQL database that you access directly from the Internet. You recently changed the public IP address of your computer. After changing the IP address, you can no longer access the database. You can connect to other resources in Azure. What is a possible cause of the issue?

• role-based access control (RBAC)

• Dynamic Host Configuration Protocol (DHCP)

• Domain Name Service (DNS)

• a database-level firewall

Match the tools to the appropriate descriptions

b

a

c

Microsoft SQL Server Data Tools

Microsoft SQL Server Management Studio

Azure Data Studio

• yes

• no