PrepAway - Latest Free Exam Questions & Answers

Category: DP-900

Exam DP-900: Microsoft Azure Data Fundamentals (beta)

What should you use?

You need to design and model a database by using a graphical tool that supports project-oriented offline database development. What should you use? A. Microsoft SQL Server Data Tools (SSDT) B. Microsoft SQL Server Management Studio (SSMS) C. Azure Databricks D. Azure Data Studio Reference: https://docs.microsoft.com/en-us/sql/ssdt/project-oriented-offline-database-development?view=sql-server-ver15

What is a benefit of hosting a database on Azure SQL managed instance as compared to an Azure SQL database?

What is a benefit of hosting a database on Azure SQL managed instance as compared to an Azure SQL database? A. built-in high availability B. native support for cross-database queries and transactions C. system-initiated automatic backups D. support for encryption at rest Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/features-comparison

Which type of authentication should you use?

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? A. service principal authentication B. Azure Active Directory (Azure AD) authentication C. SQL authentication D. certificate authentication Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/authentication-mfa-ssms-overview

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/