You need to complete the post-installation configuration
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?
You need to ensure that the SQL Server instance can use all nodes of the cluster
You administer a Microsoft SQL Server 2012 failover cluster that contains two nodes named
Node A and Node B. A single instance of SQL Server is installed on the cluster.
An additional node named Node C has been added to the existing cluster.
You need to ensure that the SQL Server instance can use all nodes of the cluster.
What should you do?
Which three actions should you perform in sequence?
DRAG DROP
You administer a single Microsoft SQL Server instance on a two-node failover cluster that
has nodes named Node A and Node B. The instance is currently running on Node A
You want to patch both Node A and Node B by using the most recent SQL Server Service Pack.
You need to ensure that the following requirements are met:
Both nodes receive the update.
Downtime is minimized.
No data is lost.
Which three 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.)
Which hierarchy type should you use?
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-tosubordinate relationships.
You need to create a hierarchy representing the organizational structure of the company.
Which hierarchy type should you use?
You need to ensure that the minimum amount of disk space is used to store the data in the Product table
You administer a Microsoft SQL Server 2012 database.
The database contains a Product table created by using the following definition:
You need to ensure that the minimum amount of disk space is used to store the data in the
Product table.
What should you do?
You need to produce the CSV file with the least amount of development effort
You are the data steward for a Business Intelligence project.
You must identify duplicate rows stored in a SQL Server table and output discoveries to a
CSV file. A Data Quality Services (DQS) knowledge base has been created to support this
project.
You need to produce the CSV file with the least amount of development effort.
What should you do?
You need to be able to start the SQL Server
You administer a Microsoft SQL Server 2012 instance. After a routine shutdown, the drive
that contains tempdb fails.
You need to be able to start the SQL Server.
What should you do?
You need to design a solution that gives the application access to the product data with the least amount of d
You manage a SQL Server Master Data Services (MDS) environment.
A new application requires access to the product data that is available in the MDS
repository.
You need to design a solution that gives the application access to the product data with the
least amount of development effort.
What should you do?
You need to ensure that the application login is unable to access other production databases
You administer a single server that contains a Microsoft SQL Server 2012 default instance.
You plan to install a new application that requires the deployment of a database on the
server. The application login requires sysadmin permissions.
You need to ensure that the application login is unable to access other production
databases.
What should you do?
Which SQL Server application should you use?
You are installing SQL Server Data Quality Services (DQS).
You need to give users belonging to a specific Active Directory group access to the Data
Quality Server.
Which SQL Server application should you use?