DP-900 MICROSOFT AZURE DATA FUNDAMENTALS - TEXT1|UPDATED&VERIFIED|100% SOLVED|GUARANTEED SUCCESS

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 reporting. Diagnostic analytics, which deals with answering the question "Why is it happening?". This may involve exploring information that already exists in a data warehouse, but typically involves a wider search of your data estate to find more data to support this type of analysis. Predictive analytics, which enables you to answer the question "What is likely to happen in the future based on previous trends and patterns?" Prescriptive analytics, which enables autonomous decision making based on real-time or near real-time analysis of data, using predictive analytics. 2 - _______ provides what action we should take a) Descriptive Analysis b) Diagnostic analytics c) Predictive analytics d) Prescriptive analytics resp d) Prescriptive analytics 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 reporting. Diagnostic analytics, which deals with answering the question "Why is it happening?". This may involve exploring information that already exists in a data warehouse, but typically involves a wider search of your data estate to find more data to support this type of analysis. Predictive analytics, which enables you to answer the question "What is likely to happen in the future based on previous trends and patterns?" Prescriptive analytics, which enables autonomous decision making based on real-time or near real-time analysis of data, using predictive analytics. 3 - Converting speech to text is an example of ___________ a) Descriptive Analysis b) Diagnostic analytics c) Cognitive analytics d) Prescriptive analytics resp c) Cognitive analytics 4 - Analyzing why car sales are down in the last quarter comes under ______________ a) Descriptive Analysis b) Diagnostic analytics c) Predictive analytics d) Prescriptive analytics resp b) Diagnostic analytics 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 reporting. Diagnostic analytics, which deals with answering the question "Why is it happening?". This may involve exploring information that already exists in a data warehouse, but typically involves a wider search of your data estate to find more data to support this type of analysis. Predictive analytics, which enables you to answer the question "What is likely to happen in the future based on previous trends and patterns?" Prescriptive analytics, which enables autonomous decision making based on real-time or near real-time analysis of data, using predictive analytics. 5 - Pie Chart showing number of tickets bought vs seating capacity of a movie theater is 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 reporting. Diagnostic analytics, which deals with answering the question "Why is it happening?". This may involve exploring information that already exists in a data warehouse, but typically involves a wider search of your data estate to find more data to support this type of analysis. Predictive analytics, which enables you to answer the question "What is likely to happen in the future based on previous trends and patterns?" Prescriptive analytics, which enables autonomous decision making based on real-time or near real-time analysis of data, using predictive analytics. 6 - Which of these can you use to analyze if a retail company has sufficient stock of products to meet the demand on Black Friday? a) Descriptive Analysis b) Diagnostic analytics c) Predictive analytics d) Prescriptive analytics resp c) Predictive analytics 7 - In ELT (Extract, Load and Transform): a) Data is first loaded into the target datastore with minimal processing b) Transformations are done in the target datastore c) We do NOT use separate service for transformation d) All of above resp d) All of above 8 - TRUE OR FALSE: Batch Processing commences when a condition is met a) True b) False resp a) True 9 - Which of the following is TRUE about Batch processing? a) Data is processed near realtime b) Can NOT process huge loads of data c) Parallel Processing is NOT possible d) Batch processing typically has high latency resp d) Batch processing typically has high latency 10 - Temperature sensors sending readings every hour is example of _________ a) Batch Processing b) Stream processing resp a) Batch Processing 11 - Payment transactions from a POS terminal sent to Event Hubs is an example of _______ a) Batch Processing b) Stream processing resp b) Stream processing 12 - TRUE OR FALSE: When using Azure Data Factory for batch processing, processed data can be stored in relational databases, NoSql databases or in Azure Blob Storage a) True b) False resp a) True 13 - Most frequently used data model schema for data analysis (in a data warehouse) is ________________ a) Star Schema b) Transactional Data Model c) Dimension d) None of the above resp a) Star Schema 14 - TRUE OR FALSE : STAR schema is de-normalised and easier to query a) True b) False resp a) True 15 - Azure Synapse Analytics supports parallel processing of data using: a) High Performance Single Node Machines b) Split Processing across multiple compute nodes c) Doesn't support parallel processing resp b) Split Processing across multiple compute nodes 16 - Which of these can be used to show impact of a power outage across different states in United States? a) Filled Map b) Pie Chart c) Scatter resp a) Filled Map 17 - TRUE or FALSE : In Azure Data Factory, Linked Service is used to connect to an external source. It contains the details to connect to the external data source. a) True b) False resp a) True 18 - TRUE or FALSE : In Azure Data Factory, Pipeline contains a logical group of activities that can be scheduled a) True b) False resp a) True 19 - True or FALSE : Azure Databricks is a managed service for Apache Spark a) True b) False resp a) True 20 - In Power BI - Paginated Reports are created using: a) Power BI Desktop b) Power BI Report Builder c) Power BI as a Service d) Excel Sheet resp b) Power BI Report Builder 21 - In Power BI - Dashboard can be created using ______________. a) Power BI Desktop b) Power BI Report Builder c) Power BI as a Service d) Excel Sheet c) Power BI as a Service 22 - Azure SQL Database creation can be automated using ____________. a) ARM Template b) Azure CLI c) Azure PowerShell d) All of the above resp d) All of the above 23 - SQL Server, Azure SQL Database, Azure SQL Managed Instance can all be accessed using: a) Azure Data Studio b) Microsoft SQL Server Management Studio c) Microsoft SQL Server Data d) All of the above resp d) All of the above