The purpose of this Sample Question Set is to provide you with information about the Microsoft Azure Data Fundamentals exam. These sample questions will make you very familiar with both the type and the difficulty level of the questions on the DP-900 certification test. To get familiar with real exam environment, we suggest you try our Sample Microsoft Azure Data Fundamentals Certification Practice Exam. This sample practice exam gives you the feeling of reality and is a clue to the questions asked in the actual Microsoft Certified - Azure Data Fundamentals certification exam.
These sample questions are simple and basic questions that represent likeness to the real Microsoft DP-900 exam questions. To assess your readiness and performance with real time scenario based questions, we suggest you prepare with our Premium Microsoft Azure Data Fundamentals Certification Practice Exam. When you solve real time scenario based questions practically, you come across many difficulties that give you an opportunity to improve.
Microsoft DP-900 Sample Questions:
01. A team of developers has computers Thai run Windows 10 and Ubuntu Desktop. The developers need to connect to and query an Azure SCX database from the computers. The developers require code assistance features such as intellSense.
What should the developers use?
a) Azure Data Explorer
c) Azure Data Studio
d) Microsoft SQL Server Management Studio (SSMS)
02. You have a quality assurance application that reads data from a data warehouse. Which type of processing does the application use?
a) Online Transaction Processing (OLTP)
b) batch processing
c) Online Analytical Processing (OLAP)
d) stream processing
03. Which Azure storage solution provides native support for POSIX-compliant access control lists (ACLs)?
a) Azure table storage
b) Azure Files
c) Azure Queue storage
d) Azure Data Lake Storage
04. 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
05. At which level in Azure Cosmos DB can you configure multiple write regions and read regions?
06. Which Azure Data Factory component initiates the execution of a pipeline?
a) a control flow
b) a trigger
c) a parameter
d) an activity
07. What do you use to create Power BI paginated reports?
Choose the correct answer
a) Power BI Report Builder
b) Power BI Dashboard
c) Power BI Desktop
d) Power BI service
08. When provisioning an Azure Cosmos DB account, which feature provides redundancy within an Azure region?
a) multi-master replication
b) Availability Zones
c) automatic failover
d) the strong consistency level
09. Which Azure Data Factory component provides the compute environment for activities?
a) a linked service
b) an integration runtime
c) a control flow
d) a pipeline
10. 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
Note: For any error in Microsoft Certified - Azure Data Fundamentals (DP-900) certification exam sample questions, please update us by writing an email on email@example.com.