- All Exams Instant Download
When you query ExtTable by using an Azure Synapse Analytics serverless SQL pool, which files are returned?
You have files and folders in Azure Data Lake Storage Gen2 for an Azure Synapse workspace as shown in the following exhibit. You create an external table named ExtTable that has LOCATION='/topfolder/'. When you query ExtTable by using an Azure Synapse Analytics serverless SQL pool, which files are returned?A ....
What should you do?
HOTSPOT You need to implement an Azure Synapse Analytics database object for storing the sales transactions data. The solution must meet the sales transaction dataset requirements. What solution must meet the sales transaction dataset requirements. What should you do? To answer, select the appropriate options in the answer area. NOTE:...
What should you do?
You plan to implement an Azure Data Lake Storage Gen2 container that will contain CSV files. The size of the files will vary based on the number of events that occur per hour. File sizes range from 4.KB to 5 GB. You need to ensure that the files stored in...
What should you recommend to prevent users outside the Litware on-premises network from accessing the analytical data store?
What should you recommend to prevent users outside the Litware on-premises network from accessing the analytical data store?A . a server-level virtual network ruleB . a database-level virtual network ruleC . a database-level firewall IP ruleD . a server-level firewall IP ruleView AnswerAnswer: A Explanation: Virtual network rules are one...
Which two actions should you perform?
You are creating an Azure Data Factory data flow that will ingest data from a CSV file, cast columns to specified types of data, and insert the data into a table in an Azure Synapse Analytic dedicated SQL pool. The CSV file contains three columns named username, comment, and date....
Which three actions should you perform?
You have an enterprise-wide Azure Data Lake Storage Gen2 account. The data lake is accessible only through an Azure virtual network named VNET1. You are building a SQL pool in Azure Synapse that will use data from the data lake. Your company has a sales team. All the members of...
Does this meet the goal?
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you...
Which Transact-SQL commands should you use?
HOTSPOT You have an Azure subscription that contains the following resources: * An Azure Active Directory (Azure AD) tenant that contains a security group named Group1. * An Azure Synapse Analytics SQL pool named Pool1. You need to control the access of Group1 to specific columns and rows in a...
What should you create?
You need to implement the surrogate key for the retail store table. The solution must meet the sales transaction dataset requirements. What should you create?A . a table that has an IDENTITY propertyB . a system-versioned temporal tableC . a user-defined SEQUENCE objectD . a table that has a FOREIGN...
Which two actions should you perform?
You are creating an Azure Data Factory data flow that will ingest data from a CSV file, cast columns to specified types of data, and insert the data into a table in an Azure Synapse Analytic dedicated SQL pool. The CSV file contains three columns named username, comment, and date....
