Microsoft 70-462 Exam Practice Test Instant Access

Question 1

You install a Microsoft SQL Server 2012 instance.

The instance will store data extracted from two databases running on Windows Azure SQL Database.

You hire a data steward to perform interactive data cleansing and ad hoc querying and updating of the database.

You need to ensure that the data steward is given the correct client tools to perform these tasks.

Which set of tools should you install?

ASQL Server Management Studio and Distributed Replay Client

BMaster Data Services and Data Quality Client

CData Quality Client and Distributed Replay Client

DData Quality Client and SQL Server Management Studio

Answer : B

References:

https://www.mssqltips.com/sqlservertutorial/3802/sql-server-master-data-services-architecture/

Question 2

You are designing a SQL Server Integration Services (SSIS) package that uses the Fuzzy Lookup transformation.

The reference data to be used in the transformation does not change.

You need to reuse the Fuzzy Lookup match index to increase performance and reduce maintenance.

What should you do?

ASelect the GenerateAndPersistNewIndex option in the Fuzzy Lookup Transformation Editor.

BSelect the GenerateNewIndex option in the Fuzzy Lookup Transformation Editor.

CSelect the DropExistingMatchIndex option in the Fuzzy Lookup Transformation Editor.

DExecute the sp_FuzzyLookupTableMaintenanceUninstall stored procedure.

EExecute the sp_FuzzyLookupTableMaintenanceInvoke stored procedure.

Answer : A

References:

http://msdn.microsoft.com/en-us/library/ms137786.aspx

Question 3

You are developing a SQL Server Integration Services (SSIS) package.

You need to design a package to change a variable value during package execution by using the least amount of development effort.

What should you use?

AExpression task

BScript task

CExecute SQL task

DExecute Process task

ETerm Extraction transformation

Answer : A

References:

http://msdn.microsoft.com/en-us/library/hh213137.aspx

Question 4

You are creating a SQL Server Master Data Services (MDS) model for a company.

The source data for the company is stored in a single table that contains the manager-to-subordinate relationships.

You need to create a hierarchy representing the organizational structure of the company.

Which hierarchy type should you use?

ANatural

BExplicit

CParent

DRecursive

Answer : D

Question 5

You are completing the installation of the Data Quality Server component of SQL Server Data Quality Services (DQS).

You need to complete the post-installation configuration.

What should you do?

ARun the Configuration component in the Data Quality Client.

BInstall ADOMD.NET.

CRun the Data Quality Server Installer.

DMake the data available for DQS operations.

Answer : C

After you complete the SQL Server installation wizard, you must perform additional steps mentioned in this section to complete your Data Quality Server installation, configure it, and then use it.

To complete the Data Quality Server installation, run the DQSInstaller.exe file.

References:

https://docs.microsoft.com/en-us/sql/data-quality-services/install-windows/install-data-quality-services?view=sql-server-2017#PostInstallationTasks

Question 6

You are the administrator of a Microsoft SQL Server 2012 server.

Some applications consume significant resources.

You need to manage the server workload by restricting resource-intensive applications. You need to dynamically limit resource consumption.

What should you do?

ASet up Service Broker to ensure that applications are not allowed to consume more than the specified amount of resources.

BConfigure Resource Pools, Workload Groups, and Classifier Function, and then enable the Resource Governor.

CConfigure Extended Events to monitor and restrict resource limits allowed by each application type.

DCreate a new Plan Guide with a Scope Type of SQL and define the resource limits for each application.

Answer : B

SQL Server Resource Governor is a feature than you can use to manage SQL Server workload and system resource consumption. Resource Governor enables you to specify limits on the amount of CPU, physical IO, and memory that incoming application requests can use.

The following three concepts are fundamental to understanding and using Resource Governor:

References:

https://docs.microsoft.com/en-us/sql/relational-databases/resource-governor/resource-governor

Question 7

You plan to migrate the database to Azure. You verify that all objects are valid for Azure SQL database. You need to ensure that users and logins are migrated to Azure.

What should you do?

AUse the Copy Database wizard

BUse the Database Transfer wizard

CUse the SQL Management Studio to deploy the database to Azure

DBack up the database from the local server and restore it to Azure

Answer : C

Use SQL Server Management Studio to establish a connection to your Azure SQL Database server.

Steps:

Create an empty Azure SQL database in the Azure portal (using a new or existing Azure SQL Database server)

Create a server-level firewall in the Azure portal (if not previously created)

Use the Data Migration Assistant (DMA) to import your SQL Server database into the empty Azure SQL database

Use SQL Server Management Studio (SSMS) to change database properties.

References:

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-migrate-your-sql-server-database

Microsoft 70-462 Administering Microsoft SQL Server 2012 Databases Exam Practice Test