DP-900 Microsoft Azure Data Fundamentals - Microsoft Learning

15. Which storage solution supports role-based access control (RBAC) at the file and folder level? a) Azure Data Lake Storage b) Azure Queue storage c) Azure Blob storage d) Azure Disk Storage

resp a) Azure Data Lake Storage

20. You need to design and model a database by using a graphical tool that supports project-oriented offline database development. What should you use? a) Microsoft SQL Server Data Tools(SSDT) b) Microsoft SQL Server Management Studio (SSMS) c) Azure Data Studio d) Azure Databricks

resp a) Microsoft SQL Server Data Tools(SSDT)

12. Which one of the following options is the most important key benefit of data analysis? a)Decisive analytics b)Informed business decisions c)Complex reports

b)Informed business decisions - A key benefit of data analysis is the ability to gain valuable insights from a business's data assets to make timely and optimal business decisions.

9. Which hub is where you can grant access to Synapse workspace and resources? a)Monitor hub. b)Manage hub. c)Integrate hub.

b)Manage hub.

32. You have an e-commerce application that reads ans write data to an Azure SQL database. Which type of processing does the application use? a) Online Transaction Processing (OLTP) b) batch processing c) Online Analytical Processiong(OLAP) d) stram processing

resp a) Online Transaction Processing (OLTP)

16. True/False - Azure Table Storage suports multiple read replicas a) True b) False

resp a) True

25. You have a transactional application that stores data in an Azure SQL managed instance. When should you implement a read-only databases replica? a) You need to implement high availability in the event of a regional outage. b) You need to improve the recovery point objective(RPO) c) You need to audit the transactional application.

resp a) You need to implent high availability in the event of a regional outage.

18. True/False - The Azure Cosmos DB Table API supports multiple read replicas a) True b) False

resp a)True

3. A data analyst wants to analyze data by using Python code combined with text descriptions of the insights gained from the analysis. What should they use to perform the analysis? a)A notebook connected to an Apache Spark pool. b)A SQL script connected to a serverless SQL pool. c)A KQL script connected to a Data Explorer pool.

Correct. a)A notebook enables you to interactively run Python code in an Apache Spark pool and embed notes using Markdown.

2. You want to create a data warehouse in Azure Synapse Analytics in which the data is stored and queried in a relational data store. What kind of pool should you create? a)Serverless SQL pool b)Dedicated SQL pool c)Apache Spark pool

Correct. b)A dedicated SQL pool defines a relational database in which data can be stored and queried.

5. What component of Azure Synapse analytics allows the different engines to share the databases and tables between Spark pools and SQL on-demand engine? a)Azure Synapse Link. b)Azure Synapse shared metadata. c)Azure Synapse Spark pools.

Correct. b)Azure Synapse shared metadata. - The shared metadata gives the workspace SQL engines access to databases and tables created with Spark.

7. Which Azure Synapse Studio hub would you go to create Notebooks? a)Data. b)Develop. c)Integrate.

Correct. b)Devlop - The Develop hub is where you manage SQL scripts, Synapse notebooks, data flows, and Power BI reports.

4. Which Azure Service is Azure Synapse Pipelines based on? a)Azure Data Explorer. b)Azure Stream Analytics. c)Azure Data Factory.

Correct. c)Azure Data Factory. - Azure Synapse Pipelines is based in the Azure Data Factory service.

6. Which Azure Synapse Analytics component enables you to perform Hybrid Transactional and Analytical Processing? a)Azure Synapse Pipeline. b)Azure Synapse Studio. c)Azure Synapse Link.

Correct. c)Azure Synapse Link is the component that enables Hybrid Transactional and Analytical Processing.

8. In Azure Synapse Studio, where would you view the contents of the primary data lake store? a)In the Integration section of the Monitor hub. b)In the workspace tab of the Data hub. c)In the linked tab of the Data hub.

Correct. c)In the linked tab of the Data hub. - The linked tab of the data hub is where you can view the contents of the primary data lake store.

1. Which feature of Azure Synapse Analytics enables you to transfer data from one store to another and apply transformations to the data at scheduled intervals? a)Serverless SQL pool b)Apache Spark pool c)Pipelines

Correct. c)Pipelines provide a way to encapsulate one or more actions that can be applied to data as it is transferred from one data store to another.

11. Which data analyst task has a critical performance impact on reporting and data analysis? a)Model b)Analyze c)Visualize

a)Model - An optimized and tuned data model performs better and provides a better data analysis experience.

10. Which data role enables advanced analytics capabilities specifically through reports and visualizations? a)Data scientist b)Data engineer c)Data analyst

c)Data analyst - A data analyst uses appropriate visuals to help business decision makers gain deep and meaningful insights from data.

28. To configura an Azure Storage account to support both security at the folder level and atomic directory manipulation, ________________________ a) enable the hierarchical namespace b) set account kind to BlobStorage c) set Performance to Premium d) set Replication to Read-access geo-redundant storage(RA-GRS).

resp a) enable the hierarchical namespace

26. What is a benefit of hosting a database on Azure SQL managed instance as compared to an Azure SQL database? a) native support for cross-database queries and transactions b) system-initiated automatic backups c) support for encryption at rest d) built-in high availability

resp a) native support for cross-database queries and transactions

19. True/False - The Azure CosmosDB Table API supports multiple write replicas a) True b) False

resp a)True

22. You can use existing Microsoft SQL Server licenses to reduce the cost of Azure SQL databases. a)True b)False

resp a)True

23. You can use Microsoft SQL Server Management Studio(SSMS) to query an Azure SynapseAnalytics data warehouse. a)True b)False

resp a)True

24. Platform as a service (PaaS) database offerings Azure provide configurable scaling options. a)True b)False

resp a)True

31. You need to develop a solution to provide data to executives. The solution must provide an interactive graphical interface, depict various key performance indicators, and support data exploration by using drill down. What should you use in Microsoft Power BI? a) Microsoft Power Apps b) a dashboard c) a dataflow d) a report

resp b) a dashboard

30. What are three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution. a) schema on read b) heavy writes and moderate reads c) light writes and heavy reads d) schema on write e) normalized data f) denormalized data

resp b) heavy writes and moderate reads d) schema on write e) normalized data

21. At which two levels can you set the throughput for an Azure Cosmos DB account? a) database b) partition c) Item d) container

resp b) partition d) container

29. Which two activities can be performed entirely by using the Microsoft Power BI service? a) data modeling b) report sharing and distribution c) data acquisition and preparation d) report and dashboard creation

resp b) report sharing and distribution d) report and dashboard creation

17. True/False - Azure Table Storage supports multiple write replicas a) True b) False

resp b)False

27. Your company is designing a database that will contain session data for a website. The data will include notifications, personalization attributes, and products that are added to a shopping cart. Which type of data store will provide the lowest latency to retrieve the data? a) graph b) key/value c) columnar d) document

resp c) columnar

14. Relational Databases uses ________________ to enforce relationships between different tables a) Collections b) columns c) keys d) partitions

resp c) keys

13. Which command-line tool can you use to query Azure SQL databases? a) sqlcmd b) azdata c) bcp d) Azure CLI

resp d) Azure CLI