This page was exported from Braindump2go Free Exam Dumps with PDF and VCE Collection [ https://www.mcitpdump.com ] Export date:Mon Jul 22 8:55:55 2024 / +0000 GMT ___________________________________________________ Title: [March-2023]DP-300 PDF Dumps from Braindump2go Help 100% Pass DP-300 Exam[Q109-Q140] --------------------------------------------------- March/2023 Latest Braindump2go DP-300 Exam Dumps with PDF and VCE Free Updated Today! Following are some new Braindump2go DP-300 Real Exam Questions!QUESTION 109You are designing a security model for an Azure Synapse Analytics dedicated SQL pool that will support multiple companies.You need to ensure that users from each company can view only the data of their respective company.Which two objects should you include in the solution? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.A. a column encryption keyB. asymmetric keysC. a functionD. a custom role-based access control (RBAC) roleE. a security policyAnswer: CEExplanation:Row-Level Security enables you to use group membership or execution context to control access to rows in a database table. Implement RLS by using the CREATE SECURITY POLICY Transact-SQL statement, and predicates created as inline table-valued functions. Reference:https://docs.microsoft.com/en-us/azure/synapse-analytics/security/synapse-workspace-synapse-rbachttps://docs.microsoft.com/en-us/security/benchmark/azure/baselines/synapse-analytics-security-baselinehttps://docs.microsoft.com/en-us/sql/relational-databases/security/row-level-security?view=sql-server-ver15QUESTION 110You have an Azure subscription that contains an Azure Data Factory version 2 (V2) data factory named df1. DF1 contains a linked service.You have an Azure Key vault named vault1 that contains an encryption kay named key1.You need to encrypt df1 by using key1.What should you do first?A. Disable purge protection on vault1.B. Remove the linked service from df1.C. Create a self-hosted integration runtime.D. Disable soft delete on vault1.Answer: BExplanation:A customer-managed key can only be configured on an empty data Factory. The data factory can't contain any resources such as linked services, pipelines and data flows. It is recommended to enable customer-managed key right after factory creation.Note: Azure Data Factory encrypts data at rest, including entity definitions and any data cached while runs are in progress. By default, data is encrypted with a randomly generated Microsoft-managed key that is uniquely assigned to your data factory.Incorrect Answers:A, D: Should enable Soft Delete and Do Not Purge on Azure Key Vault.Using customer-managed keys with Data Factory requires two properties to be set on the Key Vault, Soft Delete and Do Not Purge. These properties can be enabled using either PowerShell or Azure CLI on a new or existing key vault.Reference:https://docs.microsoft.com/en-us/azure/data-factory/enable-customer-managed-keyQUESTION 111A company plans to use Apache Spark analytics to analyze intrusion detection data.You need to recommend a solution to analyze network and system activity data for malicious activities and policy violations. The solution must minimize administrative efforts.What should you recommend?A. Azure Data Lake StorageB. Azure DatabricksC. Azure HDInsightD. Azure Data FactoryAnswer: BExplanation:Azure DataBricks does have integration with Azure Monitor. Application logs and metrics from Azure Databricks can be send to a Log Analytics workspace.Reference:https://docs.microsoft.com/en-us/azure/architecture/databricks-monitoring/application-logsQUESTION 112You have an Azure data solution that contains an enterprise data warehouse in Azure Synapse Analytics named DW1.Several users execute adhoc queries to DW1 concurrently.You regularly perform automated data loads to DW1.You need to ensure that the automated data loads have enough memory available to complete quickly and successfully when the adhoc queries run.What should you do?A. Assign a smaller resource class to the automated data load queries.B. Create sampled statistics to every column in each table of DW1.C. Assign a larger resource class to the automated data load queries.D. Hash distribute the large fact tables in DW1 before performing the automated data loads.Answer: CExplanation:The performance capacity of a query is determined by the user's resource class.Smaller resource classes reduce the maximum memory per query, but increase concurrency.Larger resource classes increase the maximum memory per query, but reduce concurrency.Reference:https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/resource-classes-for-workload-managementQUESTION 113You are monitoring an Azure Stream Analytics job.You discover that the Backlogged input Events metric is increasing slowly and is consistently non-zero.You need to ensure that the job can handle all the events.What should you do?A. Remove any named consumer groups from the connection and use $default.B. Change the compatibility level of the Stream Analytics job.C. Create an additional output stream for the existing input stream.D. Increase the number of streaming units (SUs).Answer: DExplanation:Backlogged Input Events: Number of input events that are backlogged. A non-zero value for this metric implies that your job isn't able to keep up with the number of incoming events. If this value is slowly increasing or consistently non-zero, you should scale out your job, by increasing the SUs.Reference:https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-monitoringQUESTION 114You have an Azure Stream Analytics job.You need to ensure that the job has enough streaming units provisioned.You configure monitoring of the SU % Utilization metric.Which two additional metrics should you monitor? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.A. Late Input EventsB. Out of order EventsC. Backlogged Input EventsD. Watermark DelayE. Function EventsAnswer: CDExplanation:To react to increased workloads and increase streaming units, consider setting an alert of 80% on the SU Utilization metric. Also, you can use watermark delay and backlogged events metrics to see if there is an impact.Note: Backlogged Input Events: Number of input events that are backlogged. A non-zero value for this metric implies that your job isn't able to keep up with the number of incoming events. If this value is slowly increasing or consistently non-zero, you should scale out your job, by increasing the SUs.Reference:https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-monitoringQUESTION 115You have an Azure Databricks resource.You need to log actions that relate to changes in compute for the Databricks resource.Which Databricks services should you log?A. clustersB. jobsC. DBFSD. SSHE. workspaceAnswer: AExplanation:Clusters logs include information regarding changes in compute.Incorrect:Not E: Workspace logs do not include information related to changes in compute.Reference:https://docs.microsoft.com/en-us/azure/databricks/administration-guide/account-settings/azure-diagnostic-logs#configure-diagnostic-log-deliveryQUESTION 116Your company uses Azure Stream Analytics to monitor devices.The company plans to double the number of devices that are monitored.You need to monitor a Stream Analytics job to ensure that there are enough processing resources to handle the additional load.Which metric should you monitor?A. Input Deserialization ErrorsB. Late Input EventsC. Early Input EventsD. Watermark delayAnswer: DExplanation:The Watermark delay metric is computed as the wall clock time of the processing node minus the largest watermark it has seen so far.The watermark delay metric can rise due to:1. Not enough processing resources in Stream Analytics to handle the volume of input events.2. Not enough throughput within the input event brokers, so they are throttled.3. Output sinks are not provisioned with enough capacity, so they are throttled.Reference:https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-time-handlingQUESTION 117You manage an enterprise data warehouse in Azure Synapse Analytics.Users report slow performance when they run commonly used queries. Users do not report performance changes for infrequently used queries.You need to monitor resource utilization to determine the source of the performance issues.Which metric should you monitor?A. Local tempdb percentageB. DWU percentageC. Data Warehouse Units (DWU) usedD. Cache hit percentageAnswer: DExplanation:You can use Azure Monitor to view cache metrics to troubleshoot query performance.The key metrics for troubleshooting the cache are Cache hit percentage and Cache used percentage.Possible scenario: Your current working data set cannot fit into the cache which causes a low cache hit percentage due to physical reads. Consider scaling up your performance level and rerun your workload to populate the cache.Reference:https://docs.microsoft.com/da-dk/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-how-to-monitor-cacheQUESTION 118You have an Azure Synapse Analytics dedicated SQL pool named Pool1 and a database named DB1.DB1 contains a fact table named Table.You need to identify the extent of the data skew in Table1.What should you do in Synapse Studio?A. Connect to Pool1 and query sys.dm_pdw_nodes_db_partition_stats.B. Connect to the built-in pool and run DBCC CHECKALLOC.C. Connect to Pool1 and run DBCC CHECKALLOC.D. Connect to the built-in pool and query sys.dm_pdw_nodes_db_partition_stats.Answer: AExplanation:First connect to Pool1, not the built-in serverless pool, then use sys.dm_pdw_nodes_db_partition_stats to analyze any skewness in the data.Reference:https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/cheat-sheetQUESTION 119You have an Azure Synapse Analytics dedicated SQL pool.You run PDW_SHOWSPACEUSED('dbo.FactInternetSales'); and get the results shown in the following table. Which statement accurately describes the dbo.FactInternetSales table?A. The table contains less than 10,000 rows.B. All distributions contain data.C. The table uses round-robin distributionD. The table is skewed.Answer: DExplanation:The rows per distribution can vary up to 10% without a noticeable impact on performance. Here the distribution varies more than 10%. It is skewed.Note: SHOWSPACEUSED displays the number of rows, disk space reserved, and disk space used for a specific table, or for all tables in a Azure Synapse Analytics or Parallel Data Warehouse database.This is a very quick and simple way to see the number of table rows that are stored in each of the 60 distributions of your database. Remember that for the most balanced performance, the rows in your distributed table should be spread evenly across all the distributions.ROUND_ROBIN distributed tables should not be skewed. Data is distributed evenly across the nodes by design.Reference:https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-distributehttps://github.com/rgl/azure-content/blob/master/articles/sql-data-warehouse/sql-data-warehouse-manage-distributed-data-skew.mdQUESTION 120You are designing a dimension table in an Azure Synapse Analytics dedicated SQL pool.You need to create a surrogate key for the table. The solution must provide the fastest query performance.What should you use for the surrogate key?A. an IDENTITY columnB. a GUID columnC. a sequence objectAnswer: AExplanation:Dedicated SQL pool supports many, but not all, of the table features offered by other databases.Surrogate keys are not supported. Implement it with an Identity column.Reference:https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-overviewQUESTION 121You are designing a star schema for a dataset that contains records of online orders. Each record includes an order date, an order due date, and an order ship date.You need to ensure that the design provides the fastest query times of the records when querying for arbitrary date ranges and aggregating by fiscal calendar attributes.Which two actions should you perform? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.A. Create a date dimension table that has a DateTime key.B. Create a date dimension table that has an integer key in the format of YYYYMMDD.C. Use built-in SQL functions to extract date attributes.D. Use integer columns for the date fields.E. Use DateTime columns for the date fields.Answer: BDExplanation:Why use a Date Dimension Table in a Data Warehouse.The Date dimension is one of these dimension tables related to the Fact. Here is a simple Data Diagram for a Data Mart of Internet Sales information for the Adventure Works DW database which can be obtained for free from CodePlex or other online sources. The relationship is created by the surrogate keys columns (integer data type) rather than the date data type.The query users have to write against a Data Mart are much simpler than against a transaction database. There are less joins because of the one to many relationships between the fact dimension table(s). The dimension tables are confusing to someone who has been normalizing databases as a career. The dimension is a flattened or de-normalized table. This creates cases of duplicate data, but the simplistic query overrides the duplicate data in a dimensional model.Reference:https://www.mssqltips.com/sqlservertip/3117/defining-role-playing-dimensions-for-sql-server-analysis-services/https://community.idera.com/database-tools/blog/b/community_blog/posts/why-use-a-date-dimension-table-in-a-data-warehouseQUESTION 122You have an Azure Data Factory pipeline that is triggered hourly.The pipeline has had 100% success for the past seven days.The pipeline execution fails, and two retries that occur 15 minutes apart also fail. The third failure returns the following error. What is a possible cause of the error?A. From 06:00 to 07:00 on January 10, 2021, there was no data in wwi/BIKES/CARBON.B. The parameter used to generate year=2021/month=01/day=10/hour=06 was incorrect.C. From 06:00 to 07:00 on January 10, 2021, the file format of data in wwi/BIKES/CARBON was incorrect.D. The pipeline was triggered too early.Answer: BExplanation:A file is missing.Incorrect:Not A, not C, not D: Time of the error is 07:45.QUESTION 123You need to trigger an Azure Data Factory pipeline when a file arrives in an Azure Data Lake Storage Gen2 container.Which resource provider should you enable?A. Microsoft.EventHubB. Microsoft.EventGridC. Microsoft.SqlD. Microsoft.AutomationAnswer: BExplanation:Event-driven architecture (EDA) is a common data integration pattern that involves production, detection, consumption, and reaction to events. Data integration scenarios often require Data Factory customers to trigger pipelines based on events happening in storage account, such as the arrival or deletion of a file in Azure Blob Storage account. Data Factory natively integrates with Azure Event Grid, which lets you trigger pipelines on such events.Reference:https://docs.microsoft.com/en-us/azure/data-factory/how-to-create-event-triggerQUESTION 124You have the following Azure Data Factory pipelines:- Ingest Data from System1- Ingest Data from System2- Populate Dimensions- Populate FactsIngest Data from System1 and Ingest Data from System2 have no dependencies. Populate Dimensions must execute after Ingest Data from System1 and Ingest Data from System2. Populate Facts must execute after the Populate Dimensions pipeline. All the pipelines must execute every eight hours.What should you do to schedule the pipelines for execution?A. Add a schedule trigger to all four pipelines.B. Add an event trigger to all four pipelines.C. Create a parent pipeline that contains the four pipelines and use an event trigger.D. Create a parent pipeline that contains the four pipelines and use a schedule trigger.Answer: DExplanation:https://www.mssqltips.com/sqlservertip/6137/azure-data-factory-control-flow-activities-overview/QUESTION 125You have an Azure Data Factory pipeline that performs an incremental load of source data to an Azure Data Lake Storage Gen2 account.Data to be loaded is identified by a column named LastUpdatedDate in the source table.You plan to execute the pipeline every four hours.You need to ensure that the pipeline execution meets the following requirements:- Automatically retries the execution when the pipeline run fails due to concurrency or throttling limits.- Supports backfilling existing data in the table.Which type of trigger should you use?A. tumbling windowB. on-demandC. eventD. scheduleAnswer: AExplanation:The Tumbling window trigger supports backfill scenarios. Pipeline runs can be scheduled for windows in the past.Incorrect Answers:D: Schedule trigger does not support backfill scenarios. Pipeline runs can be executed only on time periods from the current time and the future.Reference:https://docs.microsoft.com/en-us/azure/data-factory/concepts-pipeline-execution-triggersQUESTION 126You have an Azure Data Factory that contains 10 pipelines.You need to label each pipeline with its main purpose of either ingest, transform, or load. The labels must be available for grouping and filtering when using the monitoring experience in Data Factory.What should you add to each pipeline?A. an annotationB. a resource tagC. a run group IDD. a user propertyE. a correlation IDAnswer: AExplanation:Azure Data Factory annotations help you easily filter different Azure Data Factory objects based on a tag.You can define tags so you can see their performance or find errors faster.Reference:https://www.techtalkcorner.com/monitor-azure-data-factory-annotations/QUESTION 127Note: 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 answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.You have an Azure Data Lake Storage account that contains a staging zone.You need to design a daily process to ingest incremental data from the staging zone, transform the data by executing an R script, and then insert the transformed data into a data warehouse in Azure Synapse Analytics.Solution: You use an Azure Data Factory schedule trigger to execute a pipeline that executes mapping data flow, and then inserts the data into the data warehouse.Does this meet the goal?A. YesB. NoAnswer: BExplanation:Correct solution: You use an Azure Data Factory schedule trigger to execute a pipeline that executes an Azure Databricks notebook, and then inserts the data into the data warehouse.Reference:https://docs.microsoft.com/en-US/azure/data-factory/transform-dataQUESTION 128Note: 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 answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.You have an Azure Data Lake Storage account that contains a staging zone.You need to design a daily process to ingest incremental data from the staging zone, transform the data by executing an R script, and then insert the transformed data into a data warehouse in Azure Synapse Analytics.Solution: You schedule an Azure Databricks job that executes an R notebook, and then inserts the data into the data warehouse.Does this meet the goal?A. YesB. NoAnswer: BExplanation:Must use an Azure Data Factory, not an Azure Databricks job.Correct solution: You use an Azure Data Factory schedule trigger to execute a pipeline that executes an Azure Databricks notebook, and then inserts the data into the data warehouse.Reference:https://docs.microsoft.com/en-US/azure/data-factory/transform-dataQUESTION 129Note: 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 answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.You have an Azure Data Lake Storage account that contains a staging zone.You need to design a daily process to ingest incremental data from the staging zone, transform the data by executing an R script, and then insert the transformed data into a data warehouse in Azure Synapse Analytics.Solution: You use an Azure Data Factory schedule trigger to execute a pipeline that executes an Azure Databricks notebook, and then inserts the data into the data warehouse.Does this meet the goal?A. YesB. NoAnswer: AExplanation:An Azure Data Factory can trigger a Databricks notebook.Reference:https://docs.microsoft.com/en-us/azure/data-factory/transform-data-using-databricks-notebookQUESTION 130Note: 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 answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.You have an Azure Data Lake Storage account that contains a staging zone.You need to design a daily process to ingest incremental data from the staging zone, transform the data by executing an R script, and then insert the transformed data into a data warehouse in Azure Synapse Analytics.Solution: You use an Azure Data Factory schedule trigger to execute a pipeline that copies the data to a staging table in the data warehouse, and then uses a stored procedure to execute the R script.Does this meet the goal?A. YesB. NoAnswer: BExplanation:Azure Synapse Analytics does not support R script.Correct solution: You use an Azure Data Factory schedule trigger to execute a pipeline that executes an Azure Databricks notebook, and then inserts the data into the data warehouse.Reference:https://docs.microsoft.com/en-us/azure/architecture/data-guide/technology-choices/r-developers-guideQUESTION 131You plan to perform batch processing in Azure Databricks once daily.Which type of Databricks cluster should you use?A. automatedB. interactiveC. High ConcurrencyAnswer: AExplanation:Azure Databricks makes a distinction between all-purpose clusters and job clusters. You use all-purpose clusters to analyze data collaboratively using interactive notebooks. You use job clusters to run fast and robust automated jobs.The Azure Databricks job scheduler creates a job cluster when you run a job on a new job cluster and terminates the cluster when the job is complete.Reference:https://docs.microsoft.com/en-us/azure/databricks/clustersQUESTION 132Hotspot QuestionYou have an Azure Synapse Analytics dedicated SQL pool named Pool1 and an Azure Data Lake Storage Gen2 account named Account1.You plan to access the files in Account1 by using an external table.You need to create a data source in Pool1 that you can reference when you create the external table.How should you complete the Transact-SQL statement? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point. Answer: Explanation:Box 1: dfsFor Azure Data Lake Store Gen 2 used the following syntax:http[s] <storage_account>.dfs.core.windows.net/<container>/subfoldersIncorrect:Not blob: blob is used for Azure Blob Storage. Syntax:http[s] <storage_account>.blob.core.windows.net/<container>/subfoldersBox 2: TYPE = HADOOPSyntax for CREATE EXTERNAL DATA SOURCE.External data sources with TYPE=HADOOP are available only in dedicated SQL pools.CREATE EXTERNAL DATA SOURCE <data_source_name>WITH -( LOCATION = '<prefix>://<path>'[, CREDENTIAL = <database scoped credential> ], TYPE = HADOOP)[;]Reference:https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-external-tablesQUESTION 133Hotspot QuestionYou plan to develop a dataset named Purchases by using Azure Databricks. Purchases will contain the following columns:- ProductID- ItemPrice- LineTotal- Quantity- StoreID- Minute- Month- Hour- Year- DayYou need to store the data to support hourly incremental load pipelines that will vary for each StoreID. The solution must minimize storage costs.How should you complete the code? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point. Answer: Explanation:Box 1: .partitionByExample:df.write.partitionBy("y","m","d").mode(SaveMode.Append).parquet("/data/hive/warehouse/db_name.db/" + tableName)Box 2: ("Year","Month","Day","Hour","StoreID")Box 3: .parquet("/Purchases")Reference:https://intellipaat.com/community/11744/how-to-partition-and-write-dataframe-in-spark-without-deleting-partitions-with-no-new-dataQUESTION 134Hotspot QuestionYou are building a database in an Azure Synapse Analytics serverless SQL pool.You have data stored in Parquet files in an Azure Data Lake Storage Gen2 container.Records are structured as shown in the following sample. The records contain two applicants at most.You need to build a table that includes only the address fields.How should you complete the Transact-SQL statement? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point. Answer: Explanation:Box 1: CREATE EXTERNAL TABLEAn external table points to data located in Hadoop, Azure Storage blob, or Azure Data Lake Storage. External tables are used to read data from files or write data to files in Azure Storage. With Synapse SQL, you can use external tables to read external data using dedicated SQL pool or serverless SQL pool.Syntax:CREATE EXTERNAL TABLE { database_name.schema_name.table_name | schema_name.table_name | table_name }( <column_definition> [ ,...n ] )WITH (LOCATION = 'folder_or_filepath',DATA_SOURCE = external_data_source_name,FILE_FORMAT = external_file_format_nameBox 2. OPENROWSETWhen using serverless SQL pool, CETAS is used to create an external table and export query results to Azure Storage Blob or Azure Data Lake Storage Gen2.Example:ASSELECT decennialTime, stateName, SUM(population) AS population FROMOPENROWSET(BULK 'https://azureopendatastorage.blob.core.windows.net/censusdatacontainer/ release/us_population_county/year=*/*.parquet',FORMAT='PARQUET') AS [r]GROUP BY decennialTime, stateNameGOReference:https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-external-tablesQUESTION 135Hotspot QuestionFrom a website analytics system, you receive data extracts about user interactions such as downloads, link clicks, form submissions, and video plays.The data contains the following columns: You need to design a star schema to support analytical queries of the data. The star schema will contain four tables including a date dimension.To which table should you add each column? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point. Answer: Explanation:Box 1: DimEventBox 2: DimChannelDimension tables describe business entities - the things you model. Entities can include products, people, places, and concepts including time itself. The most consistent table you'll find in a star schema is a date dimension table. A dimension table contains a key column (or columns) that acts as a unique identifier, and descriptive columns.Box 3: FactEventsFact tables store observations or events, and can be sales orders, stock balances, exchange rates, temperatures, etc.Reference:https://docs.microsoft.com/en-us/power-bi/guidance/star-schemaQUESTION 136Drag and Drop QuestionYou plan to create a table in an Azure Synapse Analytics dedicated SQL pool.Data in the table will be retained for five years. Once a year, data that is older than five years will be deleted.You need to ensure that the data is distributed evenly across partitions. The solutions must minimize the amount of time required to delete old data.How should you complete the Transact-SQL statement? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all.You may need to drag the split bar between panes or scroll to view content.NOTE: Each correct selection is worth one point. Answer: Explanation:Box 1: HASHDISTRIBUTION = HASH ( distribution_column_name ) Assigns each row to one distribution by hashing the value stored in distribution_column_name. The algorithm is deterministic, which means it always hashes the same value to the same distribution. The distribution column should be defined as NOT NULL because all rows that have NULL are assigned to the same distribution.Box 2: OrderDateKeyIn most cases, table partitions are created on a date column.A way to eliminate rollbacks is to use Metadata Only operations like partition switching for data management. For example, rather than execute a DELETE statement to delete all rows in a table where the order_date was in October of 2001, you could partition your data early. Then you can switch out the partition with data for an empty partition from another table.Reference:https://docs.microsoft.com/en-us/sql/t-sql/statements/create-table-azure-sql-data-warehousehttps://docs.microsoft.com/en-us/azure/synapse-analytics/sql/best-practices-dedicated-sql-poolQUESTION 137Drag and Drop QuestionYou are creating a managed data warehouse solution on Microsoft Azure.You must use PolyBase to retrieve data from Azure Blob storage that resides in parquet format and load the data into a large table called FactSalesOrderDetails.You need to configure Azure Synapse Analytics to receive the data.Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. Answer: Explanation:To query the data in your Hadoop data source, you must define an external table to use in Transact-SQL queries. The following steps describe how to configure the external table.Step 1: Create a master key on database.1. Create a master key on the database. The master key is required to encrypt the credential secret.(Create a database scoped credential for Azure blob storage.)Step 2: Create an external data source for Azure Blob storage.2. Create an external data source with CREATE EXTERNAL DATA SOURCE..Step 3: Create an external file format to map the parquet files.3. Create an external file format with CREATE EXTERNAL FILE FORMAT.Step 4. Create an external table FactSalesOrderDetails4. Create an external table pointing to data stored in Azure storage with CREATE EXTERNAL TABLE.Reference:https://docs.microsoft.com/en-us/sql/relational-databases/polybase/polybase-configure-azure-blob-storageQUESTION 138Hotspot QuestionYou configure version control for an Azure Data Factory instance as 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 one point. Answer: Explanation:Box 1: adf_publishBy default, data factory generates the Resource Manager templates of the published factory and saves them into a branch called adf_publish. To configure a custom publish branch, add a publish_config.json file to the root folder in the collaboration branch. When publishing, ADF reads this file, looks for the field publishBranch, and saves all Resource Manager templates to the specified location. If the branch doesn't exist, data factory will automatically create it. And example of what this file looks like is below:{"publishBranch": "factory/adf_publish"}Box 2: /dwh_barchlet/ adf_publish/contososalesRepositoryName: Your Azure Repos code repository name. Azure Repos projects contain Git repositories to manage your source code as your project grows. You can create a new repository or use an existing repository that's already in your project.Reference:https://docs.microsoft.com/en-us/azure/data-factory/source-controlQUESTION 139Hotspot QuestionYou are performing exploratory analysis of bus fare data in an Azure Data Lake Storage Gen2 account by using an Azure Synapse Analytics serverless SQL pool.You execute the Transact-SQL query 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. Answer: Explanation:Box 1: CSV files that have file named beginning with "tripdata_2020"Box 2: a headerFIRSTROW = 'first_row'Specifies the number of the first row to load. The default is 1 and indicates the first row in the specified data file. The row numbers are determined by counting the row terminators. FIRSTROW is 1-based.Reference:https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/develop-openrowsetQUESTION 140Hotspot QuestionYou have an Azure subscription that is linked to a hybrid Azure Active Directory (Azure AD) tenant. The subscription contains an Azure Synapse Analytics SQL pool named Pool1.You need to recommend an authentication solution for Pool1. The solution must support multi-factor authentication (MFA) and database-level authentication.Which authentication solution or solutions should you include in the recommendation? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point. Answer: Explanation:Box 1: Azure AD authenticationAzure Active Directory authentication supports Multi-Factor authentication through Active Directory Universal Authentication.Box 2: Contained database usersAzure Active Directory Uses contained database users to authenticate identities at the database level.Incorrect:SQL authentication: To connect to dedicated SQL pool (formerly SQL DW), you must provide the following information:- Fully qualified servername- Specify SQL authentication- Username- Password- Default database (optional)Reference:https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-authenticationResources From:1.2023 Latest Braindump2go DP-300 Exam Dumps (PDF & VCE) Free Share:https://www.braindump2go.com/dp-300.html2.2023 Latest Braindump2go DP-300 PDF and DP-300 VCE Dumps Free Share:https://drive.google.com/drive/folders/14Cw_HHhVKoEylZhFspXeGp6K_RZTOmBF?usp=sharing3.2023 Free Braindump2go DP-300 Exam Questions Download:https://www.braindump2go.com/free-online-pdf/DP-300-PDF-Dumps(Q109-Q140).pdfFree Resources from Braindump2go,We Devoted to Helping You 100% Pass All Exams! --------------------------------------------------- Images: --------------------------------------------------- --------------------------------------------------- Post date: 2023-03-21 03:59:36 Post date GMT: 2023-03-21 03:59:36 Post modified date: 2023-03-21 03:59:36 Post modified date GMT: 2023-03-21 03:59:36 ____________________________________________________________________________________________ Export of Post and Page as text file has been powered by [ Universal Post Manager ] plugin from www.gconverters.com