Identify considerations for relational data on Azure Questions
Practice questions for Identify considerations for relational data on Azure topic in Microsoft Certified: Azure Data Fundamentals. 48 questions covering this domain.
A developer needs to add a new sales row to a relational table. Which SQL statement should be used?
A developer wants reusable database-side logic that can be executed repeatedly on demand. Which database object should be used?
A team wants to expose a saved query result to users without duplicating the underlying table data. Which database object is the best fit?
Which statement best describes relational data?
A team has a PostgreSQL-based application and wants a fully managed Azure service built for PostgreSQL workloads. Which service fits?
Why is normalization used in relational databases?
An application requires distributed transactions and specifically needs traditional MSDTC support in Azure. Which relational Azure option is the best ...
A company runs an existing MySQL application and wants a managed Azure database service that uses the community version of MySQL with minimal refactor...
Which SQL statement is commonly used to retrieve data from a table?
A development team wants a managed Microsoft SQL relational database in Azure and does not want to maintain the underlying operating system. Which ser...
A company wants to run Microsoft SQL Server in Azure and keep control of the operating system and virtual machine. Which option should it use?
Which service is part of the Azure SQL family named in the DP-900 study guide?
Which Azure SQL Database service tier is designed for very large databases (up to 100 TB) with rapid scale-out reads via read replicas?
Which Azure SQL Database purchase model bundles compute, memory, storage, and IO into pre-configured tiers?
A team wants automatic point-in-time restore capability for an Azure SQL Database. Which built-in feature provides this?
A team needs zone-redundant high availability for Azure SQL Database within a single region. Which configuration achieves this?
Which Azure SQL Database deployment option scales compute up/down or pauses automatically based on workload to reduce cost during idle periods?
Which Azure service is recommended for migrating an existing on-premises SQL Server database with near-100% feature compatibility while keeping a mana...
A developer wants to query an Azure SQL Database using a graphical tool with IntelliSense, query plans, and schema browsing. Which client tool is most...
Which statement about a primary key in a relational table is correct?
Sign in to see all 48 questions
Create a free account to browse all questions — completely free during our launch phase.