DP 900 Questions and Answers 2022

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 budget to buy different inventory items? Cognitive Which people are mentioned in a company's business documents? Transcribing audio files is an examples of cognitive analytics You have the following JSON document: 'customer': { 'first name': 'ben', 'address': {'line 1': '161 Azure Ln', } } . 'social' : [ { 'service: twitter'., 'handle': @bensmitg'} customer is a root object You have the following JSON document: 'customer': { 'first name': 'ben', 'address': {'line 1': '161 Azure Ln', } } . 'social' : [ { 'service: twitter'., 'handle': @bensmitg'} address is a nested object You have the following JSON document: 'customer': { 'first name': 'ben', 'address': {'line 1': '161 Azure Ln', } } . 'social' : [ { 'service: twitter'., 'handle': @bensmitg'} social media is a nested array Customer > sales <product / sales person > Sales < warehouse The data model is a Star schema Customer > sales <product / sales person > Sales < warehouse Customer is a Dimension The massively parallel processing (MPP) engine of Azure Synapse Analytics distributes processing across compute nodes A clustered index is an object associated with a table that sorts and stores the data rows in the table based on their key values A relational database must be used when strong consistency guarantees are required Relation data uses ________ to enforce relationships between different tables keys A view is a virtual table that contains content defined by a query You need to query a table named Products in an Azure SQL database. Which three requirements must be met to query the table from the internet? - You must have select access to the product table - You must have a user in the database - Your IP address must be allowed to connect to the database Which statement should you use in SQL query to change the inventory quantity of Product1 to 270?