Dashboard / My courses / Exam DP-900 / General / TestPrep

Started on Thursday, 10 September 2020, 3 16 PM

State Finished
Completed on Thursday, 10 September 2020, 3 27 PM
Time taken 11 mins 11 secs
Grade 50.00 out of 50.00 (100%)
Question 1 You need to analyse data to know what occurred with the daily moving average DMA for past 45 days of stock financial data. Which type of
Correct analytics will you perform?
Mark 1.00 out
of 1.00 Select one:
a. Predictive Analytics
b. Diagnostic Analytics
c. Cognitive Analytics
d. Descriptive Analytics 

The correct answer is: Descriptive Analytics

Question 2 Your company needs a person to query the data stored in Azure SQL Database. Who do you think should do the task?
Correct
Mark 1.00 out Select one:
of 1.00 a. Database Administrator 

b. Data Engineer
c. AI Engineer
d. Data Scientist

The correct answer is: Database Administrator

Question 3 Your company needs to integrate chatbot that will respond to customers queries automatically on the company's website. Who should perform
Correct this task?
Mark 1.00 out
of 1.00 Select one:
a. AI Engineer 

b. Database Administrator
c. Data Engineer
d. Data Scientist

The correct answer is: AI Engineer

Question 4 Your company needs to train a model to predict the sales for the upcoming months. Who do you think should do this task?
Correct
Mark 1.00 out Select one:
of 1.00 a. Data Scientist 

b. Database Administrator
c. AI Engineer
d. Data Engineer

The correct answer is: Data Scientist

Question 5 Which among the following statement(s) is/are true with respect to Azure SQL database?
Correct
Mark 1.00 out Select one:
of 1.00 a. You need a Microsoft 365 subscription to create an Azure SQL Database
b. You must apply patches to the Azure SQL Databases regularly
c. None of the above
d. You can use existing Microsoft SQL Server licenses to reduce the cost of Azure SQL databases. 

The correct answer is: You can use existing Microsoft SQL Server licenses to reduce the cost of Azure SQL databases.

Question 6 Which of the following Azure Service uses the ARS (Atom Record Sequence) to store the data?
Correct
Mark 1.00 out Select one:
of 1.00 a. Azure Synapse Analytics
b. Azure File Storage
c. Azure Cosmos DB 

d. Azure Data Factory

The correct answer is: Azure Cosmos DB

Question 7 Which of the following Azure Service uses the hierarchichal namespace to store the data?
Correct
Mark 1.00 out Select one:
of 1.00 a. Azure Data Factory
b. Azure Data Lake Storage 

c. Azure Synapse Analytics

d. Azure Cosmos DB

The correct answer is: Azure Data Lake Storage

Question 8 Which of the following Azure Service uses the SMB 3.0 protocol?
Correct
Mark 1.00 out Select one:
of 1.00 a. Azure Cosmos DB
b. Azure Data Factory
c. Azure Synapse Analytics
d. Azure File Storage 

The correct answer is: Azure File Storage

Question 9 Which component of an Azure Data Factory can be triggered to run data ingestion tasks?
Correct
Mark 1.00 out Select one:
of 1.00 a. Linked Services
b. Datasets
c. Triggers
d. Pipelines 

The correct answer is: Pipelines

Question 10 A _______________ provides the information needed for Data Factory to connect to a source or destination.
Correct
Mark 1.00 out Select one:
of 1.00 a. Integration Runtime
b. Linked service 

c. Datasets
d. Pipelines

The correct answer is: Linked service

Question 11 In a Azure Data factory pipeline, you can use an ___________ activity to run an operation to modify and filter data, or an _________________ activity to
Correct run a notebook that performs more advanced processing.
Mark 1.00 out
of 1.00 Select one:
a. Azure Function, Azure Data Studio SQL Notebook
b. Azure Logic app, Azure Databricks Notebook
c. Azure Function, Azure Databricks Notebook 

d. Azure Logic app, Azure Data Studio SQL Notebook

The correct answer is: Azure Function, Azure Databricks Notebook

Question 12 Which Azure Data Factory component provides the compute environment for activities?
Correct
Mark 1.00 out Select one:
of 1.00 a. a control flow
b. an integration runtime 

c. a linked service
d. a pipeline

The correct answer is: an integration runtime

Question 13 In an Azure Data Factory, you can use ________________ to orchestrate the pipeline.
Correct
Mark 1.00 out Select one:
of 1.00 a. A Control Flow 

b. A Dataset
c. An Activity
d. An Integration Runtime

The correct answer is: A Control Flow

Question 14 Which Azure Data Factory component initiates the execution of a pipeline?
Correct
Mark 1.00 out Select one:
of 1.00 a. a parameter
b. a trigger 

c. a control flow
d. an activity

The correct answer is: a trigger

Question 15 You need to ensure that users use multi-factor authentication (MFA) when connecting to an Azure SQL database. Which type of authentication
Correct would you use?
Mark 1.00 out
of 1.00 Select one:
a. Azure Active Directory (Azure AD) authentication 

b. certificate authentication
c. SQL authentication
d. service principal authentication

The correct answer is: Azure Active Directory (Azure AD) authentication

Question 16 _______________ is a SQL-like query facility that you can use with an HDInsight cluster to examine data held in a variety of formats.
Correct
Mark 1.00 out Select one:
of 1.00 a. Polybase
b. Spark
c. PowerBI
d. Hive 

The correct answer is: Hive

Question 17 The bank needs to process the data every month to calculate payroll. Which of the following best categorizes the data?
Correct
Mark 1.00 out Select one:
of 1.00 a. Batch data 

b. Semi structured data

c. Streaming data
d. Encrypted data

The correct answer is: Batch data

Question 18 The organization needs to store employees personal detail in a format which cannot be read easily by anyone. To read the data, the person would
Correct need a key. What will be the category into which this data will fall into?
Mark 1.00 out
of 1.00 Select one:
a. Semi structured data
b. Batch data
c. Encrypted data 

d. Streaming data

The correct answer is: Encrypted data

Question 19 There is temperature sensor in a factory that needs to send temperature data continuously to the system to be processed further in real time.
Correct Which of the following best categorizes the data?
Mark 1.00 out
of 1.00 Select one:
a. Encrypted data
b. Semi structured data
c. Batch data
d. Streaming data 

The correct answer is: Streaming data

Question 20 Cosmos DB has multi API programming model support. Which among the following is suitable for contact tracing of coronavirus patients?
Correct
Mark 1.00 out Select one:
of 1.00 a. SQL API
b. Cassandra API
c. Gremlin API 

d. Table API

The correct answer is: Gremlin API

Question 21 Which among the following statements is true with respect to ETL process?
Correct
Mark 1.00 out Select one:
of 1.00 a. ETL process require target systems to transform the data being loaded.
b. ETL process have low load times 

c. ETL process reduces the resource contention on the source systems.

d. ETL process have very high load times

The correct answer is: ETL process have low load times
Question 22 Which API of cosmos DB can be used to work with column based data?
Correct
Mark 1.00 out Select one:
of 1.00 a. Gremlin
b. MongoDB
c. CassandraDB 

d. Table

The correct answer is: CassandraDB

Question 23 Which API of cosmos DB can be used to work with data which has many different entities that share relationship?
Correct
Mark 1.00 out Select one:
of 1.00 a. Table
b. Gremlin 

c. CassandraDB
d. MongoDB

The correct answer is: Gremlin

Question 24 Which API of cosmos DB can be used to work with data which is in the form of edges and vertices?
Correct
Mark 1.00 out Select one:
of 1.00 a. MongoDB
b. CassandraDB
c. Gremlin 

d. Table

The correct answer is: Gremlin

Question 25 The IT department of your company is managing the relational tables in the database for all departments. Each department must only see limited
Correct columns in the tables as per their needs. What they must use for the purpose?
Mark 1.00 out
of 1.00 Select one:
a. Sequences
b. Synonyms
c. Views 

d. Index

The correct answer is: Views

Question 26 Which of the following best defines 'relation'?

Correct
Mark 1.00 out Select one:
of 1.00 a. A table in a relational table. 

b. A row in a relational table.

c. A row in a non-relational table.
d. A column in a relational table.

The correct answer is: A table in a relational table.

Question 27  Which of the following is an example of semi-structured data?
Correct
Mark 1.00 out Select one:
of 1.00 a. A audio file.
b. A video file.
c. A XML file. 

d. A table in relational database.

The correct answer is: A XML file.

Question 28 Which of the following sentences best defines 'tuple' ?

Correct
Mark 1.00 out Select one:
of 1.00 a. A row in a relational table. 

b. A column in a non-relational table.

c. A row in a non-relational table.
d. A column in a relational table.

The correct answer is: A row in a relational table.

Question 29 Relational databases use _________________________ to enforce relationships between different data tables and _____________________ to enforce
Correct referential integrity.
Mark 1.00 out
of 1.00 Select one:
a. Keys, Foreign Key 

b. Partitions, logical partitions

c. Sequences, index
d. Columns, Domain constraints

The correct answer is: Keys, Foreign Key

Question 30 The airline company needs to update the prices of tickets based on customers feedback, fuel price and other factors. It analyses the data which
Correct gives the new prices of tickets. What type of analysis does this come under?
Mark 1.00 out
of 1.00 Select one:
a. Cognitive analysis
b. Predictive analysis
c. Diagnostic analysis
d. Prescriptive analysis 

The correct answer is: Prescriptive analysis

Question 31 The production workload is facing issue of surplus goods. You need to analyse the historical data to determine the requirement for the next
Correct month. What type of analysis does this come under ?
Mark 1.00 out
of 1.00 Select one:
a. Cognitive analysis
b. Prescriptive analysis
c. Predictive analysis 

d. Diagnostic analysis

The correct answer is: Predictive analysis

Question 32 The production workload is facing technical issue with one of the server. You need to collect the logs and analyze the logs to determine the root
Correct cause of the issue. What type of analysis would you perform?
Mark 1.00 out
of 1.00 Select one:
a. Diagnostic analysis 

b. Predictive analysis
c. Prescriptive analysis
d. Cognitive analysis

The correct answer is: Diagnostic analysis

Question 33 Which service in Azure can be used to process the data in real time having three components: input, query and output?
Correct
Mark 1.00 out Select one:
of 1.00 a. Stream Analytics Job 

b. Synapse Analytics
c. Azure Databricks
d. IoT hub
e. Event hub

The correct answer is: Stream Analytics Job

Question 34 Your company needs to implement a relational database in Azure. The solution must minimize ongoing maintenance. Which Azure service would
Correct you use?
Mark 1.00 out
of 1.00 Select one:
a. SQL Server on Azure virtual machines
b. Azure HDInsight
c. Azure SQL Database 

d. Azure Cosmos DB

The correct answer is: Azure SQL Database

Question 35 Which statement would you use to include another column in the table schema in a relational database?
Correct
Mark 1.00 out Select one:
of 1.00 a. ALTER 

b. INSERT
c. UPDATE
d. TRUNCATE

The correct answer is: ALTER

Question 36 You have big data stored in data warehouse. You need to process the data in Azure Synapse Analytics. Which technology would you use?
Correct
Mark 1.00 out Select one:
of 1.00 a. RPP
b. CPP
c. APP
d. MPP 

The correct answer is: MPP

Question 37 You have data stored in ADLS in text format. You need to load the data in Azure Synapse Analytics in a table in one of the database. Which
Correct technology would you use for the purpose?
Mark 1.00 out
of 1.00 Select one:
a. Polytech
b. Polybase 

c. Polyload
d. Polyglot

The correct answer is: Polybase

Question 38 Which command-line tool would you use to query Azure SQL databases?
Correct
Mark 1.00 out Select one:
of 1.00 a. Azure CLI 

b. azdata
c. bcp
d. sqlcmd

The correct answer is: Azure CLI

Question 39 Which of the following tool can be used to access data stored in Azure Storage Account?
Correct
Mark 1.00 out Select one:
of 1.00 a. SQL Server Data Tools
b. SQL Server Management Studio
c. Azure Storage Explorer 

d. Azure Data Studio

The correct answer is: Azure Storage Explorer

Question 40 Which of the following tool is UI based and is required to complete tasks in Azure?
Correct
Mark 1.00 out Select one:
of 1.00 a. Azure CLI
b. Azure Cloud Shell
c. Azure Powershell
d. Azure Portal 

The correct answer is: Azure Portal

Question 41 Which of the following tools can be used in MacOS to access data stored in Azure SQL Database?
Correct
Mark 1.00 out Select one:
of 1.00 a. Azure Data Studio 

b. Azure Storage Explorer

c. SQL Server Data Tools
d. SQL Server Management Studio

The correct answer is: Azure Data Studio

Question 42 Which of the following component is used to get messages from twitter client to Azure?
Correct
Mark 1.00 out Select one:
of 1.00 a. IoT Hub
b. ADF
c. Azure Blob
d. Event Hub 

The correct answer is: Event Hub

Question 43 Which of the following is not an example of Data Manipulation Language?

Correct
Mark 1.00 out Select one:
of 1.00 a. UPDATE
b. ALTER 

c. DELETE
d. INSERT

The correct answer is: ALTER

Question 44 You have a transactional workload running on a relational database system. You need to remove all DML anomalies which hamper the integrity of
Correct the databases. What would you do in such a scenario?
Mark 1.00 out
of 1.00 Select one:
a. De-normalize the tables as much as possible
b. Normalize the tables as much as possible 

c. Remove relationships in the tables

d. Block all DML queries

The correct answer is: Normalize the tables as much as possible

Question 45 Which among the following statement(s) is/are true with respect to Azure SQL database?
Correct
Mark 1.00 out
of 1.00 a. Azure SQL Database has built in high availability


b. Azure SQL Database allows independent provisioning of throughput and storage



c. Azure SQL Database includes a fully managed backup service



d. Azure SQL Database is fully compatible with Microsoft SQL server

Your answer is correct.

The correct answers are: Azure SQL Database includes a fully managed backup service, Azure SQL Database has built in high availability, Azure
SQL Database allows independent provisioning of throughput and storage

Question 46 Which of the two Azure services can be used to provision Apache Spark clusters?
Correct
Mark 1.00 out
of 1.00 a. Azure HDInsight 


b. Azure Databricks


c. Azure Time Series Insights

d. Azure Log Analytics

Your answer is correct.

The correct answers are: Azure HDInsight , Azure Databricks
Question 47 Which are the two services in Azure that can be used to ingest the data?
Correct
Mark 1.00 out
of 1.00 a. Synapse Analytics

b. Stream Analytics Job

c. Event hub


d. Azure Databricks

e. IoT hub


Your answer is correct.

The correct answers are: IoT hub, Event hub

Question 48 Which are the two services in Azure that can be used to process the data?
Correct
Mark 1.00 out
of 1.00 a. Azure blob storage

b. Synapse Analytics


c. IoT hub

d. Stream Analytics Job



e. Event hub

Your answer is correct.

The correct answers are: Synapse Analytics, Stream Analytics Job
Question 49 You need to access the server where your data is stored in relational database in Azure SQL Database. Which are the 3values you need to access
Correct the server?
Mark 1.00 out
of 1.00
a. Server's Password


b. Server's Username


c. Server's Access Key

d. Server's FQDN


e. Server's Role

Your answer is correct.

The correct answers are: Server's FQDN, Server's Username, Server's Password

Question 50 You have data stored in ADLS in text format. You need to load the data in Azure Synapse Analytics in a table in one of the database. Which are the
Correct two components that you should define in order to use polybase?
Mark 1.00 out
of 1.00
a. Internal format

b. Internal source

c. External source


d. External format


Your answer is correct.

The correct answers are: External format, External source

◀ Announcements Jump to...