Microsoft Azure

Microsoft Certified: Fabric Data Engineer Associate

DP-700

Achieve the Fabric Data Engineer Associate certification with the DP-700 exam.

150 questions 0 views Free

Start Mock Test Timed · Full-length · Scored

You are configuring a dataflow in Azure Data Factory. What does 'mapping data flow' allow you to do?

A Transform data in a graphical interface
B Schedule data pipelines easily
C Save all data to SQL databases
D Secure data with encryption at rest

Explanation Mapping data flow allows for transformations visually, while B is incorrect because scheduling isn't the focus here, C relates to data storage, and D concerns data security.

Q92

A company needs to ensure that its Azure SQL Database remains available even during maintenance. Which feature should the company use?

A Geo-replication for databases
B Azure SQL Database auto-failover groups
C Serverless mode for databases
D Dynamic scalability features

Explanation Auto-failover groups allow for high availability during maintenance, unlike A which is for disaster recovery, C is not related to maintenance, and D doesn't ensure availability.

Q93

What happens when you use Azure Synapse Analytics with dedicated SQL pool but forget to pause it after heavy usage?

A Your data will be deleted
B Costs will accrue based on usage
C The service will automatically pause
D Performance will degrade immediately

Explanation Costs accrue since the dedicated SQL pool remains in use, while A is incorrect as data doesn't get deleted, C is incorrect because auto-pause is not default, and D is not accurate immediately.

Q94

Which service can automate data movement in Azure?

A Azure Data Factory
B Azure Blob Storage
C Azure DevOps
D Azure Functions

Explanation Azure Data Factory is designed specifically for movement and transformation of data, unlike the other options that serve different purposes.

Q95

A company needs to store large amounts of unstructured data. Which Azure storage service is most suitable?

A Azure SQL Database
B Azure Cosmos DB
C Azure Blob Storage
D Azure Table Storage

Explanation Azure Blob Storage is optimized for handling large unstructured data, while other options are suited for structured data or specific types.

Q96

What happens when you set a data flow to use an incorrect sink transformation schema in Azure Data Factory?

A Data flow will abort
B Data will be truncated
C Transformation will ignore schema
D Data will be mapped differently

Explanation Setting an incorrect schema is a critical error, causing the data flow to abort rather than performing any data manipulation.

Q97

Which service is primarily used for real-time analytics in Azure?

A Azure Stream Analytics
B Azure Blob Storage
C Azure Data Lake
D Azure Functions

Explanation Azure Stream Analytics specializes in real-time data processing and analytics; the others do not focus on real-time analytics.

Q98

A company needs to store large amounts of unstructured data efficiently. Which Azure service should they use?

A Azure SQL Database
B Azure Cosmos DB
C Azure Blob Storage
D Azure Table Storage

Explanation Azure Blob Storage is ideal for unstructured data storage; the others cater to structured or semi-structured data.

Q99

You are configuring a data pipeline in Azure Data Factory. What happens when you set up a failure action on a specific activity?

A Pipeline fails immediately
B Action triggers upon failure
C Activity retries indefinitely
D Results are discarded

Explanation Setting a failure action allows you to define behavior when an activity fails; the other options misrepresent the outcome of a failure action.

Q100

Which service is best for building real-time analytics on streaming data?

A Azure Stream Analytics
B Azure Blob Storage
C Azure Data Lake
D Azure SQL Database

Explanation Azure Stream Analytics specializes in real-time data processing while the others are for storage or database tasks.