DP-300 latest questions

 You have 20 Azure SQL databases provisioned by using the vCore purchasing model. You plan to create an Azure SQL Database elastic pool and add the 20 databases. Which three metrics should you use to size the elastic pool to meet the demands of your workload? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point. A. total size of all the databases B. geo-replication support C. number of concurrently peaking databases * peak CPU utilization per database D. maximum number of concurrent sessions for all the databases E. total number of databases * average CPU utilization per database




Answer: ACE



You are designing a streaming data solution that will ingest variable volumes of data. You need to ensure that you can change the partition count after creation. Which service should you use to ingest the data? A. Azure Event Hubs Standard B. Azure Stream Analytics C. Azure Data Factory D. Azure Event Hubs Dedicated


Answer: D




You have an Azure Synapse Analytics workspace named WS1 that contains an Apache Spark pool named Pool1. You plan to create a database named DB1 in Pool1. You need to ensure that when tables are created in DB1, the tables are available automatically as exterYou have a SQL pool in Azure Synapse that contains a table named dbo.Customers. The table contains a column name Email. You need to prevent nonadministrative users from seeing the full email addresses in the Email column. The users must see values in a format of [email protected] instead. What should you do? A. From the Azure portal, set a mask on the Email column. B. From the Azure portal, set a sensitivity classification of Confidential for the Email column. C. From Microsoft SQL Server Management Studio, set an email mask on the Email column. D. From Microsoft SQL Server Management Studio, grant the SELECT permission to the users for all the columns in the dbo.Customers table except Email. Answer: Anal tables to the built-in serverless SQL pool. Which format should you use for the tables in DB1? A. JSON B. CSV C. Parquet D. ORC Answer: C



You need to reduce the time it takes for cluster1 to start and scale up. The solution must minimize costs. What should you do first? A. Upgrade workspace1 to the Premium pricing tier. B. Configure a global init script for workspace1. C. Create a pool in workspace1. D. Create a cluster policy in workspace1. Answer: C



You have an on-premises Microsoft SQL server that uses the FileTables and Filestream features. You plan to migrate to Azure SQL. Which service should you use? A. Azure SQL Database B. SQL Server on an Azure Virtual Machine C. Azure SQL Managed Instance D. Azure Database for MySQL Answer: B


You have an Azure SQL database named DB1. You have a table name Table1 that has 20 columns of type CHAR(400). Row compression for Table1 is enabled. During a database audit, you discover that none of the fields contain more than 150 characters. You need to ensure that you can apply page compression to Table1. What should you do? A. Configure the columns as sparse. B. Change the column type to NVARCHAR(MAX). C. Change the column type to VARCHAR(MAX). D. Change the column type to VARCHAR(200).


You have an Azure subscription. You need to deploy a new Azure SQL database by using Azure Command-Line Interface (CLI). Which three parameters are required? A.--name, --edition, and --capacity B.--name, --tier, and --min-capacity C.--name, --resource-group, and --server D.--name, --licence-type, and --capacity Answer: C Explanation: --name, --resource-group, and --server 



 

Comments

Post a Comment

Popular posts from this blog

renewal of DP-300 exam questions

Image
  According to Microsoft SQL Server configuration best practices, what should you do to configure cach According to Microsoft SQL Server configuration best practices, what should you do to configure caching on volumes that host log files? Select only one answer. Enable read caching only. Enable write caching only. Enable read and write caching. Disable all caching. You plan to deploy Microsoft SQL Server 2019 to an Azure virtual machine that has eight CPUs and four disks. You expect that SQL Server will run tempdb heavy-workloads. You need to optimize the performance of tempdb. What should you do? Select only one answer. Store tempdb in eight files of the same size. Store tempdb in four files. Configure one of the files to have the size matching the amount of memory allocated to SQL Server. Enable trace flag 1117. Enable trace flag 1118. : You plan to implement SQL Server on an Azure virtual machine that has managed disks. You need to ensure that the virtual machine disks hosting t...
Read more

DP-300 dumps

Image
 Question #1 Topic 1 You have 20 Azure SQL databases provisioned by using the vCore purchasing model. You plan to create an Azure SQL Database elastic pool and add the 20 databases. Which three metrics should you use to size the elastic pool to meet the demands of your workload? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point. A. total size of all the databases B. geo-replication support C. number of concurrently peaking databases * peak CPU utilization per database D. maximum number of concurrent sessions for all the databases E. total number of databases * average CPU utilization per database Correct Answer: ACE  CE: Estimate the vCores needed for the pool as follows: For vCore-based purchasing model: MAX(<Total number of DBs X average vCore utilization per DB>, <Number of concurrently peaking DBs X Peak vCore utilization per DB) A: Estimate the storage space needed for the pool by adding the number of bytes needed for ...
Read more

DP-300(30-60 questions)

Image
  You have an Azure virtual machine named VM1 on a virtual network named VNet1. Outbound traffic from VM1 to the internet is blocked. You have an Azure SQL database named SqlDb1 on a logical server named SqlSrv1. You need to implement connectivity between VM1 and SqlDb1 to meet the following requirements: ✑ Ensure that all traffic to the public endpoint of SqlSrv1 is blocked. ✑ Minimize the possibility of VM1 exfiltrating data stored in SqlDb1.  What should you create on VNet1?  A. a VPN gateway  B. a service endpoint  C. a private link  D. an ExpressRoute gateway  Correct Answer: C  You have 40 Azure SQL databases, each for a different customer. All the databases reside on the same Azure SQL Database server. You need to ensure that each customer can only connect to and access their respective database. Which two actions should you perform? Each correct answer presents part of the solution.  NOTE: Each correct selection is worth one point. A. Imp...
Read more