Close
Exercise : Exam DP 900 Microsoft Azure Data Fundamentals MCQ Questions and Answers

Question 1

DRAG DROP -
Match the types of workloads to the appropriate scenarios.
To answer, drag the appropriate workload type from the column on the left to its scenario on the right. Each workload type may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Select and Place:

A.  
B.  
C.  
D.  

Correct Answer : C. Batch, Streaming, Batch

Description :

Answer: Box 1: Batch -
Batch processing refers to the processing of blocks of data that have already been stored over a period of time.

Box 2: Streaming -
Stream processing is a big data technology that allows us to process data in real-time as they arrive and detect conditions within a small period of time from the point of receiving the data. It allows us to feed data into analytics tools as soon as they get generated and get instant analytics results.

Box 3: Batch -
Reference:
https://docs.microsoft.com/en-us/azure/architecture/data-guide/technology-choices/batch-processing

Question 2

Which Azure Data Factory component provides the compute environment for activities?

A.  
B.  
C.  
D.  

Correct Answer : C. an integration runtime

Description :
The Integration Runtime (IR) is the compute infrastructure used by Azure Data Factory to provide the following data integration capabilities across different network environments:
➠ Data Flow
➠ Data movement
➠ Activity dispatch
➠ SSIS package execution
Reference:
https://docs.microsoft.com/en-us/azure/data-factory/concepts-integration-runtime

Question 3

DRAG DROP -
Match the datastore services to the appropriate descriptions.
To answer, drag the appropriate service from the column on the left to its description on the right. Each service may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Select and Place:

A.  
B.  
C.  
D.  

Correct Answer : A. Azure Cosmos DB, Azure Files

Description :


Box 1: Azure Cosmos DB -
In Azure Cosmos DB's SQL (Core) API, items are stored as JSON. The type system and expressions are restricted to deal only with JSON types.
Box 2: Azure Files -
Azure Files offers native cloud file sharing services based on the SMB protocol.
Reference:
https://docs.microsoft.com/en-us/azure/cosmos-db/sql-query-working-with-json
https://cloud.netapp.com/blog/azure-smb-servermessage-block-in-the-cloud-for-azure-files

Question 4

You need to use Transact-SQL to query files in Azure Data Lake Storage from an Azure Synapse Analytics data warehouse.
What should you use to query the files?

A.  
B.  
C.  
D.  

Question 5

What are two benefits of platform as a service (PaaS) relational database offerings in Azure, such as Azure SQL Database? Each Answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A. access to the latest features
B. complete control over backup and restore processes
C. in-database machine learning services
D. reduced administrative effort for managing the server infrastructure

A.  
B.  
C.  
D.  

Correct Answer : A. AD

Description :
A: Azure SQL Database is a fully managed platform as a service (PaaS) database engine that handles most of the database management functions such as upgrading, patching, backups, and monitoring without user involvement.
D: SQL Database delivers predictable performance with multiple resource types, service tiers, and compute sizes. It provides dynamic scalability with no downtime, built-in intelligent optimization, global scalability and availability, and advanced security options. These capabilities allow you to focus on rapid app development and accelerating your time-to-market, rather than on managing virtual machines and infrastructure.
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview

Question 6

DRAG DROP -
Match the tools to the appropriate descriptions.
To answer, drag the appropriate tool from the column on the left to its description on the right. Each tool may be used once, more than once, or not at all.
Select and Place:

A.  
B.  
C.  
D.  

Correct Answer : A. Microsoft SQL Server Management Studio (SSMS), Microsoft Visual Studio Code, Azure Data Studio, Microsoft SQL Server Data Tools (SSDT)

Description :

Box 1: Microsoft SQL Server Management Studio (SSMS)
SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database.
Box 2: Microsoft Visual Studio Code
Visual Studio Code is a streamlined code editor with support for development operations like debugging, task running, and version control. It aims to provide just the tools a developer needs for a quick code-build-debug cycle and leaves more complex workflows to fuller featured IDEs, such as Visual Studio IDE.
Box 3: Azure Data Studio -
Azure Data Studio offers a modern, keyboard-focused SQL coding experience that makes your everyday tasks easier with built-in features, such as multiple tab windows, a rich SQL editor, IntelliSense, keyword completion, code snippets, code navigation, and source control integration (Git). Run on-demand SQL queries, view and save results as text, JSON, or Excel. Edit data, organize your favorite database connections, and browse database objects in a familiar object browsing experience.
Box 4: Microsoft SQL Server Data Tools (SSDT)
SQL Server Data Tools (SSDT) is a modern development tool for building SQL Server relational databases, databases in Azure SQL, Analysis Services (AS) data models, Integration Services (IS) packages, and Reporting Services (RS) reports. With SSDT, you can design and deploy any SQL Server content type with the same ease as you would develop an application in Visual Studio.
Reference:
https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms
https://code.visualstudio.com/docs/supporting/FAQ https://docs.microsoft.com/en-us/sql/azure-data-studio/what-is-azure-datastudio
https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt

Question 7

A bar chart showing year-to date sales by region is an example of which type of analytics?

A.  
B.  
C.  
D.  

Correct Answer : A. diagnostic

Description :
No answer description available for this question. Let us discuss.

Question 8

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

A.  
B.  
C.  
D.  

Correct Answer : B. native support for cross-database queries and transactions

Description :
Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/features-comparison

Question 9

You need to develop a solution to provide data to executives. The solution must provide an interactive graphical interface, depict various key performance indicators, and support data exploration by using drill down.
What should you use in Microsoft Power BI?

A.  
B.  
C.  
D.  

Question 10

HOTSPOT -
To complete the sentence, select the appropriate option in the answer area.
Hot Area:

A.  
B.  
C.  
D.  

Correct Answer : A. transactional writes

Description :

Answer: Disadvantages of non-relational databases include: Data Consistency non-relational databases do not perform ACID transactions. Note: Relational databases are optimized for writes. They are optimized for consistency and availability. Advantages of relational databases include simplicity, ease of data retrieval, data integrity, and flexibility.
InAnswers:
Use a relational database when data that you work with is structured, and the structure is not subject to frequent changes. Use Cloud storage (no relational database) for geographically distributed writes. Reference:
https://towardsdatascience.com/choosing-the-right-database-c45cd3a28f77

Search Current Affairs by date
Other Category List