Get Full Version of the Examhttp://www.EnsurePass.com/AZ-103.html Question No.21You have an azure subscription named Subscription that contains the resource groups shown in the following table.In RG1, you create a virtual machine named VM1 in the East Asia location. You plan to create a virtual network named VNET1.You need to create VNET, and then connect VM1 to VNET1.What are two possible ways to achieve this goal? Each correct answer presents a complete a solution.NOTE: Each correct selection Read more [...]
Get Full Version of the Examhttp://www.EnsurePass.com/AZ-103.html Question No.11Click to expand each objective. To connect to the Azure portal, type https://portal.azure.com in the browser address bar. Read more [...]
Get Full Version of the Examhttp://www.EnsurePass.com/AZ-103.html Question No.1You have a resource group named RG1. RG1 contains an Azure Storage account named storageaccount1 and a virtual machine named VM1 that runs Windows Server 2016.Storageaccount1 contains the disk files for VM1. You apply a ReadOnly lock to RG1. What can you do from the Azure portal?Generate an automation script for RG1.View the keys of storageaccount1.Upload a blob to storageaccount1.Start VM1.Correct Answer: BExplanation:ReadOnly Read more [...]
Get Full Version of the Examhttp://www.EnsurePass.com/AZ-102.html Question No.61You have an Azure subscription that contains a virtual machine named VM1. VM1 hosts a line-of- business application that is available 24 hours a day. VM1 has one network interface and one managed disk. VM1 uses the D4s v3 size.You plan to make the following changes to VM1:Change the size to D8s v3. Add a 500-GB managed disk.Add the Puppet Agent extension. Attach an additional network interface.Which change will cause Read more [...]
Get Full Version of the Examhttp://www.EnsurePass.com/AZ-102.html Question No.51You have an Active Directory forest named contoso.com.You install and configure Azure AD Connect to use password hash synchronization as the single sign-on (SSO) method. Staging mode is enabled.You review the synchronization results and discover that the Synchronization Service Manager does not display any sync jobs.You need to ensure that the synchronization completes successfully. What should you do?From Synchronization Read more [...]
Get Full Version of the Examhttp://www.EnsurePass.com/AZ-102.html Question No.41Note: 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 Read more [...]
Get Full Version of the Examhttp://www.EnsurePass.com/AZ-102.html Question No.31Your company registers a domain name of contoso.com.You create an Azure DNS named contoso.com and then you add an A record to the zone for a host named www that has an IP address of 131.107.1.10.You discover that Internet hosts are unable to resolvewww.contoso.comto the 131.107.1.10 IP address.You need to resolve the name resolution issue.Solution: You add an NS record to the contoso.com zone. Does this meet the goal?YesNoCorrect Read more [...]
Get Full Version of the Examhttp://www.EnsurePass.com/AZ-102.html Question No.21You have a Recovery Service vault that you use to test backups. The test backups contain two protected virtual machines.You need to delete the Recovery Services vault. What should you do first?From the Recovery Service vault, stop the backup of each backup item.From the Recovery Service vault, delete the backup data.Modify the disaster recovery properties of each virtual machine.Modify the locks of each virtual machine.Correct Read more [...]
Get Full Version of the Examhttp://www.EnsurePass.com/AZ-102.html Question No.11Click to expand each objective. To connect to the Azure portal, type https://portal.azure.com in the browser address bar.When you are finished performing all the tasks, click the `Next#39; button.Note that you cannot return to the lab once you click the `Next#39; button. Scoring occur in the background while you complete the rest of the exam.OverviewThe following section of the exam is a lab. In this section, you will Read more [...]
Get Full Version of the Examhttp://www.EnsurePass.com/AZ-102.html Question No.1You have two subscriptions named Subscription1 and Subscription2. Each subscription is associated to a different Azure AD tenant.Subscription1 contains a virtual network named VNet1.VNet1 contains an Azure virtual machine named VM1 and has an IP address space of 10.0.0.0/16.Subscription2 contains a virtual network named VNet2. VNet2 contains an Azure virtual machine named VM2 and has an IP address space of 10.10.0.0/24.You Read more [...]
Get Full Version of the Examhttp://www.EnsurePass.com/AZ-101.html Question No.1Note: 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 Read more [...]
Get Full Version of the Examhttp://www.EnsurePass.com/AZ-100.html Question No.41Click to expand each objective. To connect to the Azure portal, type https://portal.azure.com in the browser address bar.When you are finished performing all the tasks, click the `Next#39; button.Note that you cannot return to the lab once you click the `Next#39; button. Scoring occur in the background while you complete the rest of the exam.OverviewThe following section of the exam is a lab. In this section, you will Read more [...]
Get Full Version of the Examhttp://www.EnsurePass.com/AZ-100.html Question No.31Click to expand each objective. To connect to the Azure portal, type https://portal.azure.com in the browser address bar.When you are finished performing all the tasks, click the `Next#39; button.Note that you cannot return to the lab once you click the `Next#39; button. Scoring occur in the background while you complete the rest of the exam.OverviewThe following section of the exam is a lab. In this section, you will Read more [...]
Get Full Version of the Examhttp://www.EnsurePass.com/AZ-100.html Question No.21HOTSPOTYou have an Azure subscription named Subscription1. Subscription1 contains the resources in the following table.In Azure, you create a private DNS zone named adatum.com. You set the registration virtual network to VNet2. The adatum.com zone is configured as shown in the following exhibit.For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection Read more [...]
Get Full Version of the Examhttp://www.EnsurePass.com/AZ-100.html Question No.11DRAG DROPYou have an Azure subscription that contains a storage account.You have an on-premises server named Server1 that runs Window Server 2016. Server1 has 2 TB of data.You need to transfer the data to the storage account by using the Azure Import/Export service. In which order should you perform the actions?To answer, move all actions from the list of actions to the answer area and arrange them in the correct order.NOTE: Read more [...]
Get Full Version of the Examhttp://www.EnsurePass.com/AZ-100.html Question No.1Your company registers a domain name of contoso.com.You create an Azure DNS named contoso.com and then you add an A record to the zone for a host named www that has an IP address of 131.107.1.10.You discover that Internet hosts are unable to resolve www.contoso.com to the 131.107.1.10 IP address.You need to resolve the name resolution issue.Solution: You modify the SOA record in the contoso.com zone Does this meet the Read more [...]
Get Full Version of the Examhttp://www.EnsurePass.com/AI-100.html Question No.41Note: 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 Read more [...]
Get Full Version of the Examhttp://www.EnsurePass.com/AI-100.html Question No.31Note: 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 Read more [...]
Get Full Version of the Examhttp://www.EnsurePass.com/AI-100.html Question No.21You plan to deploy Azure loT Edge devices that will each store more than 10,000 images locally and classify the images by using a Custom Vision Service classifier. Each image is approximately 5 MB.You need to ensure that the images persist on the devices for 14 days. What should you use?the device cacheAzure Blob storage on the loT Edge devicesAzure Stream Analytics on the loT Edge devicesMicrosoft SQL Server on the Read more [...]
Get Full Version of the Examhttp://www.EnsurePass.com/AI-100.html Question No.11Your company plans to implement an Al solution that will analyse data from loT devices.Data from the devices will be analysed in real time. The results of the analysis will be stored in a SQL database.You need to recommend a data processing solution that uses the Transact-SQL language. Which data processing solution should you recommend?Azure Stream AnalyticsSQL Server Integration Services (SSIS)Azure Event HubsAzure Read more [...]
Get Full Version of the Examhttp://www.EnsurePass.com/AI-100.html Question No.1Note: 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, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.You Read more [...]
Get Full Version of the Examhttp://www.EnsurePass.com/70-778.html Question No.11Note: This question is part of a series of questions that present the same scenario. Each question in the series contain 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 mil not appear in the review Read more [...]
Get Full Version of the Examhttp://www.EnsurePass.com/70-778.html Question No.1Note: This question it part of a series of questions that use the same scenario. For your convenience, the scenario is repeated In each question. Each question presents a different goal and answer choices, but the text of the scenario is the same in each question in this series.Start of repeated scenarioYou have a Microsoft SQL Server database that contains the following tables.The Oder table contains more than one Read more [...]
Get Full Version of the Examhttp://www.EnsurePass.com/70-768.html Question No.1Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets the stated goals.You have a Microsoft SQL Server Analysis Services (SSAS) multidimensional database that stores customer and order data for customers in the United States only. The database contains the following objects:You must create a KPI Read more [...]
Get Full Version of the Examhttp://www.EnsurePass.com/70-767.html Question No.181You have a server named SQL1 that has SQL Server Integration Services (SSIS) installed. SQL1 has eight CPUs, 8 GB of RAM, RAID-1 storage, and a 10-gigabit Ethernet connection.A package named Package1 runs on SQL1. Package1 contains 10 data tasks. Package1 queries 3 GB of data from the source system.You review the performance statistics on SQL1 and discover that Package1 executes slower than expected.You need to identify Read more [...]
Get Full Version of the Examhttp://www.EnsurePass.com/70-767.html Question No.171You have a SQL server integration Services (SSIS) package named package1. You discover that the Data Flow task for Package1 runs slower than expected.You need to reduce the amount of time required to run the Data Flow task. Which two actions should you perform? (Select Two)Configure the package to run by using the CallerInfo option.Modify the DefaultBufferSize package setting.Modify the ForceExecutionResult Package Read more [...]
Get Full Version of the Examhttp://www.EnsurePass.com/70-767.html Question No.161HOTSPOTYou have a data warehouse that is hosted in a SQL Server instance. The data in the data warehouse is loaded by running bcp.exe You discover that the transaction logs regularly fill up the local hard disk on the server and that a WRITELOG wait is present. You need to reduce the amount of disk space used to store the transaction logs and to remove the WRI7TLOG wait.Which two database property settings should Read more [...]
Get Full Version of the Examhttp://www.EnsurePass.com/70-767.html Question No.151HOTSPOTYou are developing a SQL Server Integration Services (SSIS) package.The package must run a parameterized query against a Windows Azure SQL Database database. You need to use the least amount of development effort to meet the package requirement.Which task should you use?To answer, select the appropriate task in the answer area.Correct Answer: Question No.152You are designing a data warehouse that uses SQL Server Read more [...]
Get Full Version of the Examhttp://www.EnsurePass.com/70-767.html Question No.141HOTSPOTYou are developing a SQL Server Integration Services (SSIS) package. The data source for the data flow task is a table that has been configured as a change data capture (CDC) table. You are using a CDC Source component to obtain the CDC data.The CDC Source component has the following requirements:The output must include metadata columns that indicate which source columns have changed.The output must return Read more [...]
Get Full Version of the Examhttp://www.EnsurePass.com/70-767.html Question No.131You are developing a data flow transformation to merge two data sources. One source contains product data and the other source contains data about the country in which the product was manufactured. Both data sources contain a two-character CountryCode column and both use SQL Server. Both data sources contain an ORDER BY clause to sort the data by the CountryCode column in ascending order.You use a Merge Join transformation Read more [...]
Get Full Version of the Examhttp://www.EnsurePass.com/70-767.html Question No.121You are designing an enterprise star schema that will consolidate data from three independent data marts. One of the data marts is hosted on SQL Azure.Most of the dimensions have the same structure and content. However, the geography dimension is slightly different in each data mart.You need to design a consolidated dimensional structure that will be easy to maintain while ensuring that all dimensional data from the Read more [...]
Get Full Version of the Examhttp://www.EnsurePass.com/70-767.html Question No.111DRAG DROPYou are the administrator for a Data Quality Server. You are adding a user who must have permission to:Edit and execute a projectView the activity monitoring data This user must not be able to:Perform any kind of knowledge managementCreate or change a knowledge baseTerminate an activity or perform administrative dutiesYou need to develop a Transact-SQL (T-SQL) script to meet these requirements. What should Read more [...]
Get Full Version of the Examhttp://www.EnsurePass.com/70-767.html Question No.101You are developing a SQL Server Integration Services (SSIS) package that imports data into a data warehouse hosted on SQL Azure.The package uses a Foreach container to process text files found in a folder. The package must be deployed to a single server by using the Project Deployment model.Multiple SQL Server Agent jobs call the package. Each job is executed on a different schedule. Each job passes a different folder Read more [...]
Get Full Version of the Examhttp://www.EnsurePass.com/70-767.html Question No.91You are adding a new capability to several dozen SQL Server Integration Services (SSIS) packages.The new capability is not available as an SSIS task. Each package must be extended with the same new capability.You need to add the new capability to all the packages without copying the code between packages.What should you do?Use the Expression task.Use the Script task.Develop a custom task.Use the Script component,Develop Read more [...]
Get Full Version of the Examhttp://www.EnsurePass.com/70-767.html Question No.81You administer a Microsoft SQL Server 2016 database. The database contains a table named Employee. Part of the Employee table is shown in the exhibit. (Click the Exhibit button.)Confidential information about the employees is stored in a separate table named EmployeeData. One record exists within EmployeeData for each record in the Employee table. You need to assign the appropriate constraints and table properties Read more [...]
Get Full Version of the Examhttp://www.EnsurePass.com/70-767.html Question No.71You are designing a data warehouse with two fact tables. The first table contains sales per month and the second table contains orders per day.Referential integrity must be enforced declaratively.You need to design a solution that can join a single time dimension to both fact tables. What should you do?Create a view on the sales table.Partition the fact tables by day.Create a surrogate key for the time dimension.Change Read more [...]