D900_2

Which component of an Azure Data Factory can be triggered to run data ingestion tasks?

• ​CSV File

• ​Pipeline

• ​Linked service

Review the data model and answer following question:

The data model is:

• ​star schema

• ​transactional model

• ​snowflake scheme

Which of these services can be used to ingest data into Azure Synapse Analytics?

• ​Azure Data Factory

• ​Power BI

• Azure Active Directory

Review the data model and answer the following:

Product is an example of ----------- table

• ​dimension

• fact

• bridge

You have an inventory management database. Which statement should you use in a SQL query to change the inventory quantity of Product1 to 270?

• ​INSERT

• MERGE

• UPDATE

• CREATE

Transcribing an audio file is an example of:

• predictive

• ​prescriptive

• ​descriptive

• ​cognitive

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

• ​descriptive

• diagnostic

• ​predictive

• ​prescriptive

You have an e-commerce application that reads and writes data to an Azure SQL database. Which type of processing does the application use?

• ​stream processing

• ​batch processing

• ​Online Analytical Processing (OLAP)

• Online Transaction Processing (OLTP)

For each of the following statements, select all that are true?

• ​Azure Data Studio can be used to query an Azure SQL database from a device that run on macOS

• Sql Server Management Studio (SSMS) enable users to create and use SQL Noteboooks

• Azure Data Studio can be used to restore Database

• ​Azure Databricks is based on apache spark

Select all that is True

• ​An Azure Data Factory pipeline can pass parameters to a notebook ?

• ​Databricks can process data held in many different types of storage, including Azure Blob storage, Azure Data Lake Store, Hadoop storage, flat files, SQL databases, and data warehouses, and Azure services such as Cosmos DB ?

• Imagine that you're part of a team that is analyzing house price data. The dataset that you receive contains house price information for several regions. Your team needs to report on how the house prices in each region have varied over the last few months. To achieve this, you need to ingest the data into Azure Synapse Analytics. You've decided to use Azure Datawarehouse to perform this task.