SUBJECTS
|
BROWSE
|
CAREER CENTER
|
POPULAR
|
JOIN
|
LOGIN
Business Skills
|
Soft Skills
|
Basic Literacy
|
Certifications
About
|
Help
|
Privacy
|
Terms
Search
Test your basic knowledge |
SQL Server
Start Test
Study First
Subject
:
it-skills
Instructions:
Answer 50 questions in 15 minutes.
If you are not ready to take this test, you can
study here
.
Match each statement with the correct term.
Don't refresh. All questions and answers are randomly picked and ordered every time you load a test.
This is a study tool. The 3 wrong answers for each question are randomly chosen from answers to other questions. So, you might find at times the answers obvious, but you will see it re-enforces your understanding as you take the test each time.
1. When a ________ completes - the different states it can be in are: Succeeded or Failed.
The /VA option.
control flow task
TextBox
dtutil.exe
2. Programming language that can be used to create embedded functions in Reporting Services?
VB .net
The /VA option.
Image Properties
The RS: Prefix
3. You have deployed several packages to a SQL Server instance. You open SSMS and you want to execute one of the packages stored in the package store. Which utility will SSMS use to execute the package?
a control flow
tabular
Command Line
DTExecUI
4. The 9 tasks that are availible for system-level roles: 1.Execute _________ 2. Generate Reports 3.Manage Jobs 4. Manage Report Server Properties 5.Manage Report Server Security 6. Manage Roles 7. Manage Shared Schedules 8. View Report Server Propertie
Kerberos authentication
Report Definitions
group tasks together
The TextDecoration property.
5. Objectives related to implementing _________: Debugging data flow and implementing the appropriate data flow components
OnPostExecute
Report Designer
administer
a data flow
6. Objectives related to implementing _________: Checkpoints. Debug control flow. Transactions. Implementing the appropriate control flow task to solve a problem. Data profiling and quality.
tabular
a control flow
Developer
VB .net
7. The SSIS package you are developing includes a Data Flow task that copies several million rows. The data flow requires a match against a reference table that contains 10 -000 rows. Each row in the reference table will be used during the data flow. Yo
Sequence
PageSize
document map
Lookup transformation along with the Full cache option.
8. Both a matrix and a table can summarize data in the same manor. A matrix however has a _______ number of columns. Whereas a table has a fixed number of columns.
functionality.
The /VA option.
document map
variable
9. Which page in the report manager is used to configure item-level role definitions on reports?
a data flow
rendering extensions
VB .net
The Site Settings webpage.
10. Objectives related to Implementing an ________: 1.Implementing Control Flow.2.Implementing Data Flow.3.Implement package logic by using variables. 4.Implement dynamic package behavior by using property expressions. 5.Implement package configurations.
Processing rights
Sequence
Developer
SSIS solution
11. To display a hyperlink in a report such that a user can click it an goto a destination - Create a text box item - set the action to _____ - and configure the URL.
variable
Jump to URL
TextBox
The Data Viewer tool.
12. To use BIDS to deploy a report to a different server than the one you chose in the Report Wizard you can change the server uRL by right-clicking the project in Solution Explorer and then change the ______________
SSIS solution
SSIS
Target-Server uRL property
The 'Alter Mining Structure DMX' statement.
13. Control flow tasks perform operations - while coordinate and group tasks.
containers
ASP.net timeout
dtutil.exe
administer
14. When you drag an image item from the Toolbox window to the Report Designer - the ________ dialog box automatically opens.
PageSize
Jump to URL
DTExecUI
Image Properties
15. Objects from the toolbox that you can add to a report through the report wizard: Table - Matrix - and _______.
TextBox
VB .net
Report Designer
Jump to URL
16. A user can be assigned __________ to a database without the ability to see the data or schema
Developer
Processing rights
Image Properties
RS.exe
17. Which property tab would you use to get the command line generated by DTExecUI?
Command Line
The 'Alter Mining Structure DMX' statement.
The Data Viewer tool.
The AggregationPrefix Property.
18. Which utility is used to move - copy and delete SSIS packages?
OnPostExecute
dtutil.exe
tabular
Report Designer
19. You can use a ________ in a report to provide users with a way to navigate to certain areas of the report.
1
Target-Server uRL property
document map
DTExecUI
20. To troubleshoot a report from users that a report times out you must check time out values of Report execution time-out (stored on the report server) and the _______ set in the report server configuration file.
ASP.net timeout
Developer
Report Definitions
Sequence
21. The two types of _____ availible in SSRS: Item-Level and System-Level
functionality.
1
rendering extensions
roles
22. Because only the Adobe PDf file - Word - and Image rendering extensions use physical page breaks - they are the only formats that are affected by the ________
SSIS solution
PageSize
Jump to URL
The 'Alter Mining Structure DMX' statement.
23. The three components which are contained in a cube: Dimensions - Attributes - and _________.
Measures
RS.exe
Report Definitions
roles
24. Report items that display repeated rows of summarized information from datasets.
containers
Data regions
a data flow
Image Properties
25. To configure an amount to display a value in a currency format - select the report item - and then set the _______ to C or c.
The Match index Table.
Kerberos authentication
format property
PageSize
26. If data mining models need to share the same structure you can compare them using the ________________ lift chart
variable
RS.exe
Command Line
functionality.
27. ___________ that support the document map are: HTML -PDF and Word
a control flow
The Match index Table.
rendering extensions
Sequence
28. Objectives related to ____________:1.Install and maintain SSIS components. 2.Deploy an SSIS solution. 3.Manage SSIS package execution. 4.Configure SSIS security settings. 5.Identify and resolve issues related to SSIS solution deployment. Configuring
Process Full
SSIS
SSIS solution
variable
29. You have created a measure group named FutureSales. You want to specify a default initial name for all the partitions created for the FutureSales measure group. Which property should you use to specify this?
Jump to URL
The AggregationPrefix Property.
containers
The RS: Prefix
30. To enable ________ - you must set the application's connection to Delegate.
Target-Server uRL property
1
Image Properties
Kerberos authentication
31. Using DMX - how can you add a mining model to an existing structure so that you can share the structure with other models?
32. To generate a report that is formatted as a chart you must create the chart report directly by using the __________
Report Designer
Measures
Image Properties
The /VA option.
33. The three types of control flow objects: ____. Containers. Constraints.
The Match index Table.
The TextDecoration property.
Tasks
OnPostExecute
34. Data flow task that can UPDATE rows in a database.
The Match index Table.
SSIS solution
DTExecUI
OLE DB Command Transformation.
35. You have created a sales report in Reporting Services. The report shows sales details for each employee of the company. You have created an aggregate expression to calculate the total sales of the company. You want to modify the aggregated field and
Create linked reports for each region.
functionality.
The TextDecoration property.
variable
36. The three primary containers in SSIS: ________ Containers. For Loop Containers. ForEach Loop Containers.
The TextDecoration property.
group tasks together
Sequence
format property
37. The regional sales directors of your company do not have access to any sales reports. The national directors have sales reports which you must base your regional reports from. The regional sales directors will not have security access the the nationa
dtutil.exe
RS.exe
Create linked reports for each region.
group tasks together
38. The purpose of a control flow container in SSIS? is to ____________ and control how they execute.
dtutil.exe
roles
group tasks together
Data regions
39. Which table will be created for the fuzzy lookup task for the package to hold information needed for calculating the similarity scores?
rendering extensions
tabular
OLE DB Command Transformation.
The Match index Table.
40. You have a SSAS database that contains several dimensions and two cubes. You must process the database periodically to bring it up to date with the data changes in the data source. You want to process all database objects with minimum effort. Which d
Process Full
VB .net
a data flow
Image Properties
41. SQL server which support data driven subscriptions: Evaluation - _______ - and Enterprise.
The Match index Table.
The Star Schema.
Developer
control flow task
42. A user can be assigned security rights to be an administrator of an SSAS database but not ______ of the entire SSAS instance
ASP.net timeout
Command Line
administer
functionality.
43. The three SSRS comand-line utilities: 1.RSConfig.exe 2. RSKeyMgmt.exe 3. ___________
document map
Command Line
PageSize
RS.exe
44. The Report Wizard lets you create only _______ and matrix reports.
administer
tabular
The Star Schema.
Report Definitions
45. Which prefix is used in the URL to make a request of the report server?
containers
The RS: Prefix
PageSize
format property
46. You are designing a SQL Server Integration Services (SSIS) package. On the Control Flow tab in SSIS Designer - you have a File System task. You would like to write to a SQL log table after each time the File System task completes.
OnPostExecute
Data regions
The RS: Prefix
Jump to URL
47. The Import and Export Wizard can only handle ___ source and 1 destination file.
1
Lookup transformation along with the Full cache option.
The RS: Prefix
Sequence
48. Which option is used with the dtexec utility to test stored packages?
The /VA option.
a data flow
dtutil.exe
tabular
49. Which type of schema is represented when one fact table is joined with two dimension tables in a many to many relationship?
The Match index Table.
Target-Server uRL property
The Star Schema.
Kerberos authentication
50. You design a SSIS package that contains several data flows. You need to monitor the data that passes through each path in the data flow by using BIDS. You also need to ensure that data flow logic is retained. What should you do?
The Data Viewer tool.
The /VA option.
Processing rights
Create linked reports for each region.