Azure Data Fundamental DP-900 MCQ Question Answer
Azure Data Fundamental DP-900 MCQ Question Answer
 |
| Azure Data Fundamental DP-900 |
1. [ Blob Storage ] is an Azure
Database product, designed to handle non-relational data such as JSON data.
- non-relational database => Cosmos DB
- Cosmos DB
2. [ Table Storage ] is the
absolute cheapest way to store data in Azure.
- Blob Storage
3. The car production workload is facing the issue of surplus goods. You
need to analyze the sale of the last 12 months to determine the requirement for
the next month.
- Predictive Analysis
4. Which of the following are common characteristics of a data warehouse?
- Database optimized for reading by being denormalized
- Supports massive amounts of data
- Platform as a Service (PaaS) database
offerings in Azure reduce the administrative overhead for managing hardware.
- Platform as a Service (PaaS) database offerings in Azure provides built-in high availability.
- Platform as a Service (PaaS) database offerings in Azure provide configurable scaling options.
6. You have a SQL pool in Azure Synapse
Analytics that is only used actively every night for eight hours. You need to
minimize the cost of the SQL pool during idle times. The solution must ensure
that the data remains intact.
What should you do on the SQL pool?
- Pause the pool
7. Azure Data Factory supports a
trigger that is scheduled at a predetermined time but can pretend it is running
at another time. For instance, a job runs every day at NOON, but only processes
the data received until midnight last night.
8. Which of the following metrics affect how much an Azure Redis Cache instance costs?
- Region, pricing tier, hours
9. Which of the following methods is commonly
used to secure data in transit?
- Site-to-site VPN
10. What is the concept of NORMALIZATION when it
comes to relational databases?
- Normalization is the process of organizing data in a database. This includes creating tables and establishing relationships between those tables according to rules designed both to protect the data and to make the database more flexible by eliminating redundancy and inconsistent dependency
11. Which of the following techniques is an example
of Least Privileged Access?
- Just-In-Time (JIT) access
12. You have a SQL Database Server named SQLDB, and
two SQL Databases named DB1 and DB2. SQLDB has a server-level firewall that
allows IP addresses in the range 123.123.123.0-123.123.123.255 and denies all
other traffic. DB1 has a database level firewall rule that allows IPs in the
range 123.123.123.0-123.123.124.255. When a client using the IP address
123.123.124.25 attempts to access DB1, are they successful?
- Yes, the connection will succeed
13. What feature of SQL Database ensures that
data can be encrypted end to end, and never in a decrypted state at any time
outside the client machine?
- Always Encrypted
14. Which of the following activities would be
considered part of Azure Data Factory's Control Flow?
- If Condition (Control flow activities are the ones that allow looping, if conditions, filtering, and having a pipeline invoke another pipeline)
15. Who's responsibility is "data
security" in the Azure Shared Responsibility model?
- Shared between Azure and the client
16. What is one way that you can secure all data
coming to and from an Azure Storage Account?
- Enable “Secure transfer required” property for the storage account
17. You are a Power BI report designer, and in
talking with the client, they are looking for a sales report that lists all of
the cars sold in the past month. Each row represents one car sold, and each
column contains the characteristics of the sale including the make and model,
who sold it, the date sold, and the amount it sold for. The client expects
there are thousands of rows per month, but they want this report anyways. Which
type of report should you create for them in Power BI?
- Paginated Reports (Any time your client asks for detail, in rows and columns, you should be thinking about a paginated report.)
18. What method of provisioning a non-relational
database involves writing a script, which is a set of commands that you can run
from any operating system prompt such as Linux, macOS or Windows?
- PowerShell, or CLI
19. You have a production application that reads
and writes to an Azure SQL Database around 100 times per second. Ocassionally,
you get an exception inside your application, "40501 - The service is
currently busy." What is the likely cause of this type of error? And what
is the mitigation for that?
- Azure SQL Database has per DTU IOPS limits. Increase the DTUs to a higher level, or retry the request after a few seconds delay.
20. Name all of the Azure non-relational data
stores that store data as key-value pairs.
- Cosmos DB Table API, Azure Cache for Redis, Table Storage.
21. A customer just purchased a service from your
company, and a new data row was added to table SALES to indicate this event as
soon as it happened. What type of database is this?
- OLTP
22. What is the advantage of using Transaction Optimized storage for Azure File Storage?
- Around 25%-33% of the cost of HOT storage per read-write operation, but twice as expensive per GB for storage. This can save you money for heavily accessed files without using the Premium access tier.
23. You are trying to determine which type of
database to store your Employee data in. First, you need to figure out what
kind of data you have. The data comes from an external source, and can be
formatted in any way that you need. The thing is, not every entity has value
for every property. Some entities have middle names, and for other records,
that information doesn't exist. One thing you've discovered is that, at any
time, this external data source can add a new never-seen-before field (like a
list of awards an employee has won) and you need to store it. What type of data
do you have?
- Semi-structured data
24. You are a developer for ACME organization, and
you run a basic SQL SELECT query against the customer database. Some of the
fields come back partly hidden, such as this phone number - XXX-XXX-8866. What
SQL Database feature is being used to hide the data?
- Dynamic Data Masking
25. How
many databases can you create in a single Cosmos DB account?
- Unlimited
26. With a relational data store, when data
transaction volumes get too high and database performance suffers, which of the
following is a common yet difficult method of distributing those data
transactions over multiple servers?
- Manual Sharding
27. Which of the following is considered a
downside to using a non-relational data store compared to a relational
database?
- An non-relational data store does not enforce a consistent data state with in the database
28. When deploying an Azure Storage account, and
you choose Zone Redundant Storage (ZRS), how many copies of your data does
Azure keep?
- 3
29. When it comes to data security, what is the
principle of least privilege?
- Users only have the permissions they need to complete their job, and no more.
30. Which Azure data service is best used for
moving data from one source to another destination, with the ability to
transform the data (process it) along the way?
- Azure data Factory
31. What do you get when you use Cool access tier
for Azure Blob Storage?
- Less expensive per GB to stare the file, and more expensive to access the file
32. What is the difference between a clustered and
unclustered index in SQL Server?
- A clustered index sort and store the data rows based on their key values. Non-Clustered indexes have a structure separate from the data rows.
33. Which of the follwing is a consequnce of
having a foreign key relationship between two relational data tables?
- An INSERT statement will fail if the value of the foreign key column, other that NULL, Doesn’t exit in the other table.
34. What is the minimum number of Request Units
per second (RU/s) that you can allocate to a Cosmos DB database or container?
- 400 RU/s
35. What feature of Azure Blob Storage, if enabled,
allows you to retrieve files that have previously been deleted within a time
period?
- Soft Delete
36. What type of file system does Azure Data Lake
Storage Gen2 use?
- Hadoop Distributed file system (HDFS)
37. You are developing a Power BI report for
users to view on their desktop workstations. The report needs to show detailed
data, and allow the user to customize the filters and modify the column to sort
on. Additionally, users should be able to drill-through the report to other
reports if they wish to see the data in another way. What type of Power BI
report should you create?
- Interactive reports
38. Which of the following is a valid IP address range
using the CIDR address method?
- 110.0.0.0/8
39. Why would someone choose Azure Table Storage
instead of Azure Cosmos DB Table API?
- Lowest-cost option
40. What type of security does Transparent Data
Encryption (TDE) provide?
- Data-at-rest encryption
41. Which type of data analytics workload is best
for processing time-sensitive data that arrives from an external source every
few seconds?
- Real-time processing
42. Cosmos DB uses a primary key model to give
people full control over a Cosmos DB account. How do you limit someone to
having only read-only access to your database?
- Resource Tokens
43. When deploying an Azure Storage account, and
you choose Geo Redundant Storage (GRS), how many copies of your data does Azure
keep?
- 6
44. Every day, car dealers upload their sales and
service reports into your web portal. Your web portal stores these files in a
Blob Storage container. The data is formatted exactly as your Cosmos DB data
needs it. You don't anticipdate needing to modify it before getting it into the
database. Which data ingestion model seems to work best for this scenario?
- ELT
45. You have 10 TB of log files stored in an
Azure Data Lake Storage Gen2, and would like to save some money on storage.
These files are historical, and you don't expect to be needing to access them
any more. Because of company policy, you still need to keep them around for 3
more months in case they are needed. What actions can you take to reduce the
cost, in the fewest possible steps?
- Implement lifecycle management policies on the Azure data Lake storage to move files to cool or archive storage tier.
46. What type of non-relational data revolves
around quickly storing and retrieving a single value per unique item? It is not
optimized for queries that requiring examining the contents of the data, such
as a WHERE clause in a typical relational query, but is extremely scalable and
designed for storing data across multiple nodes on separate machines.
- Key-value data
47. Which CosmosDB API format works best with
document (JSON) data?
- Core SQL
48. Your company has one SQL Database server that
has two SQL Databases on it. You would like to allow connections over the
public internet to these databases. Each database has a different set of
clients with no overlap. You would like clients of one company to be able to
access one database but not the other. How do you configure your firewall to
enable this?
- Database-level IP firewall
49. Which Azure service is a managed-version of the
open-source Apache Spark application, or provides a Spark environment in Azure?
- Azure HDInsight, Azure Databricks
50. You have a SQL Server running inside your own
environment, and you'd like to migrate it into the cloud. You happen to know
that the settings on the database has been customized for a business reason.
You need to be sure that absolutely NO code will have to change when you move
this database - only the connection string. Which is the best way to migrate a
SQL Server to Azure to ensure absolutely guaranteed no coding or SQL database
schema changes required?
- Migrate to SQL Server in a VM
51. When it comes to data security, what is the
Zero Trust model?
- Assume that you have been breached.
52. Which
of the following items best defines "data at rest" when it comes to
securing data?
- Data that exits statically on the physical media
53. What do you get when
you use Archive access tier for Azure Blob Storage?
- Way less expensive to store the file and long delay to access the file (perhaps hours)
54. By default, what is
the security model of Cosmos DB?
- A valid authorization token
55. Which of the
following methods is commonly used to secure data in transit?
- Secure Socket Layer (SSL) or HTTPS
56. In a relational database, can a foreign key
reference another column on the same table?
- Yes
