Azure data dp 900 - Study guides, Class notes & Summaries

DP-900 Microsoft Azure Data Fundamentals- Updated Exam Readiness Guide 2024.pDP-900 Microsoft Azure Data Fundamentals- Updated Exam Readiness Guide 2024.pDP-900 Microsoft Azure Data Fundamentals- Updated Exam Readiness Guide 2024.pDP-900 Microsoft Azure Data Fundamentals- Updated Exam Readiness Guide 2024.p

01. A team of developers has computers Thai run Windows 10 and Ubuntu Desktop. The developers need to connect to and query an Azure SCX database from the computers. The developers require code assistance features such as intellSense. What should the developers use? a) Azure Data Explorer b) sq1cmd c) Azure Data Studio d) Microsoft SQL Server Management Studio (SSMS) - Answer: b) sq1cmd 02. You have a quality assurance application that reads data from a data warehouse. Which type of pro...

How can you enable globally distributed users to work with their own local replica of a Cosmos DB database? -Create an Azure Cosmos DB account in each region where you have users. -Use the API for Table to copy data to Azure Table Storage in each region where you have users. -Enable multi-region writes and add the regions where you have users. - Enable multi-region writes and add the regions where you have users. -You can enable multi-region writes in the regions where you want users to w...

100. Which clause should you use to retrieve the related data from multiple tables? - JOIN A join condition defines the way two tables are related in a query by: Specifying the column from each table to be used for the join. A typical join condition specifies a foreign key from one table and its associated primary key in the other table. Specifying a logical operator (for example, = or <>,) to be used in comparing values from the columns. 101. Consider the following SQL query which ty...

Az SQL managed instance benefit - native support for cross-db queries and transactions Azure Cosmos DB API: Graph Data - Gremlin API Azure Cosmos DB API: JSON Documents - MongoDB API Azure Cosmos DB API: Key/Value data - Table API Azure Data Factory control flow - control flow orchestrate pipeline activities that depend on the output of other pipeline activities Azure Data Lake Storage support RBAC - RBAC at file and folder level Batch workloads collect data and process data when conditio...

1 - A report with details of what happened in the last quarter is an example of: a) Descriptive Analysis b) Diagnostic analytics c) Predictive analytics d) Prescriptive analytics resp a) Descriptive Analysis Descriptive analytics, which answers the question "What is happening in my business?". The data to answer this question is typically answered through the creation of a data warehouse in which historical data is persisted in relational tables for multidimensional modeling and repor...

66. We have IaaS, PaaS, SaaS. In which category that Azure data services fall into? Azure Data Services fall into the PaaS category. These services are a series of DBMSs managed by Microsoft in the cloud. Each data service takes care of the configuration, day-to-day management, software updates, and security of the databases that it hosts. 67. What are currently available relational databases on Azure? Azure SQL Database Azure Database for MySQL servers Azure Database for MariaDB server...

Azure DP 900 Questions and Answers 2022 Descriptive Analytics tells you what occurred in the past Normalisation involves eliminating relationships between database tables NO Normalising a database reduces data redundancy YES Normalisation improves data integrity YES An extract, transform and load (ETL) process requires that the data target be a relational database In batch processing latency is expected

Descriptive analytics What occurred in the past Normalizing Reduce data redundancy & Improves data integrity Does NOT eliminate relationship In batch processing, it takes longer time to process in bulk Latency is expected Diagnostic analytics Why events happened Prescriptive analytics Which actions should be taken Cognitive analytics Draw inferences from existing data and patterns, derive conclusions based on existing knowledge bases, and then add the...

DP 900 Questions and Answers 2022 Descriptive Analytics tells you what occurred in the past Normalisation involves eliminating relationships between database tables NO Normalising a database reduces data redundancy YES Normalisation improves data integrity YES An extract, transform and load (ETL) process requires that the data target be a relational database In batch processing latency is expected Diagnostic Why did sales increase last month? Predictive How do I allocate my bud...