Azure Data Fundamental DP-900 MCQ Question Answer
Azure Data Fundamental DP-900 MCQ Question Answer
1. What
types of threats does Advanced Threat Protection protect your SQL Database
against?
- SQL Injection, Potential data infiltration, and brute force attacks
2. You have a small 25MB database currently hosted
in AWS DynamoDB that you'd like to move to Azure Cosmos DB. You've chosen Core
SQL API as the database type. Which is the best database migration tool or
technique to get data from AWS DynamoDB to Azure CosmosDB?
- Data Migration Tool
3. Data Definition Language (DDL) primarily does
what?
- Define data Structures
4. What type of malicious attack attempts to read
database values using form fields on a web site?
SQL Injection Attack
5. In an Azure Data Factory, a ___________ is a
logical grouping of activities that together perform a task. Fill in the blank.
Pipeline
6. What is the cheapest type of storage in Azure
per GB stored?
Azure Table storage
7. What is the purpose of a data dashboard,
particularly in Microsoft Power BI?
A dashboard tells a story of what is going on,
and contains the most important elements of that story in one page
8. Which Azure Data Factory component provides the
compute environment for activities?
Keywords: Azure data factory, compute
environment => integration runtime
9. Which type of non-relational data store
supports a flexible schema, stores data as JSON files, and stores the all the
data for an entity in the same document?
Document
10. Which of the following are examples of unstructured
data?
Log files, Blob
storage & CSV
files
11. By what orchestration method does the Azure
Data Factory move data from source, through several transformational steps,
into it's final destination?
Pipelines
12. Which statement best describes a STORED
PROCEDURE in a relational database?
A group of one or more SQL statements
13. Cosmos DB measures its performance in terms of
Request Units per second (RU/s). What is a Request Unit?
The amount of resources roughly required to
read one 1KB document with 10 fields.
14. What feature of SQL Database (based on the
SQL Server engine) allows you to prevent sensitive fields (such as social
security number, phone number, credit card number) from being displayed in a
report by partly hiding the value to provide increased data privacy?
Dynamic Data Masking
15. Which of the following best describes the
concept of data warehouse workloads?
The entire process of landing data into
the warehouse and all of the data warehouse activities such as analysing,
reporting, managing and exporting data
16. You have a SQL Server running inside your own
environment. As far as you know, it's not used very often and is only used as
the backend for an admin application inside your company, and only standard SQL
Server features have been used. Your goal is to save money. What SQL database
would you recommend migrating the database to inside Azure?
Azure SQL database single instance
17. Which of the following methods is commonly used
to secure data at rest?
Azure Disk Encryption
18. Which of the following statements best
defines "data in transit" when it comes to securing data?
Data while it’s being transferred between components,
locations or programs such as over a network.
19. Which of the following scenarios would be a
poor environment for an analytical database?
Data that is constantly changing
20. How do you disable SQL Database encryption at
rest so that the data is stored on the hard disk in a readable format?
You cannot. TDE is enabled by default and
cannot be disabled.
21. Which of the following is a consequence of
having a primary key on a relational data table?
The database enforces uniqueness, and no other
row can have the same primary key.
22. What is the maximum amount of data that can
be stored in a Azure Table Storage database?
5PB
23. What type of non-relational data revolves
around data that is formatted in a readable format (JSON, XML, YAML, etc)? It
is sometimes called semi-structured data. It can support queries that require
examining the contents of the data, such as a WHERE clause, but as well can
support scaling globally for quick reads and writes.
Document data
24. Which Azure storage solution allows you to
mount the storage as a drive in Windows Servers and assign it a drive letter
using the SMB protocol
Azure File storage
25. Which of the following types of data is an
example of a transactional workload?
A database that contains the day-to-day
operations of an organization.
26. By what method can you limit who has access
to your Cosmos DB account from the Internet?
IP policy-based access control
27. You have a CosmosDB account named Acct1 and it
has two security keys - primary key 1 and 2. You believe primary key 1 was
accidentally exposed to the public in a video tutorial. Luckily, nothing bad
has happened, but you need to take action. What action should you take?
Switch all apps to key 2 and regenerate key 1
28. Which of the following sentences best
describes what an INDEX is in SQL Server?
A structure associated with a table or a view
that speeds up retrieval of rows
29. You need a storage solution in Azure that
supports binary data. Your application will receive multiple GBs per day of
images and videos, and needs to store it some place for later access. Each
video or image will have a unique key, and that key will be later used to
retrieve the correct data. You need a solution that is optimized to store these
types of data, can handle the transaction volume easily, can label each
image/video by a unique key, and is not expensive. Which non-relational data
store do you recommend?
Azure blob storage
30. What do you get when you use Premium access
tier for Azure Blob Storage?
More expensive per GB to store the file and way
less expensive to access the file with less delay
31. When a customer wants to manage their own
encryption keys for SQL Database Transparent Data Encryption (TDE), where are
those keys stored?
Azure Key Vault
32. Generally speaking, regardless of which
region, which is the lowest cost redundancy option for Blob Storage?
LRS (Locally redundant storage)
33. Which type of data analytics workload is best
for processing data that is large, complex and takes a significant amount of
time to process?
Batch Processing
34. Your company has a Azure SQL Database, and each
user of that database has their own username and password unique to that
database server, known as SQL Server Authentication. Your security team wants
to eliminate this, and use the same username and password that users use in the
corporate network. What type of security can you enable to allow this single
sign-on model?
Azure AD Authentication
35. Which of the following metrics affect how
much a Cosmos DB database costs?
Cosmos DB is charged based on the following
metrics: Provisioned throughput, number of regions, number of availability
zones, consumed storage
36. You've created a Cosmos DB account named
Account1. Inside, you create one database named Db1, and one container named
Container1. The data you are storing is document data using the Core (SQL) API.
You have a new requirement to add a graph database using the Gremlin API. Can
you create another database named Db2 inside Account1 for the graph data?
No, each account can only contain one type of
data
37. Synapse Analytics and Azure Databricks are both
Spark-based analytics platforms. What feature does Synapse Analytics offer
thatn Databricks currently does not?
Based on the SQL Engine, familiar for existing
SQL server environments.
38. Which Azure service includes an end-to-end
machine learning environment inside the context of a data analytics platform?
Azure Databricks
39. What are the three types of activities that
Azure Data Factory supports?
Data movement, Data transformation, and Control
40. How do you implement the Zero Trust model of
security?
Verify each request as though it originated
from an uncontrolled network.
41. Which of the following data types can be called
structured data?
Structured data, sometimes referred to as
relational data, is data that adheres to a strict schema, so all of the data
has the same fields or properties. The shared schema allows this type of data
to be easily searched with query languages such as SQL (Structured Query
Language). This capability makes this data style perfect for applications such
as CRM systems, reservations, and inventory management. Structured data is
often stored in database tables with rows and columns with key columns to
indicate how one row in a table relates to data in another row of another
table.
42. Through what method can you enable single
sign-on for Cosmos DB, so that users can use their corporate user name and
password to access the contents of that database?
Enable Azure AD Authentication
43. Why would someone choose Azure Cosmos DB Table
API instead of Azure Table Storage?
Single-digit millisecond latency for reads and
writes
44. What is the primary difference between the
Standard tier of Azure File Share, and the Premium tier?
Standard tier uses hard disk-based storage
while Premium tier uses solid state disk.
45. With SQL Server in a Virtual Machine, can you
select the specific version of SQL Server you need or does it only run the
latest version?
You can select from any of the still-supported
versions of SQL Sever on a VM
46. You can select from any of the still-supported
versions of SQL Sever on a VM
Matrix
47. Which data loading approach is more suitable
for situations that require scaling, and is ideal for large volumes of data?
ELT is a more scalable approach, because the
data is transformed after it's loaded into the cloud database.
48. Which
of the following data processing techniques would be best used for handling a
file containing millions of rows of data?
Batch processing
(Correct)
Stream processing
49. Which data visualization style is colored
rectangles of varying size?
Treemap
50. Which of the following is an advantage of
running your SQL database on the PaaS model in Azure?
Cheapest up-front capital expenditure
51. Which SQL server query tool offers a modern
editor experience, Intellisense, code snippets, source control integration, and
an integrated terminal?
Azure Data Studio
52. Can a SQL Database server have both
Server-level IP firewall rules AND Database-level IP firewall rules? Or must
you choose one or the other?
You can have both server- and database-level
firewall IP rules
53. What feature of Azure Blob Storage would allow
recovery of a file that was accidentally deleted? Choose two.
Soft delete
Blob Versioning
54. What data structure allows a database server
to find data much faster than without it?
Indexes
55. What method of provisioning a non-relational
database would be best for users that only need to do this one time?
Azure Portal
56. Which Azure Storage service is specifically
designed to store large quantities of raw and unprocessed data, at very fast
speeds? That is, where would a Data Warehouse store it's raw data before being
ingested?
Azure Data lake storage
57. Can you run SQL Server on Linux in Azure?
Yes! Azure has SQL Server 2017 and 2019 on
Linux
58. What type of non-relational data revolves
around nodes and the relationships between the nodes? This would be a good data
type for databases that need to navigate from node to related nodes, like a
company organization chart or a social network.
Graph Data
59. What happens if you do not provision enough
Request Units per second (RU/s) than your application requires?
Request will be asked to retry later
60. Which of the following Azure data services is
said to be in the IaaS model?
SQL Server in a virtual Machine
61. Can Azure Data Factory be used to copy data
from an external source such as Amazon Redshift?
Yes
62. Your company has an Azure Function with a
public URL. An outside service periodically calls that URL with a binary image
as data in the body of the request. You want this Azure Function to take this
request, and store the binary image data somewhere in Azure for later retrival.
You need an Azure storage service that can store binary data such as images.
Which is the best non-relational data store for this scenario that you would
recommend?
Azure Blob storage
63. Which of the following database features
would be best for an analytics workload and not a transactional workload?
Optimized for reading data and not
optimized(or even able) to update data
64. Which of the following is an advantage of batch
processing of data? Choose two.
Processing data altogether is sometimes more
efficient processing data one at a time.
You can choose a time when computers are idle
such as overnight
65. What is one reason why someone would design a
report as a paginated report?
It needs to be printed or shared
66. What method of provisioning a non-relational
database involves first defining the database in a JSON file, which can then be
checked into a code repository for source control, sometimes also referred to
as Infrastructure as Code?
ARM Templates
67. What are the four pricing tiers for Azure
File Storage?
Premium, Transaction Optimized, Hot, cool
68. What data structure represents
"entities" in a relational database?
Tables
69. Which type of SQL query language is used to
creating and modifying the structure of a database?
DDL is data definition Language
70. In what way can ETL help with data privacy
and compliance?
ETL allows you to filter out sensitive data
before it’s loaded into the data store
71. Which Azure service allows data analysts, data
scientists, machine learning engineers, and data engineers to collaborate
together in an interactive workspace? The workspace exists inside an Apache
Spark cluster.
Azure DataBricks
72. Your company is implementing an Enterprise
Data Warehouse, and the first step is to get the data from an external source
into Azure. You anticipate there being a lot of data to bring into Azure, and
you can't estimate with certainty how much. There could possibly be an Exabyte
of data. You need a data storage solution designed for storing a large amount
of non-relational data, before using a Data Factory to process the data. What
data store is appropriate for the first step?
Azure Data Lake Storage Gen2
73. When deploying an Azure Storage account, and
you choose Locally Redundant Storage (LRS), how many copies of your data does
Azure keep?
3
