Azure Data Fundamental DP-900 MCQ Question Answer
Azure Data Fundamental DP-900 MCQ Question Answer
1. Drag and drop the following options.
- Transparent Data Encryption - used to encrypt data at rest, including database, logs, and backups, without requiring changes to the application
- Always encrypted - used to protect sensitive data by limiting access to data at rest, in movement, and in use to client applications that have appropriate access to keys
- Transport layer security - used to encrypt data in motion between the database server and clients using certificate-based encryption
- Dynamic data masking - used to limit exposer of sensitive data to non-privileged users by designating how much of the sensitive data can be revealed
2. _________________________ is used to access data stored in azure storage account.
Azure storage Explorer
3. ________________ API of cosmos DB can be used
to work with column-based data.
Cassandra
4. You need to store data in Azure Blob storage
for seven years to meet your company's compliance requirements. The retrieval
time of the data is unimportant. The solution must minimize storage costs.
Which storage tier should you use?
Storing data for years, save cost =>
Archive objects
5. Drag and drop the following options.
- Diagnostic analytics - Why did sales increase last month
- Prescriptive analytics - How do I allocate my budget to buy different inventory items?
- Predictive analytics - The rise of COVID19 cases in a country
6. Which among the following
statement is true with respect to the Azure SQL database?
You can use existing Microsoft SQL Server licenses
to reduce the cost of Azure SQL databases.
7. Drag and drop the following options.
- Firewall - Prevent access to an Azure SQL database from another network.
- Encryption - Ensure that sensitive data never appears as plain text in an Azure SQL database.
- Authentication - Support Azure Active Directory (Azure AD) sign-ins to an Azure SQL database.
8. Polybase is used__________________________
To query data from external data sources from
Azure synapse Analytics
9. Which command-line tool can you use to query Azure SQL databases?
Sqlcmd
10. Your company has a reporting solution that
has paginated reports. The reports query a dimensional model in a data
warehouse.
Which type of processing does the reporting
solution use?
Online
Analytical Processing (OLAP)
11. _____________
is an object associated with a table that sorts the data rows in the table on
their key values.
Clustered
index
12. Which deployment requires the fewest changes when migrating an existing
SQL Server on-premises solution?
SQL server running on a virtual machine
13. Drag and drop the following options.
- Graph - Employee data that show relationship between employees
- Key/Value - Application users and their default language
- Object - Medical images and their associated metadata
14. Drag and drop the following options.
- Descriptive analytics - Helps answer questions about what has happened, based on historical data.
- Diagnostic analytics - Helps answer questions about why things happened.
- Predictive analytics - Helps answer questions about what will happen in the future.
- Cognitive analytics - Helps to draw inferences from existing data and patterns.
15. What is the name of the SQL used by SQL Server?
T-SQL
16. To configure an Azure storage account to support both security at the
folder level and atomic directory manipulation, you need to [ set account kind to blob storage ]
Hierarchical namespace
17. When using an Azure SQL Database managed instance, what is the
simplest way to implement backups?
Backups
are automatically handled
18. What is the benefit of hosting a
database on an Azure SQL managed instance as compared to an Azure SQL database?
native
support for cross-database queries and transactions
19. click
the following yes or no.
Azure
Table storage support multiple read replicas(Yes)
20. How does a relational database enforce data integrity?
- - Prevents records from being inserted if records they rely on don't exist
- - Ensures every column follows the data type of it's schema definition
- - Prevents records from being deleted if other records rely on them
- - Prevents null values on columns which do not allow null values
What type of
credential does Cosmos DB expect in order to grant you access?
Access
key ( or SAS Token)
22. _______is
a virtual table that does not physically exit in SQL server rather, it is
created by a query joining one or more tables.
View
23. During which step of ETL is a data column modified to match the expected
format of the destination? For instance, changing the date field from "31
Dec, 2021" to "31/12/2021".
Transformation
24. You need to gather real-time telemetry data from a mobile application.
Which type of workload describes this scenario?
Streaming
25. Which service in Azure can be used to process the data in real-time
having three components: input, query, and output?
Stream Analytics Job
26. Which of the following is an advantage of using multi-region
replication with Cosmos DB?
- Cosmos DB, Multi-region replication => High Availability
- Correct answer is option Availability is increased
27. Transparent Data Encryption (TDE) encrypts___________________
The database to protect data at rest
28. Which Azure Data Factory component initiates the execution of a
pipeline?
A Trigger
29. What is the primary difference between a data lake and a data
warehouse?
A data lake holds raw data but a data warehouse holds structured
informations.
30. What type of analytics uses advanced data such as a camera sensor
embedded in a store to offer extra discounts to customers by emails, who looked
at an item but didn't buy it?
Cognitive
31. Which are the services in Azure that can be used to process the data?
Synapse Analytics & Stream Analytics Job
32. Which objects can be added to a Microsoft Power BI dashboard?
- An image
- A text
- A visualization from a report
- A report page
33. Which of the following Azure database services has guaranteed 100%
compatibility with SQL Server running in your own environment?
SQL Server in a VM
34. Which one of the following tasks is the role of a database
administrator?
Backing up and restoring databases
35. ___________________________ is an example of semi-structured data.
- Semi Structure data examples => JSON, CSV, XML
- A JSON file
36. Provisioning is _______________________
The act of running a series of tasks that a service provider performs to create and configure a service.
