- All Exams Instant Download
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 Apache Spark SQL operation should you use?
You have an Azure Databricks workspace that contains a Delta Lake dimension table named Tablet. Table1 is a Type 2 slowly changing dimension (SCD) table. You need to apply updates from a source table to Table1. Which Apache Spark SQL operation should you use?A . CREATE B. UPDATE C. MERGE...
What should you include in the recommendation?
You have two fact tables named Flight and Weather. Queries targeting the tables will be based on the join between the following columns. You need to recommend a solution that maximum query performance. What should you include in the recommendation?A . In each table, create a column as a composite...
What should you use?
You have an Azure Synapse Analytics dedicated SQL pool mat contains a table named dbo.Users. You need to prevent a group of users from reading user email addresses from dbo.Users. What should you use?A . row-level security B. column-level security C. Dynamic data masking D. Transparent Data Encryption (TDDView AnswerAnswer:...
Which type of file should you use?
You have an Azure subscription that contains an Azure Blob Storage account named storage1 and an Azure Synapse Analytics dedicated SQL pool named Pool1. You need to store data in storage1. The data will be read by Pool1. The solution must meet the following requirements: ✑ Enable Pool1 to skip...
Which two actions should you perform?
You use Azure Data Lake Storage Gen2. You need to ensure that workloads can use filter predicates and column projections to filter data at the time the data is read from disk. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection...
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 rule B. a database-level virtual network rule C. a database-level firewall IP rule D. a server-level firewall IP ruleView AnswerAnswer: A Explanation: Virtual network rules are one...
You store files in an Azure Data Lake Storage Gen2 container
HOTSPOT You store files in an Azure Data Lake Storage Gen2 container. The container has the storage policy shown in the following exhibit. Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection Is worth...
Which type of table should you use for each table?
HOTSPOT You have a data model that you plan to implement in a data warehouse in Azure Synapse Analytics as shown in the following exhibit. All the dimension tables will be less than 2 GB after compression, and the fact table will be approximately 6 TB. Which type of table...
What should you recommend using to secure sensitive customer contact information?
What should you recommend using to secure sensitive customer contact information?A . data labels B. column-level security C. row-level security D. Transparent Data Encryption (TDE)View AnswerAnswer: B Explanation: Scenario: All cloud data must be encrypted at rest and in transit. Always Encrypted is a feature designed to protect sensitive data...
