what action should you perform?
You are a database developer and you have about two years experience in creating
business intelligence (BI) solutions by using SQL Server2008.
You are employed in a company which is named NaproStar and work as the technical
support for the company which uses SQL Server2008.
Now you are in charge of a SQL Server 2008 Reporting Services (SSRS) instance.
Currently the network security model of the instance under the domain has changed.
Your manager requires you to make sure that only Kerberos authentication will be supported
by the instance.
In order to meet the requirements, what action should you perform?
which one should you utilize?
You are a professional level SQL Sever 2008 Database Administrator. You are experienced
in managing databases in an enterprise-level organization, optimizing and sustaining the
database life cycle. In the company, your job is to implement solutions on security,
troubleshooting, deployment and optimization. A SQL Server 2008 infrastructure is
managed by you. A database is utilized by the instance, and the database is utilized by a
Web-based application. 15,000 transactions are processed by the application every minute.
A column is contained by a table in the database, and the column is utilized only by the
application. Sensitive data is stored in this column. The sensitive data should be stored with
the highest security level. In addition, the least amount of memory space and processor
time should be utilized. From the following four encryption types, which one should you
utilize?
What action should you perform?
You are a database developer and you have about two years experience in creating
business intelligence (BI) solutions by using SQL Server2008. Now you are employed in a
company which is named NaproStar and work as the technical support for the company
which uses SQL Server2008. You are in charge of a SQL Server 2008 Reporting Services
(SSRS) instance with several reports contained. Then you use the Business Intelligence
Development Studio (BIDS) to have a report project configured on the instance. After the
deployment, you notice that the test data sources of the report project substitute the
production data sources on the instance, so you should find a solution to make sure that the
deployment of the report project in future will not affect the existing reports, that is to say, all
the data in the existing reports will not be changed or replaced.
What action should you perform?
What should you do to make the instance return to its initial status?
You are a database developer and you have about two years experience in creating
business intelligence (BI) solutions by using SQL Server2008. Now you are employed in a
company which is named NaproStar and work as the technical support for the company
which uses SQL Server2008. You are in charge of a SQL Server 2008 Reporting Services
(SSRS) instance. Accidentally, you find that 1000 reports are deployed on the SSRS
instance by a developer, so your manager asks you to find a solution to prevent these
reports from deploying on the SSRS instance so that it can be restored to its initial status.
What should you do to make the instance return to its initial status?
You need to design a view or views to meet the following requirements: ·The SalesDetails table cannot be
You are a SQL Server 2008 developer. You create an online transaction processing (OLTP)
database by using SQL Server 2008 in an enterprise environment. The database contains a
table named SalesDetails. Each record in the table contains data in any one of the following
pairs of nullable columns: ·InternetSalesTargets and InternetSales ·ResellerSalesTargets
and ResellerSales ·ForeignSalesTargets and ForeignSales The table also contains three
NOT NULL key columns. A large number of records are inserted on a daily basis into the
SalesDetails table. Summary reports are generated from the SalesDetails table. Each report
is based on aggregated data from any one of the pairs of nullable columns. You need to
design a view or views to meet the following requirements: ·The SalesDetails table cannot
be directly modified. ·The performance of the reports is maximized. ·The amount of storage
space for each report is minimized. What should you do?
which one should you modify to achieve that goal?
You are a database developer and you have about two years experience in creating
business intelligence (BI) solutions by using SQL Server2008. Now you are employed in a
company which is named NaproStar and work as the technical support for the company
which uses SQL Server2008. To meet the development requirements, you have SQL Server
2008 Reporting Services (SSRS) instance installed and configured on your network.
According to the intention of the users of the report server, e-mail messages will be used to
delivered reports. Now you get an order from the CIO that a remote SMTP server should be
used to configure the report server so that reports can be delivered through e-mail message.
So of the following files, which one should you modify to achieve that goal?
You need to ensure that users can update only the phone numbers by using this view
You have three tables that contain data for vendors, customers, and agents. You create a view that is
used to look up telephone numbers for these companies.
The view has the following definition:
You need to ensure that users can update only the phone numbers by using this view.
What should you do?
Which action should you perform?
You are a professional level SQL Sever 2008 Database. A new database application is
hosted by the instance. The security requirements should be designed for the application. A
unique login to the SQL Server 2008 server is assigned to each application user. Stored
procedures are included by the application database to execute stored procedures in the
MSDB database. SQLAgent jobs are scheduled by the stored procedures in the MSDB
database. Since you are the technical support, you are required to confirm that the stored
procedures in the MSDB database should be executed by utilizing the security context of
the application user. Which action should you perform?
what action should you perform?
You are a database developer and you have about two years experience in creating
business Intelligence (BI) by using SQL Server2008. Now you are employed in a company
named NaproStar which uses SQL Server2008. Your company makes and sells Cars. You
work as the technical support. Now you are in charge of a SQL Server 2008 Analysis
Services (SSAS) database. Tim is the distributor of the Southern Area. Now according to the
business requirement, Tim has to access the database. After discussion, your company
decides to give Tim the necessary permissions. There are two roles respectively named
Southern Area and Cars. The table below shows the schemas of the two roles. For both
roles, you have set the Visual Totals property to True. Now you get another order from the
company, according to the company requirement, Tim can only be able to view the members
in the Product dimension that relate to the Cars category in the Southern Area. You have to
accomplish this task. So what action should you perform?
What action should you perform to accomplish the tasks above?
You are a database developer and you have about two years experience in creating
business intelligence (BI) solutions by using SQL Server2008. Now you are employed in a
company which is named NaproStar and work as the technical support for the company
which uses SQL Server2008. To meet the business development, you create a SQL Server
2008 Analysis Server (SSAS) solution, which has a measure named ProductQuantity and a
price dimension named DimPrice along with a hierarchy named Price. Then the code
segment is added to the calculation script of the cube as the following: (Line letters are used
only for reference.) Now you get an order from your manager to accomplish the following
tasks:
1. Increase the value of the ProductionQuantity measure by 60% for each month in the
fourth quarter of 2006.
2. Keep the value for the fourth quarter of 2006 unchanged.
What action should you perform to accomplish the tasks above?