Which configuration should you use?
You administer all the deployments of Microsoft SQLServer 2012 in your company.
You need to ensure that data changes are sent to a non-SQL Server database server in
near real time.
You also need to ensure that data on the primary server is unaffected.
Which configuration should you use?
Which configuration should you use?
You administer all the deployments of Microsoft SQLServer 2012 in your company.
A database contains a large product catalog that isupdated periodically.
You need to be able to send the entire product catalog to all branch offices on a monthly basis.
Which configuration should you use?
Which configuration should you use?
You administer all the deployments of Microsoft SQLServer 2012 in your company.
You need to ensure that an OLTP database that uses a storage area network (SAN)
remains available if any of the servers fail.
You also need to minimize the amount of storage used by the database.
Which configuration should you use?
How would you modify the instance to render these extensions?
You work as a database administrator at ABC.com. The ABC.com network contains a SQL Server
2008 database server named ABC-DB01, which hosts the SQL Server 2008 Reporting Services
(SSRS) instance.
During routine monitoring, you discover that this instance does not render any extensions for
Microsoft Office Word.
How would you modify the instance to render these extensions?
How can this be achieved?
You work as a database administrator for ABC.com. The ABC.com network contains a SQL
Server 2008 database server named ABC-DB03.
You are in the process of designing a SQL Server 2008 Integration Services (SSIS) package for
the ABC.com network. ABC.com has informed you that ABC-DB03 will be hosting the package.
You receive an instruction from the CIO to devise a plan of action in the event that ABC-DB03
becomes inactive.
How can this be achieved?
Which of the following options will make sure that the Marketing division is only able to access 10 tables?
You work as a database administrator at ABC.com. You are responsible for managing a SQL
Server 2008 database server named ABC-DB01.
You receive instruction that the SQL Server 2008 Reporting Services model needs to be deployed
on ABC-DB01 to support a data source that contains 800 tables for the Marketing division. You
have been tasked with developing a report model.
Which of the following options will make sure that the Marketing division is only able to access 10
tables? (Choose two)
Identify the command that will help you to accomplish your task?
You work as a database administrator at ABC.com. The ABC.com network contains a SQL Server
2008 database server named ABC-DB01. ABC-DB01 is configured to host the SQL Server
Analysis Services (SSAS) role.
There is a dimension named Housing in ABC-DB01 that contains three properties named Slabs,
Cement and Bricks. The relationship between the properties is nonflexible. Currently a data source
is used that indicates the changes between the affiliations of the properties. You receive an
instruction from the CIO to ensure that any modifications will be reflected.
Identify the command that will help you to accomplish your task?
What should your next step be?
You work as a database administrator at ABC.com. Your duties include administering a SQL
Server 2008 Analysis Services (SSAS) sample named ABC-DB01.
You receive an instruction from the CIO to log all queries. You then decide to make the necessary
changes to the QueryLogconnection String feature.
What should your next step be?
Which of the following actions should you take?
You work as a database administrator at ABC.com. Your duties include administrating a SQL
Server 2008 server database named ABC-DB05, which hosts the SQL Server Analysis Services
(SSAS) role.
While querying ABC-DB05, you are presented with a Duplicate Key error. You receive an
instruction from the CIO to make minor modifications to the ErrorConfiguration feature to resolve
this problem.
Which of the following actions should you take?
Identify the command that will assist you in updating the partition?
You work as a database administrator for ABC.com. Your duties include administrating a SQL
Server 2008 server database named ABC-DB01 that contains a single partition. ABC-DB01 is
hosting a SQL Server 2008 Analysis Services (SSAS) role.
You are tasked with the responsibility of ensuring that information is updated in the partition every
thirty minutes.
Identify the command that will assist you in updating the partition?