D900_3

The massive parallel processing (MPP) of Azure synapse analytics ------------

• distributes processing across compute nodes

• distributes processing across control nodes

• redirects client connections across compute nodes

• ​redirects client connections across control nodes

An object associated with a table that sorts and stores the data rows in a table based on their keys

• Clustered Index

• Primary Key

• ​Foreign Key

• ​Stored procedure

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

Select all that is TRUE:

• Azure SQL Database has a fully managed backup service

• Azure SQL Database has built in availability ​Azure SQL

• Database can use Azure Advanced Threat Protection

Select all that is TRUE

• You must apply patches to Azure SQL database regularly

• You need Microsoft 365 subscription to create Azure SQL database

• You can use existing Microsoft server licenses to reduce the cost of Azure SQL database

You have following query:

Larger imageWhat is dbo.Products and ProductName in the above query

• ​dbo.Products - database

  ProductName - index

• dbo.Products - table

  ProductName - column

• dbo.Products -column

  ProductName - table

• ​dbo.Products - index

  ProductName - column

You need to ensure that users use multi-factor authentication (MFA) when connecting to an Azure SQL database.

Which type of authentication should you use?

• ​service principal authentication

• Azure Active Directory (Azure AD) authentication

• ​SQL authentication

• ​certificate authentication

Below chart is shown to show after Q3 results

What type of analysis is shown here:

• ​predictive

• prescription

• ​descriptive

• ​diagnostic

What are two characteristics of real-time data processing? Each correct answer present a complete solution.

• ​Data is processed as it is created.

• Low latency is expected

• High latency acceptable

• ​Data is processed periodically

What are two uses of data visualization? Each correct answer present a complete solution.

• ​Represent trends and patterns over time

• ​implement machine learning to predict future values.

• Communicate the significance of data.

• Consistently implement business logic across reports.