Microsoft Azure Data Fundamentals291 questions across 30 pages are complete and free, with no account or card.
291 questions in this bank
Free access · progress saved on this device
You need to query a table named Products in an Azure SQL database. Which three requirements must be met to query the table from the internet? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
Answer: BCE
Which three services support Apache Spark? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
Answer: BCE
Which clause should you use in a SELECT statement to combine rows in one table with rows in another table?
Answer: D
Your company needs to ensure that an Azure virtual machine can connect to Azure SQL databases without exposing the databases to the internet. What should you use?
Answer: D
DRAG DROP - Match the Azure SQL services to the appropriate use cases. To answer, drag the appropriate service from the column on the left to its use case on the right. Each service may be used once, more than once, or not at all. NOTE: Each correct match its worth one point. Select and Place:
This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.
Answer: See figure below
Box 1: Azure SQL Database single database Serverless is a compute tier for single databases in Azure SQL Database that automatically scales compute based on workload demand and bills for the amount of compute used per second. The serverless compute tier also automatically pauses databases during inactive periods when only storage is billed and automatically resumes databases when activity returns. Scenarios well suited for serverless compute Single databases with intermittent, unpredictable usage patterns interspersed with periods of inactivity, and lower average compute utilization over time. Single databases in the provisioned compute tier that are frequently rescaled and customers who prefer to delegate compute rescaling to the service. New single databases without usage history where compute sizing is difficult or not possible to estimate prior to deployment in SQL Database. Box 2: Azure SQL Managed Instance Azure SQL Managed Instance is the intelligent, scalable cloud database service that combines the broadest SQL Server database engine compatibility with all the benefits of a fully managed and evergreen platform as a service. Box 3: Azure SQL Database elastic pool Azure SQL Database elastic pools are a simple, cost-effective solution for managing and scaling multiple databases that have varying and unpredictable usage demands. The databases in an elastic pool are on a single server and share a set number of resources at a set price. Elastic pools in SQL Database enable software as a service (SaaS) developers to optimize the price performance for a group of databases within a prescribed budget while delivering performance elasticity for each database. Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-overview?view=azuresql https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-overview?view=azuresql https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/sql-managed-instance-paas-overview
Source: Adapted from community discussion — brainiacATH
You have data in a tabular format as shown in the following table.
Of which type of data is this an example?
Answer: D
What can you use to create data ingestion pipelines?
Answer: C
Which service is optimized for IoT scenarios that involve streaming time series data?
Answer: D
What is the responsibility of a database administrator?
Answer: D
You have the following T-SQL statement. SELECT o.OrderNo, o.OrderDate, c.Address, c.City FROM Order AS o - JOIN Customer AS c - ON o.Customer = c.ID; What is the function of the ON clause?
Answer: B
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
DP-900 practice, question 281. 291 questions available.
Version 1.0.0. How we source questions